Re: Am I in the same transaction block in complex PLPGSQL?

You really do need to open a second session somehow if you want the first session to be able to fail while still allowing for stuff happening during its execution to commit.

You can either do this in client-side code by simply opening up two connections and doing the main work on one while doing the logging on the other.

As far as I know to do this in-database you would need to use the dblink extension:

While much of that module's purpose was subsumed by the addition of FOREIGN DATA WRAPPERS the ability to have a transaction independent connection back into the database was not one of those things - using FDW the remote work is done in the same transaction context as the local database.

David J.