Excerpts from Will Leinweber's message of mar sep 27 20:57:52 -0300 2011: > I ruined a 5 hour UPDATE by typoing a table name on a SELECT to verify > the update worked. I suppose I have no one else to blame, but it was > really frustrating, to say the least. I assume this has happened to > others as well. > > I only later found out about SAVEPOINT, which I immediately ran the > next time I attempted the huge update. > > psql console, while in a transaction, and while in interactive mode, > should savepoint for me.
See ON_ERROR_ROLLBACK http://www.postgresql.org/docs/9.0/static/app-psql.html -- Álvaro Herrera <alvhe...@commandprompt.com> The PostgreSQL Company - Command Prompt, Inc. PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
