Re: Yet another DBD::Pg problem

On Friday, November 14, 2003, at 12:12 AM, Josh Berkus wrote:

> Anyone get the feeling we should start a pgsql-perl mailing list?

dbdpg-general(at)gborg(dot)postgresql(dot)org is actually pretty good.

> I've been getting off and on a bizarre problem were database handles
> defined
> in the main program can't be used in subs. I get a:
>
> Can't call method "prepare" on an undefined value at elbs_text_xfer.pl
> line
> 410
>
> Is this a known issue with earlier versions of DBD::pg? Something in
> my
> sloppy perl programming? Hints?

I got this a long time ago when I was doing my own database handle
caching in mod_perl and keeping the handle in a file-scoped lexical
variable. It went away when I switched to a global variable (that is,
used our() instead of my()).

A much better solution that I adopted for Bricolage 1.6.6 or
thereabouts was to use DBI->connect-cached() and let DBI worry about it.

HTH,

David

--
David Wheeler AIM: dwTheory
david(at)kineticode(dot)com ICQ: 15726394
http://www.kineticode.com/ Yahoo!: dew7e
Jabber: Theory(at)jabber(dot)org
Kineticode. Setting knowledge in motion.[sm]