Re: Validating check constraints without a table scan?

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: Philip Couling <couling(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Validating check constraints without a table scan?
Date: 2024-11-20 09:45:39
Message-ID: CACJufxEeiT7kDS=x8jC25n+vtmxPQsW9zN_qgEtbpqH4dF-Dyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Nov 15, 2024 at 4:38 PM Philip Couling <couling(at)gmail(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lucía Rotger 2024-11-20 09:53:07 Re: Fwd: Error when opening pgAdmin
Previous Message Subhash Udata 2024-11-20 08:54:36 Clarification on CVE-2024-10979 and PostgreSQL Upgrade Necessity Without PL/Perl Usage