ran an update outside of transaction, can i roll it back in anyway ?

From: "Jeff MacDonald" <jeff(at)interchange(dot)ca>
To: <pgsql-general(at)postgresql(dot)org>
Subject: ran an update outside of transaction, can i roll it back in anyway ?
Date: 2003-04-17 15:24:42
Message-ID: FJENKCLABGGBKBDGHOJJKEOBCAAA.jeff@interchange.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

This morning in a sleepy daze I typed

UPDATE boo SET foo = 6;

at the psql console. i meant to type

UPDATE boo SET foo = 6 WHERE x = 10;

I did not have this in a transaction, and have not vacuumed since
I pressed enter.

This is on PostgreSQL 7.2.4 on i386-unknown-freebsd4.7, compiled by GCC
2.95.3

Is there anyway that I can retrieve this data ?

[Please don't preach about backups, I've already
fwapped myself for that one]

Thanks folks,

Jeff.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2003-04-17 15:38:18 Re: problem with pl/pgsql
Previous Message Dave Cramer 2003-04-17 15:19:26 qualified column names