Re: Transaction aborts on syntax error. - Mailing list pgsql-hackers

From Jeroen T. Vermeulen
Subject Re: Transaction aborts on syntax error.
Date
Msg-id 20040212142628.GS94664@xs4all.nl
Whole thread Raw
In response to Re: Transaction aborts on syntax error.  ("Zeugswetter Andreas SB SD" <ZeugswetterA@spardat.at>)
Responses Re: Transaction aborts on syntax error.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Thu, Feb 12, 2004 at 09:55:36AM +0100, Zeugswetter Andreas SB SD wrote:
> 
> Yeah, but in other db's this is solved by the frontend. e.g. in Informix
> dbaccess has a mode that simply stops execution upon first error. So I don't 
> think this is a nogo argument, if we added such a feature to psql.
It does require that the application be meticulous in its checking though.
Existing client programs, for instance, may ignore any errors coming back
from PQexec() during the transaction and just see if the COMMIT succeeds.
Such could would break in very nasty ways with this change.


Jeroen



pgsql-hackers by date:

Previous
From: "Zeugswetter Andreas SB SD"
Date:
Subject: Re: Transaction aborts on syntax error.
Next
From: Bruce Momjian
Date:
Subject: Re: Request for additional SPI functions.