Thread: create/alter/drop within transactions?

create/alter/drop within transactions?

From
Forest Wilkinson
Date:
Sorry if this is a FAQ, but I didn't find a definitive and recent
answer in the list archives or the postgres docs.  Do transactions
work on create / alter / drop statements?  In other words, can I
choose to commit or rollback after a bunch of schema changes?



Re: create/alter/drop within transactions?

From
Rajesh Kumar Mallah
Date:
On Fri, 25 Apr 2003, Forest Wilkinson wrote:

Yes it does.

As explain by Tom , TRUNCATE IS the only
command which cannot be done inside a transaction.
even that restriction will go away in 7.4 version

Regds
Mallah

> Sorry if this is a FAQ, but I didn't find a definitive and recent
> answer in the list archives or the postgres docs.  Do transactions
> work on create / alter / drop statements?  In other words, can I
> choose to commit or rollback after a bunch of schema changes?
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
> http://archives.postgresql.org
>