Re: Proposal: Include CHECK constraint expression in violation error DETAIL

From: Yash Jadhav <yash(dot)jadhav8008(at)gmail(dot)com>
To: Koshino Taiki <koshino(at)sraoss(dot)co(dot)jp>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Yugo Nagata <nagata(at)sraoss(dot)co(dot)jp>
Subject: Re: Proposal: Include CHECK constraint expression in violation error DETAIL
Date: 2026-11-15 09:54:03
Message-ID: CAGsfjr6y7Yh=4VszqRkgc9kxhksiA-Wr6KNUBQ8Vn=Fo06yxPQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

cfbot is failing on v2 in the contrib/postgres_fdw regression test
(Linux Autoconf, Linux Meson, and others). Its expected output still
has the old DETAIL text for several check constraint violations.

I’ve attached a patch that updates
contrib/postgres_fdw/expected/postgres_fdw.out. I applied it on top of
v2, and make -C contrib/postgres_fdw check passes.

The attachment is named nocfbot, so cfbot doesn’t treat it as a
replacement for the patch set. You can apply the change into your next
version.

Regards,
Yash

Attachment Content-Type Size
nocfbot-Add-Missed-CHECK-DETAILS.patch text/x-patch 5.3 KB

In response to

Browse pgsql-hackers by date

  From Date Subject
Previous Message Chengpeng Yan 2026-11-15 08:51:47 Re: Add a greedy join search algorithm to handle large join problems