Re: [RESEND] Transaction auto-abort causes grief with Spring Framework

From: Alban Hertroys <alban(at)magproductions(dot)nl>
To: Webb Sprague <webb(dot)sprague(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [RESEND] Transaction auto-abort causes grief with Spring Framework
Date: 2007-08-17 10:32:57
Message-ID: 46C57959.1010404@magproductions.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)magproductions(dot)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 //

In response to

Browse pgsql-general by date

  From Date Subject
Next Message rihad 2007-08-17 10:51:42 serial grows on failed requests
Previous Message Jeff Amiel 2007-08-17 10:28:15 Postmaster does not shut down