| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | Philip Warner <pjw(at)rhyme(dot)com(dot)au>, Merlin Moncure <merlin(dot)moncure(at)rcsonline(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Does psql use nested transactions? |
| Date: | 2004-08-17 17:39:40 |
| Message-ID: | 6244.1092764380@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Added to TODO list:
> * Add an option to automatically use savepoints for each statement in a
> multi-statement transaction.
> When enabled, this would allow errors in multi-statement transactions
> to be automatically ignored.
Note that whoever implements this had better be mindful of the bad
experience we had with autocommit. If there is any way that this
behavior could be turned on underneath an application/script without
the app knowing about it, this would be spectacularly dangerous.
Like I said, my preference would be that it couldn't be turned on at all
except when psql's input is interactive.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gaetano Mendola | 2004-08-17 17:58:26 | Re: Does psql use nested transactions? |
| Previous Message | Bruce Momjian | 2004-08-17 17:14:45 | Re: Does psql use nested transactions? |