Postgres Pro
Downloads
Home   >   mailing lists

Re: Transaction commit in a trigger function - Mailing list pgsql-general

From PFC
Subject Re: Transaction commit in a trigger function
Date
Msg-id op.tshjie14cigqcu@apollo13
Whole thread Raw
In response to Transaction commit in a trigger function  ("Henka" <henka@cityweb.co.za>)
Responses Re: Transaction commit in a trigger function
List pgsql-general
Tree view 

> 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

pgsql-general by date:

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