destroydb doesn't close connection with client (httpd <-> pg)
| От | Oleg Bartunov |
|---|---|
| Тема | destroydb doesn't close connection with client (httpd <-> pg) |
| Дата | |
| Msg-id | Pine.GSO.3.96.SK.990612224559.27855D-100000@ra обсуждение исходный текст |
| Ответы |
Re: [HACKERS] destroydb doesn't close connection with client (httpd <-> pg)
|
| Список | pgsql-hackers |
I have Web site where I use persistent connection between httpd (Apache) and database (postgres,6.5). I noticed strange results I got after reloading page with results from query when I destroydb , createdb, fill db ( with the same data ). It seems backend doesn't close connection when db is destroyed and this produces unpredictable results. My application is written in Perl and uses DBI/DBD for persistent connection. I don't know is it DBI/DBD problem or backend must close all connections to DB when it destroyed. Regards, Oleg _____________________________________________________________ Oleg Bartunov, sci.researcher, hostmaster of AstroNet, Sternberg Astronomical Institute, Moscow University (Russia) Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/ phone: +007(095)939-16-83, +007(095)939-23-83
В списке pgsql-hackers по дате отправления: