Postgres Pro
Downloads
Home   >   mailing lists

Re: Validating check constraints without a table scan? - Mailing list pgsql-general

From Laurenz Albe
Subject Re: Validating check constraints without a table scan?
Date
Msg-id 18994f31b8e5f9d7a0f0327f99fcb73e647ed99d.camel@cybertec.at
Whole thread Raw
In response to Validating check constraints without a table scan?  (Philip Couling <couling@gmail.com>)
List pgsql-general
Tree view 
On Thu, 2024-11-14 at 21:33 +0000, Philip Couling wrote:
> Is there a solid ready why validating check constraints cannot use existing indexes?
> If I can prove the constraint is valid so trivially with a SELECT, then why can
> Postgres not do the same (or similar)?

I assume that the simple answer is: because nobody implemented that.

Yours,
Laurenz Albe

pgsql-general by date:

Previous
From: Philip Couling
Date:
Subject: Validating check constraints without a table scan?
Next
From: Andy Hartman
Date:
Subject: DB Files