On 2/15/07, RPK <[EMAIL PROTECTED]> wrote:
Is there any option in PGSQL to undo last changes done on a table? Any
feature similar to "FlashBack Query" in Oracle.
The only way I could imagine that you could implement a flashback query in
PostgreSQL is if you ignored everyone's advice and didn'
On Thursday 15 February 2007 10:30, RPK <[EMAIL PROTECTED]>
wrote:
> Rollback will just rollback to last step (if I am right), but is there a
> way to bring the table to a certain TimeStamp.
You can use a PITR backup to restore a fresh cluster to a time just before
your update. If you are not r
In my case, I did an accidental update on a large table where different
column values have changed. I continued working and found next day that
something wrong happened.
Rollback will just rollback to last step (if I am right), but is there a way
to bring the table to a certain TimeStamp.
Just i
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 02/15/07 02:29, RPK wrote:
> Is there any option in PGSQL to undo last changes done on a table?
Presumably, this is *after* you committed them?
> Any
> feature similar to "FlashBack Query" in Oracle.
>
-BEGIN PGP SIGNATURE-
Version: GnuP
RPK wrote:
>
> Is there any option in PGSQL to undo last changes done on a table?
Sure -- you just issue ROLLBACK to end your transaction instead of
COMMIT.
> Any feature similar to "FlashBack Query" in Oracle.
I don't know about that.
--
Alvaro Herrerahttp://w
Is there any option in PGSQL to undo last changes done on a table? Any
feature similar to "FlashBack Query" in Oracle.
--
View this message in context:
http://www.nabble.com/Option-to-undo-last-update-on-table.-tf3232456.html#a8981518
Sent from the PostgreSQL - general mailing list archive at N
