Re: [HACKERS] destroydb doesn't close connection with client (httpd <-> pg)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Edmund Mergl <E(dot)Mergl(at)bawue(dot)de>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, hackers(at)postgreSQL(dot)org
Subject: Re: [HACKERS] destroydb doesn't close connection with client (httpd <-> pg)
Date: 1999-11-30 02:09:29
Message-ID: 18775.943927769@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Can someone comment on where we are on this?

Problem's gone: you cannot destroy a DB containing active backends
anymore. That may not be quite the solution Edmund wanted ;-), but
it's effective.

>> Create and fill a database. Connect to this database with psql
>> and perform some query. Without disconnecting destroy and re-create
>> the database but insert this time different data. Performing
>> the same query a second time will retrieve the same data as before

regards, tom lane

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-11-30 02:12:45 Re: [PATCHES] Re: [HACKERS] new patches
Previous Message Tom Lane 1999-11-30 02:07:12 Re: [HACKERS] Bizarre coding in _bt_binsrch