The Toolkit for Online Communities
17474 Community Members, 1 member online, 2584 visitors today
Log In Register
OpenACS Home : Forums : OpenACS Q&A : postgresql triggers : One Message

Forum OpenACS Q&A: Re: postgresql triggers

2: Re: postgresql triggers (response to 1)
Posted by Matthew Geddert on
why are you trying to do this via a postgresql trigger as opposed to using a service contract via the tcl api (which notifications was designed to do)? Take a look at the way forums integrates with notifications - that is how it is "supposed" to be done. If you have a very compelling reason to do this via a trigger then you probably want ot use NEW.field1, NEW.field2 as placeholders in your proc to submit that info to notifications.... do a grep through packages like this for an example...
/web/service/packages/# grep -R "NEW." * | grep "/postgres"