| From: | Holger Marzen <holger(at)marzen(dot)de> |
|---|---|
| To: | Doug McNaught <doug(at)wireboard(dot)com> |
| Cc: | Martijn van Oosterhout <kleptog(at)svana(dot)org>, "Samuel J(dot) Sutjiono" <ssutjiono(at)wc-group(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Performance issues with compaq server |
| Date: | 2002-05-09 11:23:17 |
| Message-ID: | Pine.LNX.4.44.0205091321110.4909-100000@bluebell.marzen.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-sql |
On 9 May 2002, Doug McNaught wrote:
> Holger Marzen <holger(at)marzen(dot)de> writes:
>
> > Is there a rule in SQL standards that describes what should happen if
> > some statemens in a transaction fail and the program issues a commit?
>
> I think PG's is standard behavior; that's kind of the whole point of
> having transactions.
- rolling back the whole transaction if you do a COMMIT
or
- keeping the changes until the first failing statement and ignoring
everything that follows if you do a COMMIT
?
--
PGP/GPG Key-ID:
http://blackhole.pca.dfn.de:11371/pks/lookup?op=get&search=0xB5A1AFE1
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Marzen | 2002-05-09 11:24:12 | Re: Performance issues with compaq server |
| Previous Message | Curt Sampson | 2002-05-09 07:11:59 | Re: Performance issues with compaq server |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Holger Marzen | 2002-05-09 11:24:12 | Re: Performance issues with compaq server |
| Previous Message | Gabriel Dovalo Carril | 2002-05-09 10:38:00 | Can this query be faster? |