Re: [HACKERS] Same expression more than once in partition key

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [HACKERS] Same expression more than once in partition key
Дата
Msg-id 7154.1498248288@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] Same expression more than once in partition key  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
Ответы Re: [HACKERS] Same expression more than once in partition key  (Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>)
Re: [HACKERS] Same expression more than once in partition key  (Robert Haas <robertmhaas@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Peter Eisentraut <peter.eisentraut@2ndquadrant.com> writes:
> We also allow the same column more than once in an index.  We probably
> don't have to be more strict here.

There actually are valid uses for the same column more than once in
an index, eg if you use a different operator class for each instance.
I find it hard to envision a similar use-case in partitioning though.
        regards, tom lane

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: [HACKERS] REPLICA IDENTITY FULL
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] pg_terminate_backend can terminate background workersand autovacuum launchers