Re: speedup ALTER TABLE ADD CHECK CONSTRAINT.

On Mon, Dec 2, 2024 at 12:06 AM Sergei Kornilov wrote: > > Hello! > Thanks for the patch, but I think using SPI is still not allowed here: > https://www.postgresql.org/message-id/9878.1511970441%40sss.pgh.pa.us > > > if it uses SPI for sub-operations of ALTER TABLE I think that is sufficient > >

Re: speedup ALTER TABLE ADD CHECK CONSTRAINT.

Sergei Kornilov writes: > Hello! > Thanks for the patch, but I think using SPI is still not allowed here: > https://www.postgresql.org/message-id/9878.1511970441%40sss.pgh.pa.us Yeah, if you want to do this you need to code the catalog lookup in C. SPI just adds too many variables to what will

Re: speedup ALTER TABLE ADD CHECK CONSTRAINT.

Hello! Thanks for the patch, but I think using SPI is still not allowed here: https://www.postgresql.org/message-id/9878.1511970441%40sss.pgh.pa.us > if it uses SPI for sub-operations of ALTER TABLE I think that is sufficient > reason to reject it out of hand. regards, Sergei