Thank you for your help and prompt response. Regards, Alex
-----Original Message----- From: Alvaro Herrera [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 06, 2006 5:43 PM To: Piyevsky, Alex Cc: pgsql-bugs@postgresql.org Subject: Re: [BUGS] BUG #2812: Transaction is aborted after error 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 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
