From: | Garrett Bladow <bbladow(at)sendit(dot)nodak(dot)edu> |
---|---|
To: | Steven Ames <steve(at)virtual-voodoo(dot)com> |
Cc: | pgsql-novice <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: Undoing a typo? |
Date: | 2002-12-10 17:02:01 |
Message-ID: | Pine.LNX.4.21.0212101055350.8878-100000@imap2.sendit.nodak.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
The clever way is called a transaction.
Before doing any data manipulation, start a transaction.
Like this:
BEGIN; http://developer.postgresql.org/docs/postgres/sql-begin.html
Then do your update statements;
Then if there was an error type:
ROLLBACK; http://developer.postgresql.org/docs/postgres/sql-rollback.html
This will revert you data back to the state it was in before the transaction.
If there wasn't an error and the data looks sound type:
COMMIT; http://developer.postgresql.org/docs/postgres/sql-commit.html
and the updates will be saved.
-- Garrett Bladow
---- This is what you wrote me ----
:This is a truly novice question but here goes:
:
:Yesterday I was on the command line and issued an UPDATE command. Right after I hit the ENTER key I realized that I forgot to put the WHERE clause in... so... every entry in the table got the update. Ooops. Since I hadn't updated this particular table in a while I just dropped it and put it back in from a backup.
:
:My question is... is there a clever way to undo or rollback a mistake you make at the 'psql' prompt?
:
:-Steve
:
From | Date | Subject | |
---|---|---|---|
Next Message | Ludwig Lim | 2002-12-10 17:09:47 | Re: How many connections can a Postgress database support... |
Previous Message | Steven Ames | 2002-12-10 16:39:07 | Undoing a typo? |