Fw: PHP and pg_connect() - Mailing list pgsql-general

From Mitch Vincent
Subject Fw: PHP and pg_connect()
Date
Msg-id 011b01c09a80$1de6cbd0$0200000a@windows
Whole thread Raw
List 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



pgsql-general by date:

Previous
From: Dave Edmondson
Date:
Subject: Re: Postgres slowdown on large table joins
Next
From: "Rod Taylor"
Date:
Subject: Arbitrary table joins.