Postgres Pro
Downloads
Home   >   mailing lists

Re: Transition relations: correlating OLD TABLE and NEW TABLE - Mailing list pgsql-hackers

From David G. Johnston
Subject Re: Transition relations: correlating OLD TABLE and NEW TABLE
Date
Msg-id CAKFQuwaKF-ypu1P7Kq3_uyNuYwch9EYba9Bm-G9dza_n3NJgSQ@mail.gmail.com
Whole thread Raw
In response to Transition relations: correlating OLD TABLE and NEW TABLE  (Brent Kerby <blkerby@gmail.com>)
Responses Re: Transition relations: correlating OLD TABLE and NEW TABLE  (Brent Kerby <blkerby@gmail.com>)
List pgsql-hackers
Tree view
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 by date:

Previous
From: Brent Kerby
Date:
Subject: Transition relations: correlating OLD TABLE and NEW TABLE
Next
From: Amit Kapila
Date:
Subject: Re: Explain buffers wrong counter with parallel plans