Re: libpq bug? (I guess not)
От | Mitch Vincent |
---|---|
Тема | Re: libpq bug? (I guess not) |
Дата | |
Msg-id | 00ea01c0bc6e$3bde9040$0b51000a@epox450 обсуждение исходный текст |
Ответ на | libpq bug? (I guess not) ("Yasuo Ohgaki" <yasuo_ohgaki@hotmial.com>) |
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: