Skip site navigation (1) Skip section navigation (2)

RE: perl problems

From: "Chuck Kimber" <chuckk(at)ext(dot)usu(dot)edu>
To: <pgsql-novice(at)postgresql(dot)org>
Subject: RE: perl problems
Date: 2001-03-15 16:28:59
Message-ID: HOEAJICPFIHKNHNCKLFBAEFJCPAA.chuckk@ext.usu.edu (view raw or flat)
Thread:
Lists: pgsql-novice
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


In response to

pgsql-novice by date

Next:From: D. DucciniDate: 2001-03-15 20:03:00
Subject: Indexes not used
Previous:From: Daniel A. MeloDate: 2001-03-15 16:26:04
Subject: Re: [NOVICE] Re: Re: compilation error <segunda parte>

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group