Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: pgsql: If an index depends on no columns of its table, give it a
Date
Msg-id 3130.1194599158@sss.pgh.pa.us
Whole thread Raw
In response to Re: pgsql: If an index depends on no columns of its table, give it a  (Simon Riggs <simon@2ndquadrant.com>)
Responses Re: pgsql: If an index depends on no columns of its table, give it a
List pgsql-committers
Tree view 
Simon Riggs <simon@2ndquadrant.com> writes:
> I had understood the discussion to conclude that indexes that do not
> depend on any column of the table to not be allowed at all.

That was my first reaction too, but the point about unique-index behavior
refutes it.  Constraining a table to have at most one row is useful.

            regards, tom lane

pgsql-committers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: pgsql: If an index depends on no columns of its table, give it a
Next
From: Simon Riggs
Date:
Subject: Re: pgsql: If an index depends on no columns of its table, give it a