Transaction started test

From: Larry Anderson <larrya(at)blueyonder(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org
Subject: Transaction started test
Date: 2009-12-20 13:02:20
Message-ID: 4B2E205C.8050200@blueyonder.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2009-12-20 13:19:13 Re: Extracting SQL from logs in a usable format
Previous Message hubert depesz lubaczewski 2009-12-20 11:59:20 Re: Extracting SQL from logs in a usable format