Re: System column support for partitioned tables using heap

On Tue, Jul 19, 2022 at 11:22 PM Morris de Oryx <morrisdeoryx(at)gmail(dot)com> wrote:
> It might help if I show a sample insert handling function. The issue is with the line at the end of the top CTE, insert_rows:
>
> returning xmax as inserted_transaction_id),
>
> That's what fails on partitions. Is there an alternative way to test what happened to the row(s)? here's the full function. . I wrote a code generator, so I don't have to hand-code all of these bits for each table+version:

Oh I see. I didn't realize you were using INSERT .. ON CONFLICT
UPDATE, but that makes tons of sense, and I don't see an obvious
alternative to the way you wrote this.

Hmm.

--
Robert Haas
EDB: http://www.enterprisedb.com