Re: [HACKERS] DROP TABLE inside transaction block - Mailing list pgsql-hackers

From Andreas Zeugswetter
Subject Re: [HACKERS] DROP TABLE inside transaction block
Date
Msg-id 37D4BE20.1DAF4753@telecom.at
Whole thread Raw
In response to [HACKERS] DROP TABLE inside transaction block  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
>> In short, a lot of work for a very marginal feature.  How many other
>> DBMSes permit DROP TABLE to be rolled back?  How many users care?
>
> Oracle auto-commits current in-progress transaction before
> execution of any DDL statement and executes such statements in
> separate transaction.

Informix does allow rollback of ddl statements.

Andreas


pgsql-hackers by date:

Previous
From: Yann-Ju Chu
Date:
Subject: problem about message type 0x45
Next
From: José Soares
Date:
Subject: Re: [HACKERS] SELECT BUG