Postgres Pro
Downloads
Home   >   mailing lists

Re: Disallow unique index on system columns - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Disallow unique index on system columns
Date
Msg-id 24896.1460823214@sss.pgh.pa.us
Whole thread Raw
In response to Re: Disallow unique index on system columns  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: Disallow unique index on system columns  (Eric Ridge <eebbrr@gmail.com>)
List pgsql-hackers
Tree view 
David Rowley <david.rowley@2ndquadrant.com> writes:
> On 15 April 2016 at 13:43, David Rowley <david.rowley@2ndquadrant.com> wrote:
>> The attached patch just disallows any index containing a system
>> column, apart from OID.
> Seems I only did half the job as I forgot to think to check for system
> columns that are hidden away inside expressions or predicates.
> The attached fixes that.

Pushed.  I moved the check into DefineIndex, as that's where user-facing
complaints about indexes generally ought to be.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: OS scheduler bugs affecting high-concurrency contention
Next
From: Magnus Hagander
Date:
Subject: Re: Updated backup APIs for non-exclusive backups