Re: libpq bug? (I guess not)

pg_pconnect is very nasty right now (check the PHP bug list [bugs.php.net]
and you'll see many references to it).. They've said that the problems have
been (or are being) fixed for the next release of PHP but from what I
understand the PHP release won't be for a while.

Good luck!

-Mitch
Software development :
You can have it cheap, fast or working. Choose two.

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Yasuo Ohgaki" <yasuo_ohgaki(at)hotmial(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Tuesday, April 03, 2001 2:45 PM
Subject: Re: libpq bug? (I guess not)

> "Yasuo Ohgaki" <yasuo_ohgaki(at)hotmial(dot)com> writes:
> > I have a PHP code to execute query like
>
> > $db = pg_pconnect('db=my_db host=localhost user=username');
> > $query = "INSERT INTO new_user (username, email, ............) VALUES
('ABC',
> > 'foo(at)example(dot)com', ..........);";
> > pg_exec($db, $query); // Execute query using database connection $db.
>
> > in my script. The script seems executing the query 4 times whenever it's
called,
> > since I get 4 newly inserted records everytime execute the script.
>
> You could get some more info about what's happening by turning on query
> logging in the postmaster (start postmaster with -d2, and be sure NOT to
> use -S). But I'll bet that some way or other, PHP is submitting the
> same query multiple times.
>
> I have some recollection that pg_pconnect() doesn't behave very well;
> you might need to avoid that in favor of a plain connect. Check the
> archives for discussion of pconnect.
>
> regards, tom lane
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
>