X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 3DF83D1B52C for ; Mon, 29 Sep 2003 18:45:48 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 46223-09 for ; Mon, 29 Sep 2003 15:45:21 -0300 (ADT) Received: from biglumber.com (biglumber.com [207.228.252.42]) by svr1.postgresql.org (Postfix) with SMTP id C66DAD1B4E6 for ; Mon, 29 Sep 2003 15:45:19 -0300 (ADT) Received: (qmail 10470 invoked from network); 29 Sep 2003 18:45:20 -0000 Received: from biglumber.com (HELO localhost) (207.228.252.42) by 0 with SMTP; 29 Sep 2003 18:45:20 -0000 From: greg@turnstep.com To: pgsql-sql@postgresql.org Cc: jself@nngov.com Cc: jself@nngov.com Subject: Re: Is there something wrong with Perl`s dbi and PostgreSQL? X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <1064857916.27970.18.camel@jselfpc> Date: Mon, 29 Sep 2003 18:45:20 -0000 X-Mailer: JoyMail 1.38 Message-ID: X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200309/409 X-Sequence-Number: 15387 -----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-----