DDL and transactions

From: sad <sad(at)bankir(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: DDL and transactions
Date: 2003-08-22 13:58:49
Message-ID: 200308221758.49558.sad@bankir.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 ?

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Rod Taylor 2003-08-22 13:59:14 Re: Postgre connection management
Previous Message Bernd vd Brincken 2003-08-22 13:52:10 Re: Postgre connection management