Lists: | pgsql-general |
---|
From: | John Gunther <postgresql(at)bucksvsbytes(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | automatic rollback? |
Date: | 2007-08-16 17:27:52 |
Message-ID: | 46C48918.9090701@bucksvsbytes.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
After using PostgreSQL 8.1 and earlier versions for years, I'm suddenly
encountering a vexing problem. A certain kind of update and insert is
frequently reverting to its original condition after a day or two -- the
inserted record is gone and the updated one is back the way it was.
There seems to be no code in the application that could be doing this.
I know this is a long shot but is there any way the changes could be
getting rolled back automatically? I'm not using any explicit COMMIT,
ROLLBACK, or SAVEPOINT statements.
John Gunther
From: | Michael Glaesemann <grzm(at)seespotcode(dot)net> |
---|---|
To: | John Gunther <postgresql(at)bucksvsbytes(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: automatic rollback? |
Date: | 2007-08-16 17:47:13 |
Message-ID: | AED53D4D-3205-4834-B87F-595CFC419214@seespotcode.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-general |
On Aug 16, 2007, at 12:27 , John Gunther wrote:
> After using PostgreSQL 8.1 and earlier versions for years, I'm
> suddenly encountering a vexing problem. A certain kind of update
> and insert is frequently reverting to its original condition after
> a day or two -- the inserted record is gone and the updated one is
> back the way it was. There seems to be no code in the application
> that could be doing this.
What is this certain kind of update or insert? If it's visible to
other database queries (that aren't in the same transaction), it's
been committed. I suspect there's something in the code that you
haven't found yet--or maybe some kind of restore procedure from an
earlier backup?
Can you provide a reproducible test case?
Michael Glaesemann
grzm seespotcode net