The following bug has been logged online:

Bug reference: 2812
Logged by: Alex Piyevsky
Email address: Alex_Piyevsky (AT) ibi (DOT) com
PostgreSQL version: 8.0.1
Operating system: Linux Kernel-2.4.21-glibc-2.3.2 x86 32bit
Description: Transaction is aborted after error
Details:

We issue a command which drops the existing table and recreates the table
under the same name, all in one transaction. If the table does not
previously exist, an error message is returned for the drop command and the
transaction aborts with the following:

current transaction is aborted, commands ignored until end of transaction
block

please advise

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Alex Piyevsky wrote:

This is the intended behavior. In 8.2 you can use "DROP TABLE IF
EXISTS". In previous versions you can set a savepoint before the DROP
TABLE; or you can do the DROP TABLE outside the transaction.

--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Thank you for your help and prompt response.

Regards,
Alex

-----Original Message-----
From: Alvaro Herrera [mailto:alvherre (AT) commandprompt (DOT) com]=20
Sent: Wednesday, December 06, 2006 5:43 PM
To: Piyevsky, Alex
Cc: pgsql-bugs (AT) postgresql (DOT) org
Subject: Re: [BUGS] BUG #2812: Transaction is aborted after error

Alex Piyevsky wrote:

This is the intended behavior. In 8.2 you can use "DROP TABLE IF
EXISTS". In previous versions you can set a savepoint before the DROP
TABLE; or you can do the DROP TABLE outside the transaction.

--=20
Alvaro Herrera
http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly