On 8/1/25 17:06, Igor Korot wrote:
Hi, Laurenz,
I'm looking at the pg_index table and I see it has: [quote] indisexclusion bool If true, this index supports an exclusion constraint [/quote] If I read the docs correctly, this field indicates whether the WHERE condition is actually present. Am I right?
No, it refers to: https://www.postgresql.org/docs/current/ddl-constraints.html#DDL-CONSTRAINTS-EXCLUSION
Thank you.Yours, Laurenz Albe
-- Adrian Klaver adrian.kla...@aklaver.com