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