am Wed, dem 12.12.2007, um 14:43:55 +0100 mailte Pavel Stehule folgendes:
> Hello
>
> you can use pg_sleep function. But using it in trigger is ugly,
> because transaction stay in open state. Look to orafce on intersession
> communication. Maybe you can use it.
other solution (vaguely): LISTEN/N
Hello
you can use pg_sleep function. But using it in trigger is ugly,
because transaction stay in open state. Look to orafce on intersession
communication. Maybe you can use it.
http://www.pgsql.cz/index.php/Oracle_functionality_%28en%29
Regards
Pavel Stehule
On 12/12/2007, Ottavio Campana <[EM
I'd like to execute a stored procedure in postgresql one minute after a
table has been modified. In case there are two changes in less than one
minute, I want to reset the time that has to be waited before running
the procedure.
I think I need to use a trigger, but I don't know how...
Can you hel
