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 7398956458 for ; Mon, 28 Feb 2005 01:55:31 +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 02816-04 for ; Mon, 28 Feb 2005 01:55:14 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.203]) by svr1.postgresql.org (Postfix) with ESMTP id 8A5E05644E for ; Mon, 28 Feb 2005 01:55:19 +0000 (GMT) Received: by wproxy.gmail.com with SMTP id 68so877860wra for ; Sun, 27 Feb 2005 17:55:36 -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=Ai1KfzJp5Iq4TaY5NO3ah1X+fdezQUQ5l1cTw9gsxKDmaq60huzKe3KzgUnRAb++VEYa14IGwUKmZRR1s4tOXkGnSwPr8/pZhVoJM1Yis8r/5WgkrN8bg4qUXWdWOY9I1D3xn5rwGgG6X3zm+P5yCyCJuEU71PkcTyg0V92yKzY= Received: by 10.54.44.40 with SMTP id r40mr93654wrr; Sun, 27 Feb 2005 17:55:36 -0800 (PST) Received: by 10.54.4.71 with HTTP; Sun, 27 Feb 2005 17:55:35 -0800 (PST) Message-ID: <6c21003b0502271755fb9b917@mail.gmail.com> Date: Sun, 27 Feb 2005 19:55:35 -0600 From: Don Drake Reply-To: Don Drake To: Michael Fuhr Subject: Re: AutoCommit and DDL Cc: pgsql-sql@postgresql.org In-Reply-To: <20050227195434.GA21745@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> <6c21003b0502270955673432e7@mail.gmail.com> <20050227195434.GA21745@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/343 X-Sequence-Number: 20453 I did some traces and it all looks OK. The problem has to do with multiple concurrent connections to the server causing problems. I've removed the concurrent connections and now this works. Strange. -Don On Sun, 27 Feb 2005 12:54:34 -0700, Michael Fuhr wrote: > On Sun, Feb 27, 2005 at 11:55:37AM -0600, Don Drake wrote: > > > 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. > > Have you used any of DBI's tracing capabilities? Could you post a > simple test case? The following works for me with Perl 5.8.6, DBI > 1.47, DBD::Pg 1.32, and PostgreSQL 7.4.7 on FreeBSD 4.11-STABLE: > > #!/usr/bin/perl > > use strict; > use warnings; > use DBI; > > my $dbh = DBI->connect("dbi:Pg:dbname=test", "mfuhr", "", {AutoCommit => 0}); > $dbh->do("CREATE TABLE foo (x integer)"); > $dbh->commit; > $dbh->disconnect; > > -- > Michael Fuhr > http://www.fuhr.org/~mfuhr/ > -- Donald Drake President Drake Consulting http://www.drakeconsult.com/ http://www.MailLaunder.com/ 312-560-1574