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. ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
