Postgres Pro
Downloads
Home   >   mailing lists

pgsql: If an index depends on no columns of its table, give it a - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: If an index depends on no columns of its table, give it a
Date
Msg-id 20071108232307.7C65C754156@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Tree view 
Log Message:
-----------
If an index depends on no columns of its table, give it a dependency on the
whole table instead, to ensure that it goes away when the table is dropped.
Per bug #3723 from Sam Mason.

Backpatch as far as 7.4; AFAICT 7.3 does not have the issue, because it doesn't
have general-purpose expression indexes and so there must be at least one
column referenced by an index.

Tags:
----
REL8_1_STABLE

Modified Files:
--------------
    pgsql/src/backend/catalog:
        index.c (r1.261.2.2 -> r1.261.2.3)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/index.c?r1=1.261.2.2&r2=1.261.2.3)

pgsql-committers by date:

Previous
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: If an index depends on no columns of its table, give it a
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: If an index depends on no columns of its table, give it a