Hi
While testing 8.0's transaction mechanism, I encountered this error:
(I can reproduce this error with the latest cvs codes)
========================================================================
Welcome to psql 8.0.0beta2, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit
template1=# BEGIN;
BEGIN
template1=# CREATE TABLE FOO ( a int unique);
NOTICE: CREATE TABLE / UNIQUE will create implicit index "foo_a_key" for
table
"foo"
CREATE TABLE
template1=# INSERT INTO FOO VALUES ( 0 );
INSERT 17232 1
template1=# INSERT INTO FOO VALUES ( 0 );
ERROR: duplicate key violates unique constraint "foo_a_key"
FATAL: block 1 of 1663/1/17230 is still referenced (private 1, global 1)
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
template1=#
========================================================================
This error cann't be reproduced If the CREATE TABLE is called outside the
transaction block.
Regards
koju
----------------------------------------------------------------------------
---
Koju Iijima
Software Engineer
Fujitsu Australia Software Technology
Address: 14 Rodborough Road, Frenchs Forest NSW 2086
Tel: +61 2 9452 9076
Fax: +61 2 9975 2899
Email: koju@fast.fujitsu.com.au
Web site: www.fastware.com
----------------------------------------------------------------------------
---
This is an email from Fujitsu Australia Software Technology Pty Ltd, ABN 27 003 693 481. It is confidential to the
ordinaryuser of the email address to which it was addressed and may contain copyright and/or legally privileged
information.No one else may read, print, store, copy or forward all or any of it or its attachments. If you receive
thisemail in error, please return to sender. Thank you.
If you do not wish to receive commercial email messages from Fujitsu Australia Software Technology Pty Ltd, please
emailunsubscribe@fast.fujitsu.com.au
