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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers