Janning Vygen wrote:
> sorry for asking again, because i could solve this problem on my own if i had
> enough time to check things.
>
> i collect all my sql command and do
> #!/bin/sh
> dropdb kontaktdaten
> createdb kontaktdaten
> cat sql_commands | psql kontaktdaten
>
> and often i get
>
> ERROR: DROP DATABASE: Database "kontaktdaten" is being accessed by other
> users
>
> if i do a ' ps ax | grep post ' i see some processes which are idle
> 2572 pts/6 S 0:00 /usr/bin/postgres localhost wwwrun kontaktdaten idle
>
> i always call pg_Close in my php scripts. Why are there still some processes
> and how can i achieve to drop the database??
Maybe, but you're using pg_pconnect() instead of
pg_connect(), turning pg_close() effectively into a NOOP.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com