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@sss.pgh.pa.us>
To: "Yasuo Ohgaki" <yasuo_ohgaki@hotmial.com>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, April 03, 2001 2:45 PM
Subject: Re: libpq bug? (I guess not)
> "Yasuo Ohgaki" <yasuo_ohgaki@hotmial.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@example.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@postgresql.org so that your
> message can get through to the mailing list cleanly
>