| From: | Rajesh Kumar Mallah <rmallah(at)trade-india(dot)com> |
|---|---|
| To: | Forest Wilkinson <forest(at)lyris(dot)com> |
| Cc: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | Re: create/alter/drop within transactions? |
| Date: | 2003-04-26 17:16:11 |
| Message-ID: | Pine.LNX.4.33.0304262244290.1473-100000@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tatsuo Ishii | 2003-04-27 00:53:30 | Re: sorting chinese characters |
| Previous Message | Rajesh Kumar Mallah | 2003-04-26 16:37:14 | Re: /* */ comments showing up in pg_stat_activity |