Re: Table creation in transactions

From: John Gray <jgray(at)azuli(dot)co(dot)uk>
To: Mihai Gheorghiu <tanethq(at)earthlink(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Table creation in transactions
Date: 2002-08-06 19:58:16
Message-ID: 1028663899.17628.50.camel@adzuki
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, 2002-08-06 at 20:55, Mihai Gheorghiu wrote:
> I have a transaction in which a table is created at some point.
> If the transaction is rolled back, does the table remain, or is it
> automatically dropped?
It is dropped when the transaction is rolled back. I believe that old
(pre 7.0? ) versions of PG had problems with creating tables in a
transaction, but this hasn't been the case for a while.

Regards

John

--
John Gray
Azuli IT
www.azuli.co.uk

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Darren Ferguson 2002-08-06 20:22:34 Re: Table creation in transactions
Previous Message Mihai Gheorghiu 2002-08-06 19:55:15 Table creation in transactions