Re: Transition relations: correlating OLD TABLE and NEW TABLE

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Transition relations: correlating OLD TABLE and NEW TABLE
Дата
Msg-id CAKFQuwaKF-ypu1P7Kq3_uyNuYwch9EYba9Bm-G9dza_n3NJgSQ@mail.gmail.com
обсуждение исходный текст
Ответ на Transition relations: correlating OLD TABLE and NEW TABLE  (Brent Kerby <blkerby@gmail.com>)
Ответы Re: Transition relations: correlating OLD TABLE and NEW TABLE
Список pgsql-hackers
Дерево обсуждения
On Friday, July 6, 2018, Brent Kerby <blkerby@gmail.com> wrote:
Of course if the table has a primary key, then this can be used, but I'm wondering how to handle this in the general case where a primary key might not exist.

Personally, I would consider the lack of a PK a rare and special case...I'd handle the proposed situation by adding a big serial column to the table.

David J.

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

Предыдущее
От: Brent Kerby
Дата:
Сообщение: Transition relations: correlating OLD TABLE and NEW TABLE
Следующее
От: Amit Kapila
Дата:
Сообщение: Re: Explain buffers wrong counter with parallel plans