Skip site navigation (1) Skip section navigation (2)

Re: Undoing a typo?

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
The clever way is called a transaction.
Before doing any data manipulation, start a transaction.
Like this:

Then do your update statements;

Then if there was an error type:
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:
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? 

In response to

pgsql-novice by date

Next:From: Ludwig LimDate: 2002-12-10 17:09:47
Subject: Re: How many connections can a Postgress database support...
Previous:From: Steven AmesDate: 2002-12-10 16:39:07
Subject: Undoing a typo?

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group