Postgres Pro
Downloads
Home   >   mailing lists

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

From jian he
Subject Re: Validating check constraints without a table scan?
Date
Msg-id CACJufxEeiT7kDS=x8jC25n+vtmxPQsW9zN_qgEtbpqH4dF-Dyw@mail.gmail.com
Whole thread Raw
In response to Validating check constraints without a table scan?  (Philip Couling <couling@gmail.com>)
Responses Re: Validating check constraints without a table scan?
List pgsql-general
Tree view 
On Fri, Nov 15, 2024 at 4:38 PM Philip Couling <couling@gmail.com> wrote:
>
> Is there a solid reason why adding a check constraint does not use existing indexes for validation.
>

can you give an sql example (except not-null)
where indexes can be used for check constraint validation?
i am not sure I understand it correctly.

pgsql-general by date:

Previous
From: Subhash Udata
Date:
Subject: Clarification on CVE-2024-10979 and PostgreSQL Upgrade Necessity Without PL/Perl Usage
Next
From: Lucía Rotger
Date:
Subject: Re: Fwd: Error when opening pgAdmin