Re: undefined subroutine DBD::Pg::db::_login

2003-03-21 Thread Jeffrey Baker
On Fri, Mar 21, 2003 at 01:01:48PM -0800, Richard Schilling wrote: > I am having trouble running Pg version 0.92. I get the error > that DBD::Pg::db::_login is undefined. It is called on about > line 97 in Pg.pm. > > Could not find any explaination in the archives, and didn't > see it address

Re: shortcuts for common placeholder idioms...

2003-03-10 Thread Jeffrey Baker
On Mon, Mar 10, 2003 at 05:56:49PM -0500, Paul Boutros wrote: > > > foreach ( $cgi->param() ) { > > >push @cols, $_; > > >push @vals, $cgi -> param( $_ ); > > > } > > > my $sql = "INSERT INTO table ( " . join( ", ", @cols ) . " )\n" . > > >" VALUES ( " . join( ", ", map { "?" } @cols

Re: DBD::Pg::tables starts transaction (was: Postgres and mod_perl:vacuum getting stuck?)

2002-06-27 Thread Jeffrey Baker
On Mon, Jun 24, 2002 at 12:17:09PM -0400, Jeff Boes wrote: > On Mon, 2002-06-17 at 10:00, Jeff Boes wrote: > > > We are experiencing a fairly predictable lock-up in the overnight VACUUM > > ANALYZE maintenance script. The VACUUM gets to the pg_class table and > > then stops, obviously waiting fo

Re: Can DBD::Pg identify the backend's process ID?

2002-06-27 Thread Jeffrey Baker
On Thu, Jun 13, 2002 at 07:35:23AM -0400, [EMAIL PROTECTED] wrote: > Its a fairly small change to add this, 10 lines of code. I wrote this > patch for a previous place, unfortunately I no longer work with Pg > regularly, and don't have time to clean it up and give you a proper patch > > The inter

Re: debugging a DBD::Pg connection (psql and telnet)

2002-05-01 Thread Jeffrey Baker
On Wed, May 01, 2002 at 05:32:59PM -0400, Terrence Brannon wrote: > I started postmaster via: > > ./bin/postmaster -D data -p 7000 & > > but why does a > > telnet localhost 7000 > > result in a refused connection even though > > ./bin/psql -p 7000 test postgres > > works? Your post

Re: DBD::Pg on Mac OS X - dyld errors

2002-04-30 Thread Jeffrey Baker
On Tue, Apr 30, 2002 at 05:01:59PM -0400, Terrence Brannon wrote: > Hi, I am running Mac OS X 10.1.3 and perl-5.7.2. I have my > POSTGRES_LIB variable set correctly: > > >setenv PG /usr/local/pgsql >setenv POSTGRES_INCLUDE $PG/include >setenv POSTGRES_LIB

Re: Problem with DBD::Pg and $sth->{pg_type}

2002-04-27 Thread Jeffrey Baker
On Tue, Apr 23, 2002 at 03:54:49PM -0400, Jeff Boes wrote: > I've encountered a problem with the statement handle's pg_type > attribute, under DBI 1.21 and DBD::Pg 1.12. > [...] > If you run this, you'll get some unprintable output from the first print > statement, and the second print causes a se