| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | simon(at)2ndquadrant(dot)com |
| Cc: | "'Andrej Czapszys'" <czapszys(at)comcast(dot)net>, "'Gavin Sherry'" <swm(at)linuxworld(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Transaction aborts on syntax error. |
| Date: | 2004-02-11 05:17:39 |
| Message-ID: | 15252.1076476659@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Simon Riggs" <simon(at)2ndquadrant(dot)com> writes:
> Most importantly, other references I have state that: the ANSI SQL-99
> specification does require that if a statement errors then only that
> statement's changes are rolled back.
No. The spec says
The execution of a <rollback statement> may be initiated implicitly
by an SQL-implementation when it detects unrecoverable errors.
and leaves it up to the implementation to define what is "unrecoverable".
Currently Postgres treats all errors as "unrecoverable". This is
certainly not ideal, but it is within the letter of the spec.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2004-02-11 08:21:24 | Re: Summary of Changes since last release (7.4.1) |
| Previous Message | Mike Mascari | 2004-02-11 01:13:30 | Re: Summary of Changes since last release (7.4.1) |