Re: perl Pg module and result status

On Wed, 20 Sep 2000 21:24:17 -0400, Neil Conway wrote:

> I believe he is using straight Pg - the perl interface to Postgres.
> AFAIK, that's independant of DBI::Pg, which is the Postgres
> driver for DBI.
>

ahhh! "i see" said the blind man :)

> I agree with you, however: I've found DBD::Pg quite a bit easier
> to work with than Pg. It also gives you the possibility of
> moving your code to another database with relatively small
> changes.
>

yes, i agree totally. it also makes using a new database a lot
easier, since you're just calling the same functions.

> If you don't mind me commenting on your code:

not at all!

> > $user = '';
> > $pass = '';
> > $dburl = ''; # should be: dbi:Pg:dbname=[your database name]

> Is there a reason you're not using constants? e.g.
>
> use constant DB_USER => 'foo';
> use constant DB_PASSWD => 'qwerty';
>

nope. didn't occur to me for this sort of example. also seems to
bring in extra overhead. is there an advantage?

> You might also want to add the "$DBI::errstr" to the error message
> on a connection failure.
>

yeah, i used it on the other method calls. should have put it there
as well. i think, tho, that the driver will by default print out that
error string when it dies.

regards
--e--