Horton

Re: Ye olde drop-the-database-you-just-left problem

Zeugswetter Andreas DCP SD <zeugswettera@spardat.at>

View thread View on postgr.es
From: "Zeugswetter Andreas ADI SD" <ZeugswetterA@spardat.at>
To: "Brian Hurt" <bhurt@janestcapital.com>, "Tom Lane" <tgl@sss.pgh.pa.us>
Cc: <pgsql-hackers@postgreSQL.org>
Date: 2007-05-31T08:32:18Z
Lists: pgsql-hackers 
> >  However, it suddenly struck me that we could 
> >probably make most of the problem go away if we put that same wait
into 
> >DROP DATABASE itself --- that is, if we see other backends in the 
> >target DB, sleep for a second or two and then recheck before erroring
out.

Yup, waiting in drop database up to 10-30 secs would imho be fine.

Andreas