[imp] PostgreSQL and pconnect() ... an evil combination ...

The Hermit Hacker scrappy@hub.org
Thu, 2 Nov 2000 14:05:41 -0400 (AST)



I found on in imp/lib/db.pgsql also?  changing that one to
pg_connect() from pg_pconnect() appears to generate a whack of errors
though, while changing it back to pg_pconnect() and doing a reload frame
gets rid of them:

Warning: 1 is not a valid PostgreSQL link resource in /usr/local/www/phplib/db_pgsql.inc on line 52

Warning: 1 is not a valid PostgreSQL link resource in /usr/local/www/phplib/db_pgsql.inc on line 55

Warning: 1 is not a valid PostgreSQL link resource in /usr/local/www/phplib/db_pgsql.inc on line 67

Warning: Cannot add header information - headers already sent by (output started at
/usr/local/www/phplib/db_pgsql.inc:52) in /usr/local/www/horde/lib/horde.lib on line 531

Warning: Cannot add header information - headers already sent by (output started at
/usr/local/www/phplib/db_pgsql.inc:52) in /usr/local/www/horde/imp/templates/doctype.inc on line 8

Warning: 1 is not a valid PostgreSQL link resource in /usr/local/www/phplib/db_pgsql.inc on line 52

Warning: 1 is not a valid PostgreSQL link resource in /usr/local/www/phplib/db_pgsql.inc on line 55

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/www/phplib/db_pgsql.inc on line
122

Warning: 1 is not a valid PostgreSQL link resource in /usr/local/www/phplib/db_pgsql.inc on line 52

Warning: 1 is not a valid PostgreSQL link resource in /usr/local/www/phplib/db_pgsql.inc on line 55

On Thu, 2 Nov 2000, Jon Parise wrote:

> On Thu, Nov 02, 2000 at 01:46:31PM -0400, The Hermit Hacker wrote:
> 
> > Changing pg_pconnect back to just pg_connect fixes the problem ... in
> > fact, it appears to also fix the problem I reported earlier about trapping
> > error messages ... 
> 
> I agree this is the better thing to do.  I just committed the change
> (pg_pconnect -> pg_connect).
> 
> -- 
> Jon Parise (jon@csh.rit.edu)  .  Rochester Inst. of Technology
> http://www.csh.rit.edu/~jon/  :  Computer Science House Member
> 
> -- 
> IMP mailing list: http://horde.org/imp/
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: imp-unsubscribe@lists.horde.org
> 
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org