X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id CAAFC56488 for ; Sun, 27 Feb 2005 17:55:35 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 94086-05 for ; Sun, 27 Feb 2005 17:55:19 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.201]) by svr1.postgresql.org (Postfix) with ESMTP id EB6A756474 for ; Sun, 27 Feb 2005 17:55:25 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 68so811626wra for ; Sun, 27 Feb 2005 09:55:38 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=ON3k8EqTKxd6AfborUkzO91V1Fa+o5nSN0QTzyKix7v9NLc/MHssPXoKm3tlWSS6UWg3qA4JNmSd7/kOEfTL8aXM8WUFvsgzBeXUHOF16fKPvg15uAiwudmJK7nYcRjXmsxuI0WnM9DzhIprzY7+hLwL5nUhxx6cZ4IqaVInVLg= Received: by 10.54.54.78 with SMTP id c78mr2819wra; Sun, 27 Feb 2005 09:55:37 -0800 (PST) Received: by 10.54.4.71 with HTTP; Sun, 27 Feb 2005 09:55:37 -0800 (PST) Message-ID: <6c21003b0502270955673432e7@mail.gmail.com> Date: Sun, 27 Feb 2005 11:55:37 -0600 From: Don Drake Reply-To: Don Drake To: Michael Fuhr Subject: Re: AutoCommit and DDL Cc: pgsql-sql@postgresql.org In-Reply-To: <20050227042043.GB77382@winnie.fuhr.org> Mime-Version: 1.0 Content-Type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 7bit References: <6c21003b050226125634e9964@mail.gmail.com> <20050227042043.GB77382@winnie.fuhr.org> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.024 tagged_above=0 required=5 tests=RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200502/338 X-Sequence-Number: 20448 I know it's not failing, I have the server logging the commands and there are no errors. The only change made was turning AutoCommit on. -Don On Sat, 26 Feb 2005 21:20:43 -0700, Michael Fuhr wrote: > On Sat, Feb 26, 2005 at 02:56:52PM -0600, Don Drake wrote: > > > I turned AutoCommit on and re-ran the perl script and the tables get > > created. Why won't these table's get created when AutoCommit is off? > > Why do I have to commit DDL? > > If you're using DBI, are you using PrintError or RaiseError or > otherwise checking the success of each command? My first guess > would be that some command is failing (e.g., a DROP of an object > that doesn't exist), so the transaction is automatically rolled > back even though you requested a commit. > > -- > Michael Fuhr > http://www.fuhr.org/~mfuhr/ > -- Donald Drake President Drake Consulting http://www.drakeconsult.com/ http://www.MailLaunder.com/ 312-560-1574