Re: DROP FUNCTION failure: cache lookup failed for
От | Bruce Momjian |
---|---|
Тема | Re: DROP FUNCTION failure: cache lookup failed for |
Дата | |
Msg-id | 200701252305.l0PN58U14783@momjian.us обсуждение исходный текст |
Ответ на | Re: DROP FUNCTION failure: cache lookup failed for relation X (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
Is this a TODO? --------------------------------------------------------------------------- Tom Lane wrote: > Michael Fuhr <mike@fuhr.org> 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 -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
В списке pgsql-hackers по дате отправления: