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