I did have a thought that it could be done lazily (on backend startup) on other databases and immediately on the current database. I guess it depends on the cost of checking for such things - wouldn't want to add greatly to startup time.
That would leave a small window of orphanage for existing backends on other databases, but is arguably an improvement on the current situation.
OTOH I'm not sure how much harm this causes, other than aesthetic.
andrew
Tom Lane wrote:
"Christopher Kings-Lynne" <[EMAIL PROTECTED]> writes:
Ah OK, I must have been thinking of the database owner check. I'd vote for
(1) checking that they own no objects and by default owning all their stuff
to the database owner. Plus add an optional clause:
DROP USER foo OWNER TO bob;
If you can suggest a plausible way that DROP USER is going to change the contents of other databases (which might well contain things owned by the target user), this might get onto the TODO list --- although I'd personally prefer RESTRICT/CASCADE options. So far, since no one has the foggiest idea how to implement cross-database removal, it's just been left as-is.
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
