Transaction started test - Mailing list pgsql-general

From Larry Anderson
Subject Transaction started test
Date
Msg-id 4B2E205C.8050200@blueyonder.co.uk
Whole thread Raw
Responses Re: Transaction started test  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general

Hi All,

I'm new to Postgres and need a way to test if a transaction is already in progress.

The test will take place inside a trigger function in pl/pgsql and will start a new transaction only if one is not in progress ie started by a previous trigger that cascaded through to this trigger. Cannot find any such function in the docs.

Any help much appreciated.

Best regards


Larry Anderson

pgsql-general by date:

Previous
From: Craig Ringer
Date:
Subject: Re: Extracting SQL from logs in a usable format
Next
From: Craig Ringer
Date:
Subject: Re: Transaction started test