Re: [GENERAL] Asynchronous queries - processing listen (notify) in a procedural language

2010-02-22 Thread Merlin Moncure
On Sun, Feb 21, 2010 at 10:32 PM, Merlin Moncure mmonc...@gmail.com wrote: On Sun, Feb 21, 2010 at 9:22 PM, Tom Lane t...@sss.pgh.pa.us wrote: Merlin Moncure mmonc...@gmail.com writes: On Sat, Feb 20, 2010 at 9:38 PM, Petr Chmelar chmel...@fit.vutbr.cz wrote: Is there a way how to listen and

Re: [GENERAL] Asynchronous queries - processing listen (notify) in a procedural language

2010-02-21 Thread Merlin Moncure
On Sat, Feb 20, 2010 at 9:38 PM, Petr Chmelar chmel...@fit.vutbr.cz wrote: Hi there, I'd like to make a real-time enabled database and I need to process data asynchronously. Usually, there are many quick inserts sometimes causing vast updates. I can't use triggers and rules because the

Re: [GENERAL] Asynchronous queries - processing listen (notify) in a procedural language

2010-02-21 Thread Tom Lane
Merlin Moncure mmonc...@gmail.com writes: On Sat, Feb 20, 2010 at 9:38 PM, Petr Chmelar chmel...@fit.vutbr.cz wrote: Is there a way how to listen and trigger the notify messages in the database (+-)immediately and/or to execute additional (trigger) queries in other transactions? The only way

Re: [GENERAL] Asynchronous queries - processing listen (notify) in a procedural language

2010-02-21 Thread Merlin Moncure
On Sun, Feb 21, 2010 at 9:22 PM, Tom Lane t...@sss.pgh.pa.us wrote: Merlin Moncure mmonc...@gmail.com writes: On Sat, Feb 20, 2010 at 9:38 PM, Petr Chmelar chmel...@fit.vutbr.cz wrote: Is there a way how to listen and trigger the notify messages in the database (+-)immediately and/or to

[GENERAL] Asynchronous queries - processing listen (notify) in a procedural language

2010-02-20 Thread Petr Chmelar
Hi there, I'd like to make a real-time enabled database and I need to process data asynchronously. Usually, there are many quick inserts sometimes causing vast updates. I can't use triggers and rules because the transactions are really long when there is the update (upgrade) needed. Is there a

Re: [GENERAL] Asynchronous queries - processing listen (notify) in a procedural language

2010-02-20 Thread Pavel Stehule
Hello look on orafce http://www.postgres.cz/index.php/Oracle_functionality_%28en%29 Regards Pavel Stehule 2010/2/21 Petr Chmelar chmel...@fit.vutbr.cz: Hi there, I'd like to make a real-time enabled database and I need to process data asynchronously. Usually, there are many quick inserts