From: greg@turnstep.com
To: pgsql-sql@postgresql.org
Cc: jself@nngov.com
Subject: Re: Is there something wrong with Perl`s dbi and PostgreSQL?
Date: Mon, 29 Sep 2003 18:45:20 -0000
Message-ID: <a12bbba041a8725c804b028dcc3b0894@biglumber.com> (raw)
In-Reply-To: <1064857916.27970.18.camel@jselfpc>
-----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-----
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: greg@turnstep.com, jself@nngov.com
Subject: Re: Is there something wrong with Perl`s dbi and PostgreSQL?
In-Reply-To: <a12bbba041a8725c804b028dcc3b0894@biglumber.com>
* 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