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