On Mon, Dec 06, 2004 at 05:27:32PM -0500, Tom Lane wrote: Hi,
> So if Alvaro's thing works out, the shared-sequence problem becomes moot. > Probably that's a good reason not to spend time on it just yet. I'm still alive, and I've been following this thread. Sorry for not giving an update. I have been working on the patch and it seems now it works as I originally intended it to: dropping users or tablespaces is disallowed unless they own or contain no object. ACL's are not tracked; I'm still unsure if they should be. It should not be a difficult modification though. Now, with the current setup there are 3000-and-some entries per database. This makes it by a wide margin the biggest shared catalog. Is this something to be concerned with? Adding ACL tracking won't make it any more bloated on a freshly initdb'd database, but it will grow much faster. I had thought that maybe we shouldn't track dependencies on the first superuser, on the assumption that it cannot be dropped. I'm not sure if this is entirely true however. I'll post the patch on monday or tuesday for review and testing. -- Alvaro Herrera (<[EMAIL PROTECTED]>) "Puedes vivir solo una vez, pero si lo haces bien, una vez es suficiente" ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html