Re: DBD::Pg and stored procedures

[David Wheeler]

On Monday, January 13, 2003, at 11:03  AM, Jeff Boes wrote:

My problem is that for such procedures, doing:

  select fn_stored_proc(id_field) from table_name;

opens and closes the database connection over and over.  This is very
inefficient.  Is there some way to "inherit" the connection so it
doesn't have to be recreated?

I see that you're using PL/Perl. I haven't messed with PL/Perl yet, although its on my list of things to look at (and has been for about two years!), isn't there a way to access data from the database directly from within the PL/Perl function? I mean, it's running *inside* the database, so it seems rather crazy that you'd need to use DBI to talk to the database...

I suggest you post your question to the pgsql-general list, where there's likely to be more people with PL/Perl experience.

HTH,

David

--
David Wheeler AIM: dwTheory
[EMAIL PROTECTED] ICQ: 15726394
Yahoo!: dew7e
Jabber: [EMAIL PROTECTED]
Kineticode. Setting knowledge in motion.[sm]