Re: [GENERAL] postgresql triggers - defining a global resource (java)

2011-12-27 Thread Merlin Moncure
On Mon, Dec 26, 2011 at 8:32 AM, Aman Gupta wrote: > Hey Alban, > > Thanks for the reply. I had a follow up question w.r.t listen/notify: > > I am planning to associate a NOTIFY with an update on a table - a trigger is > associated with the update, and we execute NOTIFY in the trigger code. The >

Re: [GENERAL] postgresql triggers - defining a global resource (java)

2011-12-26 Thread Aman Gupta
Hey Alban, Thanks for the reply. I had a follow up question w.r.t listen/notify: I am planning to associate a NOTIFY with an update on a table - a trigger is associated with the update, and we execute NOTIFY in the trigger code. The NOTIFY directly goes to a remote server and contains the updated

Re: [GENERAL] postgresql triggers - defining a global resource (java)

2011-12-24 Thread Alban Hertroys
On 23 Dec 2011, at 14:33, Aman Gupta wrote: > The problem statement is mentioned here: > http://stackoverflow.com/questions/8615408/postgresql-triggers-defining-a-global-resource-java > > I am looking for the "best" solution to that problem. That would be using LISTEN/NOTIFY. If you perform RPC

[GENERAL] postgresql triggers - defining a global resource (java)

2011-12-23 Thread Aman Gupta
The problem statement is mentioned here: http://stackoverflow.com/questions/8615408/postgresql-triggers-defining-a-global-resource-java I am looking for the "best" solution to that problem. Thanks, Aman