"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