| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Michael Fuhr <mike(at)fuhr(dot)org> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: DROP FUNCTION failure: cache lookup failed for relation X |
| Date: | 2007-01-22 07:07:00 |
| Message-ID: | 6709.1169449620@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Michael Fuhr <mike(at)fuhr(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Simon Riggs | 2007-01-22 08:46:02 | Re: savepoint improvements |
| Previous Message | Bruce Momjian | 2007-01-22 04:52:55 | Re: [HACKERS] Win32 WEXITSTATUS too simplistic |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adriaan van Os | 2007-01-22 09:19:25 | Re: [HACKERS] BUG #2907: pg_get_serial_sequence quoting |
| Previous Message | Bruce Momjian | 2007-01-22 04:52:55 | Re: [HACKERS] Win32 WEXITSTATUS too simplistic |