Re: [GENERAL] ROLLBACK automatically

2000-07-25 Thread Peter Eisentraut
Chris Bitmead writes: > Is this behaviour some kind of standard? Can it be changed? In the past the answer to the question "Does a statement-level error warrant a transaction abort?" has usually hinged on the interpretation of the following clauses of the SQL92 standard. 3.3.4.1 Exceptions

Re: [GENERAL] ROLLBACK automatically

2000-07-24 Thread Sevo Stille
Kshipra wrote: > > hello all, > I would like to mention something in this regard. > I have executed all the commands given here in the same order, but what the > auther is saying that after insert fails whatever u have inserted rolls back, > this is not the case . > as all of us knows Postgre wor

Re: [GENERAL] ROLLBACK automatically

2000-07-24 Thread Alex Bolenok
> hello all, > I would like to mention something in this regard. > I have executed all the commands given here in the same order, but what the > auther is saying that after insert fails whatever u have inserted rolls back, > this is not the case . > as all of us knows Postgre works in autocommit m