Received: from e4500a.callatg.com (e4500a.atgi.net [216.174.194.60]) by postgresql.org (8.11.3/8.11.1) with SMTP id f63Mxba26351 for ; Tue, 3 Jul 2001 18:59:37 -0400 (EDT) (envelope-from jason_watkins@pobox.com) Received: (qmail 5833 invoked from network); 3 Jul 2001 22:59:33 -0000 Received: from unknown (HELO boondocksaint) (64.42.111.66) by e4500a.callatg.com with SMTP; 3 Jul 2001 22:59:33 -0000 Message-ID: <01a301c10414$9cb06ef0$426f2a40@boondocksaint> From: "Jason Watkins" To: References: <20010703153823.P89242-100000@oddjob.adhesivemedia.com> Subject: Re: drop table if exists Date: Tue, 3 Jul 2001 16:05:11 -0700 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200107/30 X-Sequence-Number: 3811 Doesn't work. I like wrapping up the entire file in a transaction so that if I make a stupid syntax error or the like, I can just do a rollback. Because of that, the transaction enters abort state. I suppose I can just stop using transactions and use this method.