| From: | Sim Zacks <sim(at)compulab(dot)co(dot)il> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Invoke trigger after commit |
| Date: | 2007-05-10 12:50:21 |
| Message-ID: | f1v10b$16nj$1@news.hub.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Use a Listen/Notify daemon application and put the Notify on the last line of the transaction.
If it does the notify that means that the transaction was completed successfully.
Sim
Jan Strube wrote:
> Hi,
>
> is there a way to invoke a trigger only if the current transaction is
> committed?
> The problem is that my trigger does some kind of logging outside the
> database and therefore must not be invoked if the transaction is rolled
> back.
>
> Thanks in advance
> Jan
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christian Rolle | 2007-05-10 13:19:22 | schema of system tables |
| Previous Message | George Weaver | 2007-05-10 12:34:29 | Re: how to convert a string array to a string. fct array_to_string seem to work only for INT array?? |