Re: AutoCommit and DDL

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/