Alex Piyevsky wrote:
> 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
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.
