Postgres Pro
Downloads
Home   >   mailing lists

pgsql: Fix an oversight in the original implementation of - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Fix an oversight in the original implementation of
Date
Msg-id 20080711160850.5D9C1754A84@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
Fix an oversight in the original implementation of performMultipleDeletions():
the alreadyDeleted list has to be passed down through
deleteDependentObjects(), else objects that are deleted via auto/internal
dependencies don't get reported back up to performMultipleDeletions().
Depending on the visitation order, this could cause the code to try to delete
an already-deleted object, leading to strange errors in DROP OWNED (typically
"cache lookup failed for relation NNNNN" or similar).  Per bug #4289.

Patch for back branches only.  This code has recently been rewritten in HEAD,
and doesn't have this particular bug anymore.

Tags:
----
REL8_3_STABLE

Modified Files:
--------------
    pgsql/src/backend/catalog:
        dependency.c (r1.69 -> r1.69.2.1)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/dependency.c?r1=1.69&r2=1.69.2.1)

pgsql-committers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: pgsql: Add: > > * Add temporal versions of generate_series() > >
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: Fix an oversight in the original implementation of