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