DDL and transactions - Mailing list pgsql-bugs

From sad
Subject DDL and transactions
Date
Msg-id 200308221758.49558.sad@bankir.ru
Whole thread Raw
Responses Re: DDL and transactions  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Why does a DDL command starts a transaction ?!

try
# set autommit=3Doff;
SET
# create table a (i int);
CREATE TABLE
# create table b (i int);
ERROR:  current transaction is aborted, queries ignored until end of=20
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 ?

pgsql-bugs by date:

Previous
From: Bernd vd Brincken
Date:
Subject: Re: Postgre connection management
Next
From: Rod Taylor
Date:
Subject: Re: Postgre connection management