Re: [BUGS] DDL and transactions

2003-08-22 Thread Tom Lane
sad <[EMAIL PROTECTED]> writes: > Dont you find curious a commiting of a DDL ? Only to someone who's used to inferior databases that cannot roll back DDL commands. regards, tom lane ---(end of broadcast)--- TIP 9: the planne

[BUGS] DDL and transactions

2003-08-22 Thread sad
Why does a DDL command starts a transaction ?! try # set autommit=off; SET # create table a (i int); CREATE TABLE # create table b (i int); ERROR: current transaction is aborted, queries ignored until end of transaction block # commit; COMMIT # create table b (i int); CREATE TABLE # \d