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
> dropdb kontaktdaten
> createdb kontaktdaten
> cat sql_commands | psql kontaktdaten
> and often i get
> ERROR: DROP DATABASE: Database "kontaktdaten" is being accessed by other
> 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.
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
In response to
pgsql-general by date
|Next:||From: Ian Harding||Date: 2001-06-29 17:21:23|
|Subject: pg_dump - Comments on Triggers.|
|Previous:||From: Thomas T. Veldhouse||Date: 2001-06-29 16:31:22|
|Subject: Re: |