From: selkovjr@mcs.anl.gov
To: jr@i-bucks.com
Cc: pgsql-interfaces@postgresql.org
Subject: Re: perl return codes
Date: Mon, 26 Feb 2001 19:18:54 -0600
Message-ID: <200102270118.TAA22314@selkovjr.xnet.com> (raw)
In-Reply-To: <3.0.6.32.20010226160613.007f5780@mail.i-bucks.com>
References: <3.0.6.32.20010226160613.007f5780@mail.i-bucks.com>
> I am writing a few perl scripts accessing postgres. I have used the
> examples in Bruce Momjian's book, where command results are tested.
> (Variables such as PGRES_CONNECTION_OK and PGRES_TUPLES_OK are used).
> Where can I find documentation on these types of variables, for other
> commands? (source is okay, I just cannot find it).
These are not exactly variables -- they are the calls to autoloaded
subroutines exported into your name space, so they appear to be
constants. Their values are defined in Pg.xs, in constant().
If you were asking about their meaning, I believe their names are
self-explanatory, but maybe I've just been around for too long. Look
for comments in libpq-fe.h, and if something is still unclear, be sure
to ask again.
Also, consider using DBI. It has a somewhat cleaner interface and its
error handling model is simpler, too. It's just an opinion, of
course. I once had to convert some of my code from Pg to DBI because
my users were high on portability. Nevermind that I never achieved
portablity (because many of the features I use are unique to
postgres). I but I liked it and still stick to it. I have a feeling
that it allows me to code faster and achieve greater sophistication.
--Gene
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: selkovjr@mcs.anl.gov, jr@i-bucks.com
Subject: Re: perl return codes
In-Reply-To: <200102270118.TAA22314@selkovjr.xnet.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox