Fw: PHP and pg_connect()

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Fw: PHP and pg_connect()
Date: 2001-02-19 14:27:40
Message-ID: 011b01c09a80$1de6cbd0$0200000a@windows
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Just an FYI.

> FWIW, I emailed the php maintainer of the postgres piece, and he replied
> with the following (I installed the patch, recompiled, and everything has
> been running fine for about a week or so)....
>
> Michael Fork - CCNA - MCP - A+
> Network Support - Toledo Internet Access - Toledo Ohio
>
> ---------- Forwarded message ----------
>
> On Wed, Feb 14, 2001 at 09:59:24AM -0500, Michael Fork wrote:
> > I am subscribed the the PostgreSQL mailing list and noticed that you
were
> > a PHP developer, and I was wondering if you could give me a hand. I
have
> > a bunch of scripts that randomly give errors "Warning: <some number> is
> > not a valid PostgreSQL link resource in <file>". I have noticed this
> > since moving to PHP4, and it appears to only be random (it just started
> > happening on a website that previously worked for months without
> > problems -- only change to system was increasing kern.maxfiles to 8192).
>
> i've commited a fix for this to PHP 4 CVS yesterday.
>
> if you don't want to live on the "bleeding edge" (use PHP
> from CVS) just replace the php_pgsql_set_default_link
> function in pgsql.c against this one and you're all-set!
>
> regards,
> tc
>
> static void php_pgsql_set_default_link(int id)
> {
> PGLS_FETCH();
>
> if ((PGG(default_link) != -1) && (PGG(default_link) != id)) {
> zend_list_delete(PGG(default_link));
> }
>
> if (PGG(default_link) != id) {
> PGG(default_link) = id;
> zend_list_addref(id);
> }
> }
>
> >
> > Any information is greatly appreciated (I have been banging my head
> > against the wall :) If you need more info, just let me know!
> >
> > Thanks
> >
> > Michael Fork - CCNA - MCP - A+
> > Network Support - Toledo Internet Access - Toledo Ohio
> >
> >
> > Here is system info:
> > 4.2-STABLE FreeBSD
> > PostgreSQL 7.0.3
> > mod_php-4.0.3pl1
> >
> > here is a link to a page calling phpinfo():
> > http://postgres.toledolink.com/~mfork/info.php

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2001-02-19 15:09:54 Re: PHP4 Persistent Connection
Previous Message M. Tavasti 2001-02-19 12:58:42 Handling of large objects in DBD::Pg?