Re: AutoCommit and DDL - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: AutoCommit and DDL
Date
Msg-id 20050227195434.GA21745@winnie.fuhr.org
Whole thread Raw
In response to Re: AutoCommit and DDL  (Don Drake <dondrake@gmail.com>)
List pgsql-sql
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/


pgsql-sql by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: AutoCommit and DDL
Next
From: "Casey T. Deccio"
Date:
Subject: table constraints