X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D7525475C3D for ; Fri, 25 Apr 2003 20:58:48 -0400 (EDT) Received: from luna.lyris.com (luna.lyris.com [216.91.57.116]) by postgresql.org (Postfix) with ESMTP id 27BB9474E42 for ; Fri, 25 Apr 2003 20:58:48 -0400 (EDT) Received: from luna.lyris.com (luna.lyris.com [216.91.57.116]) by luna.lyris.com (8.12.8/8.12.8) with SMTP id h3Q0wpw2016847 for ; Fri, 25 Apr 2003 17:58:51 -0700 Received: from forestpc (forest.lyris.com [216.91.56.45]) by luna.lyris.net with SMTP (MailShield v2.04 - LINUX Jul 17 2001 16:58:31); Fri, 25 Apr 2003 17:58:51 -0700 From: Forest Wilkinson To: pgsql-sql@postgresql.org Subject: create/alter/drop within transactions? Date: Fri, 25 Apr 2003 17:58:46 -0700 Message-ID: X-Mailer: Forte Agent 1.93/32.576 English (American) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable X-SMTP-HELO: forestpc X-SMTP-MAIL-FROM: lyris-pg@tibit.com X-SMTP-RCPT-TO: pgsql-sql@postgresql.org X-SMTP-PEER-INFO: forest.lyris.com [216.91.56.45] X-Spam-Status: No, hits=-5.8 required=5.0 tests=BAYES_10 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/385 X-Sequence-Number: 13086 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?