Re: [BUGS] Transaction bug

2003-10-27 Thread Tom Lane
Brage =?iso-8859-1?Q?F=F8rland?= <[EMAIL PROTECTED]> writes: > If you send a transaction as a single query to the backend, it ignores the > commit if the transaction is aborted: This is not a bug, it is the intended behavior. An error causes processing of the current querystring to be abandoned.

[BUGS] Transaction bug

2003-10-27 Thread Brage Førland
If you send a transaction as a single query to the backend, it ignores the commit if the transaction is aborted: Example: testdb=# CREATE TEMP TABLE test(test INT PRIMARY KEY, CONSTRAINT testconstraint CHECK (test > 2) ); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index 'test_pkey