Re: [HACKERS] Rethinking locking for database create/drop vs connection startup

2006-05-04 Thread Tom Lane
Simon Riggs [EMAIL PROTECTED] writes: On Wed, 2006-05-03 at 16:15 -0400, Tom Lane wrote: If dropdb() takes such a lock before it checks for active backends, then the connection sequence can look like this: Many people never CREATE or DROP databases. They just do everything in the default

[HACKERS] Rethinking locking for database create/drop vs connection startup

2006-05-03 Thread Tom Lane
This is motivated by Jim Buttafuoco's recent gripe about not being able to connect while a DROP DATABASE is in progress: http://archives.postgresql.org/pgsql-hackers/2006-05/msg00074.php The whole area is really pretty grotty anyway --- the existing interlock does not prevent an incoming