Hosting Provided By

Re: [GENERAL] executing a procedure with delay

From: A. Kretschmer <andreas.kretschmer(at)schollglas.com>
Date: Wed Dec 12 2007 - 08:58:52 EST

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/NOFIFY and an external prozess.

Andreas

-- 
Andreas Kretschmer
Kontakt:  Heynitz: 035242/47150,   D1: 0160/7141639 (mehr: -> Header)
GnuPG-ID:   0x3FFF606C, privat 0x7F4584DA   
http://wwwkeys.de.pgp.net

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Received on Wed Dec 12 09:00:13 2007

This message: [ Message body ]
Next message: Richard Huxton: "Re: [GENERAL] Function to convert from TEXT to BYTEA?"
Previous message: Richard Broersma Jr: "Re: [GENERAL] Creating Aggregate functions in PLpgSQL"
In reply to: Pavel Stehule: "Re: [GENERAL] executing a procedure with delay"

Contemporary messages sorted: [ By Date ] [ By Thread ] [ By Subject ] [ By Author ] [ By messages with attachments ]

This archive was generated by hypermail 2.1.8 : Mon Jun 16 2008 - 22:03:33 EDT