Re: Add force option to dropdb - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Add force option to dropdb
Date
Msg-id 20140114190644.GI6840@eldon.alvh.no-ip.org
Whole thread Raw
In response to Add force option to dropdb  (salah jubeh <s_jubeh@yahoo.com>)
Responses Re: Add force option to dropdb  (salah jubeh <s_jubeh@yahoo.com>)
List pgsql-hackers
salah jubeh wrote:

> For the sake of completeness:
> 1. I think also, I need also to temporary disallow conecting to the database, is that right?
> 2. Is there other factors can hinder dropping database?

If the user owns objects, that will prevent this from working also.  I
have the feeling that adding DROP OWNED BY and/or REASSIGNED OWNED BY
calls to this utility would be a bit excessive, but who knows.

> 3. Should I write two patches one for pg_version>=9.2 and one for pg_version<9.2  

No point -- nothing gets applied to branches older than current
development anyway.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: Gavin Flower
Date:
Subject: Re: [Lsf-pc] Linux kernel impact on PostgreSQL performance
Next
From: Heikki Linnakangas
Date:
Subject: Re: GIN improvements part2: fast scan