Re: Disallow unique index on system columns

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Disallow unique index on system columns
Дата
Msg-id 27352.1460735367@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Disallow unique index on system columns  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: Disallow unique index on system columns  (Andres Freund <andres@anarazel.de>)
Список pgsql-hackers
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.

I think what we should do with this is split it into two patches, one
to fix ALTER REPLICA IDENTITY's crash (which we'd back-patch to 9.4)
and one to forbid indexes on system columns (which IMO should be HEAD
only).  The first of those should be pretty uncontroversial, so I'll
go ahead with pushing it --- anyone have a problem with the second?
        regards, tom lane



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: Optimization for updating foreign tables in Postgres FDW
Следующее
От: Tom Lane
Дата:
Сообщение: Unreasonably generic names in matview.sql