Michael Fuhr <[EMAIL PROTECTED]> writes: > I've found a situation that causes DROP FUNCTION to fail (tested > in 8.1.6, 8.2.1, and 8.3devel):
Ugh ... I haven't traced this through in detail, but I'm pretty sure the problem arises from the fact that dependency.c traces through auto/internal dependencies before actually starting to do the deletions (and thus before acquiring locks). Can we fix this without multiple scans of the dependency tree (probably costing O(N^lots))? regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq