Re: Is there something wrong with Perl`s dbi and PostgreSQL? - Mailing list pgsql-sql

From greg@turnstep.com
Subject Re: Is there something wrong with Perl`s dbi and PostgreSQL?
Date
Msg-id a12bbba041a8725c804b028dcc3b0894@biglumber.com
Whole thread Raw
In response to Is there something wrong with Perl's dbi and PostgreSQL?  (Jeff Self <jself@nngov.com>)
List pgsql-sql
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


> I just tried running a perl script that I wrote about a year ago. It had
> worked for me in the past. Now it doesn't work.

You have AutoCommit set to off, and never commit the transaction. Therefore, 
the table creation is rolled back. Add a 

$dbh->commit()

after your execute line and it should work as expected.

Also note that your "die" on connect will not work because you have RaiseError 
set: Leave it off for the connect, then turn it on again immediately via:

$dbh->{RaiseError}=1;


- --
Greg Sabino Mullane greg@turnstep.com
PGP Key: 0x14964AC8 200309291445

-----BEGIN PGP SIGNATURE-----
Comment: http://www.turnstep.com/pgp.html

iD8DBQE/eH4AvJuQZxSWSsgRAgkVAJ46YX5iJ1+pbeJOQ6RJYId/6yhOWQCeKy7R
doP2RZN1y353MT+c4KdYywA=
=KUHS
-----END PGP SIGNATURE-----




pgsql-sql by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: SRF Functions don't want to return empty tuple
Next
From: Tom Lane
Date:
Subject: Re: Problems to be solved as soon as possible