Re: Table creation in transactions - Mailing list pgsql-general

From John Gray
Subject Re: Table creation in transactions
Date
Msg-id 1028663899.17628.50.camel@adzuki
Whole thread Raw
In response to Table creation in transactions  ("Mihai Gheorghiu" <tanethq@earthlink.net>)
List 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



pgsql-general by date:

Previous
From: "Mihai Gheorghiu"
Date:
Subject: Table creation in transactions
Next
From: Darren Ferguson
Date:
Subject: Re: Table creation in transactions