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 20071108232254.9A921754156@cvs.postgresql.org
Whole thread Raw
Responses Re: pgsql: If an index depends on no columns of its table, give it a
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.

Modified Files:
--------------
    pgsql/src/backend/catalog:
        index.c (r1.286 -> r1.287)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/index.c?r1=1.286&r2=1.287)

pgsql-committers by date:

Previous
From: momjian@postgresql.org (Bruce Momjian)
Date:
Subject: pgsql: Wording improvement for pl/proxy mention.
Next
From: tgl@postgresql.org (Tom Lane)
Date:
Subject: pgsql: If an index depends on no columns of its table, give it a