| From: | Will Leinweber <will(at)heroku(dot)com> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | feature request: auto savepoint for interactive psql when in transaction. |
| Date: | 2011-09-27 23:57:52 |
| Message-ID: | CAL8LqZREAvS3egKTrnf-Y5vxyO-v=k=jdBes8GUieQjzsVHH+A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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.
—Will
bqjezaraxa=# select count(*) from transactions where log='';
ERROR: relation "transactions" does not exist
bqjezaraxa=# select count(*) from transfers where log='';
ERROR: current transaction is aborted, commands ignored until end of
transaction block
bqjezaraxa=# oh damn it ;
ERROR: syntax error at or near "oh"
LINE 1: oh damn it;
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Royce Ausburn | 2011-09-28 00:28:26 | Re: [PATCH] Addition of some trivial auto vacuum logging |
| Previous Message | Jamie Fox | 2011-09-27 23:19:38 | Mismatch of relation names: pg_toast.pg_toast_nnn during pg_upgrade from 8.4 to 9.1 |