From: | Laurette Cisneros <laurette(at)nextbus(dot)com> |
---|---|
To: | pgsql-interfaces(at)postgresql(dot)org |
Subject: | Pg (Perl for Postgresql) |
Date: | 2002-12-19 23:01:36 |
Message-ID: | Pine.LNX.4.44.0212191458030.16486-100000@visor.corp.nextbus.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
Does this belong on this list?
Using Pg, it seems I get an error when trying to query a 7.3 database:
$fromconn = Pg::connectdb( "host=testhost port=5439 dbname=test-73"
);
die $fromconn->errorMessage unless ($fromconn->status eq PGRES_CONNECTION_OK);
$query = "select x, y from table1;";
$result = $fromconn->exec( $query );
$status = $result->resultStatus;
if ( $status ne PGRES_TUPLES_OK ) {
print "query failed: ";
print $status;
print "\n$query\n";
print "\n";
}
returns:
query failed: 7
select x, y from table1;
Is there a newer version of Pg that should be used that can read both 7.2
and 7.3 databases?
Thanks,
--
Laurette Cisneros
The Database Group
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
----------------------------------
Life is an SQL old chum...
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-12-19 23:14:25 | Re: Pg (Perl for Postgresql) |
Previous Message | Martin Zeiser | 2002-12-18 14:08:41 | postgres <=> labview? |