Received: from crowfix.com (qmailr@crowfix.crowfix.com [207.228.46.42]) by hub.org (8.8.8/8.7.5) with SMTP id GAA06126 for ; Sun, 21 Jun 1998 06:50:39 -0400 (EDT) Received: (qmail 16236 invoked by uid 501); 21 Jun 1998 10:50:56 -0000 Date: 21 Jun 1998 10:50:55 -0000 Message-ID: <19980621105055.16235.qmail@crowfix.com> From: Felix Morley Finch To: Ken McGlothlen Cc: pgsql-interfaces@hub.org Subject: Re: [INTERFACES] Take two: Simple CREATE TABLE in DBI::Pg? In-Reply-To: <199806210737.AAA20815@ralf.serv.net> (message from Ken McGlothlen on Sun, 21 June 1998 00:37:34 -0700) References: <199806171934.MAA06041@ralf.serv.net> <199806210737.AAA20815@ralf.serv.net> X-Mailer: VM 6.34 under Emacs 20.2.1 >>In article <199806210737.AAA20815@ralf.serv.net>, Ken McGlothlen writes: > [This is the second time I've asked this on this list. Is anyone > else getting my messages? I would *really* like to get an answer > here.] > Here's the program, in Perl; I've pared it down to the bare minimum: > #!/usr/local/bin/perl > use DBI; > sub tbl_easy_init { > local( $dbh ) = shift; > local( $sth ) = $dbh->prepare( "create table tbl_easy (id int4)" ); > $sth->execute(); =====> $dbh->commit; > } > $dbh = DBI->connect( "dbi:Pg:dbname=booga", "", "", > { "PrintError" => 0, "AutoCommit" => 0 } ); > $rv = &tbl_easy_init( $dbh ); > This program fails. I've tried it with all global variables, tried > a number of different CREATE TABLE statements, and so on, and $rv > always winds up being equal to -1. Yet, typing in the CREATE TABLE > statement in psql works. -- ... _._. ._ ._. . _._. ._. ___ .__ ._. . .__. ._ .. ._. Felix Finch: scarecrow repairman & rocket surgeon / felix@crowfix.com PGP = 91 B3 94 7C E9 E8 76 2D E1 63 51 AA A0 48 89 2F ITAR license #4933 I've found a solution to Fermat's Last Theorem but I see I've run out of room o