From: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
---|---|
To: | Petr Chmelar <chmelarp(at)fit(dot)vutbr(dot)cz> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Asynchronous queries - processing listen (notify) in a procedural language |
Date: | 2010-02-21 07:38:22 |
Message-ID: | 162867791002202338k18c21824s393a1477f86504b8@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hello
look on orafce
http://www.postgres.cz/index.php/Oracle_functionality_%28en%29
Regards
Pavel Stehule
2010/2/21 Petr Chmelar <chmelarp(at)fit(dot)vutbr(dot)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 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 way how to listen and trigger the notify messages in the
> database (+-)immediately and/or to execute additional (trigger) queries
> in other transactions?
>
> In Oracle there is ON COMMIT trigger and an anonymous transaction that
> allows commit inside triggers. However this is not possible in Postgres.
> Moreover I can't know the check interval of the listening procedures in
> an external application (can be anything from millis to days). I was so
> desperate that I was thinking about own logging function.
>
> Many thanks, Petr
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
From | Date | Subject | |
---|---|---|---|
Next Message | Andreas Kretschmer | 2010-02-21 08:38:29 | Re: How to count the number of items in an Array? |
Previous Message | Andre Lopes | 2010-02-21 03:20:35 | How to count the number of items in an Array? |