Re: Transaction commit in a trigger function

From: PFC <lists(at)peufeu(dot)com>
To: Henka <henka(at)cityweb(dot)co(dot)za>, pgsql-general(at)postgresql(dot)org
Subject: Re: Transaction commit in a trigger function
Date: 2007-05-17 19:09:40
Message-ID: op.tshjie14cigqcu@apollo13
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> I can't wrap BEGIN/COMMIT around the INSERT in the trigger. Is there
> another way of achieving this?

- Savepoints (won't work with your trigger approach)
- dblink would allow you to open another connection concurrently

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas 2007-05-17 19:10:17 Admin-Functions in Ubuntu's PG 8.2 missing?
Previous Message Hannes Dorbath 2007-05-17 19:04:14 Re: Fault Tolerant Postgresql (two machines, two postmasters, one disk array)