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 gupta.a...@gmail.com 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

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

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 RPCs

[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