From: Michael Fuhr <mike@fuhr.org>
To: Don Drake <dondrake@gmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: AutoCommit and DDL
Date: Sun, 27 Feb 2005 12:54:34 -0700
Message-ID: <20050227195434.GA21745@winnie.fuhr.org> (raw)
In-Reply-To: <6c21003b0502270955673432e7@mail.gmail.com>
References: <6c21003b050226125634e9964@mail.gmail.com>
<20050227042043.GB77382@winnie.fuhr.org>
<6c21003b0502270955673432e7@mail.gmail.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: mike@fuhr.org, dondrake@gmail.com
Subject: Re: AutoCommit and DDL
In-Reply-To: <20050227195434.GA21745@winnie.fuhr.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox