On Tue, Jul 19, 2022 at 11:22 PM Morris de Oryx <morrisdeoryx@gmail.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