How feasible is this?

From: Chris Smith <cdsmith(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: How feasible is this?
Date: 2010-05-21 01:22:43
Message-ID: 1274404963.10988.6.camel@dell-desktop.example.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm writing in desperate hope that something like this exists... because
if so, it would make my life a lot easier. I want to be able to:

a) Roll back a transaction

b) Receive a notification when retrying the exact same transaction might
cause different data to be returned from something that was done up to
the point of the rollback; i.e., some result set, update count, etc.
might be different.

It's okay if (b) is overly sensitive. For example, one technically
correct (but disappointing) answer would be to get that notification
immediately on the rollback; but that would cause the application to
spin and retry the same transaction in a loop with no delays, which is
hardly ideal to say the least.

Any ideas on doing better than that?

--
Chris Smith

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Hunsberger 2010-05-21 02:33:23 Re: How to lose transaction history (xmin values, WAL, etc.)?
Previous Message Richard Walker 2010-05-21 01:11:00 Re: How to lose transaction history (xmin values, WAL, etc.)?