Re: [RESEND] Transaction auto-abort causes grief with Spring Framework - Mailing list pgsql-general

From Alban Hertroys
Subject Re: [RESEND] Transaction auto-abort causes grief with Spring Framework
Date
Msg-id 46C57959.1010404@magproductions.nl
Whole thread Raw
In response to Re: [RESEND] Transaction auto-abort causes grief with Spring Framework  ("Webb Sprague" <webb.sprague@gmail.com>)
List pgsql-general
Webb Sprague wrote:
> I am not sure how you can insert into a log even with savepoints,
> unless you put the logging statement first and then follow it with the
> insert.

and delete it after success?

Alternatively you could use one connection for your normal queries, and
another for auditing. Your application will need twice as many
connections that way, though... In that case you shouldn't commit
records on the 'normal' connection before the audit records have been
committed I suppose?

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //

pgsql-general by date:

Previous
From: Jeff Amiel
Date:
Subject: Postmaster does not shut down
Next
From: rihad
Date:
Subject: serial grows on failed requests