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
               List of relations
 Schema |      Name      |   Type    | Owner
----------+---------------+-----------+-------
 public   | a                  | table       | pgsql
 public   | b                  | sequence | pgsql

Dont you find curious a commiting of a DDL ?


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to