Re: Table creation in transactions

From: Darren Ferguson <darren(at)crystalballinc(dot)com>
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 20:22:34
Message-ID: Pine.LNX.4.44.0208061622120.29870-100000@thread.crystalballinc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

It will be dropped since it was part of the transaction and when you
rollback it will be removed

HTH

On Tue, 6 Aug 2002, 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?
> Thank you all,
> Mihai
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>

--
Darren Ferguson

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Markus Wollny 2002-08-06 20:40:32 Re: URGENT: Database keeps crashing - suspect damaged RAM
Previous Message John Gray 2002-08-06 19:58:16 Re: Table creation in transactions