transaction block: server closed the connection unexpectedly
От | Koju Iijima |
---|---|
Тема | transaction block: server closed the connection unexpectedly |
Дата | |
Msg-id | 015601c493dc$8cf71df0$b44bac89@maheshs обсуждение исходный текст |
Ответы |
Re: transaction block: server closed the connection unexpectedly
|
Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: