RE: perl problems

I don't know what happened, but as I understand it Pg.pm hasn't been
maintained for some time now... since DBI came out. I would recommend using
DBI with DBD::Pg to query your postgres databases. It also makes it easy if
ever have to migrate to a new DB server, God Forbid. You just download the
new DBD driver and change your connection setup and BAM! All your queries
and accompanied code still run without modification.

-Chuck

-----Original Message-----
From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org]On Behalf Of Dax Duskin
Sent: Thursday, March 15, 2001 7:52 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] perl problems

Hello,

I've been having problems getting queries from perl to run with Pg.pm. My
database connection works and the database is opened fine. However when I
execute a query like "$result = $conn->exec($query);" I can never return any
tuples. I have tried many different forms of the sql query, (the exact same
queries work fine in psql) on a couple databases and tables. Still no luck.
The code worked last night. Is there some setting on postmaster that I need
to
set? What happened?

Thanks,
Dax Duskin

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl