Request a Demo
Home   >   mailing lists

Re: Request for Implementation of Custom Error Messages for CHECK Constraints - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: Request for Implementation of Custom Error Messages for CHECK Constraints
Date
Msg-id aCJKbvyQfVx_sZqu@momjian.us
Whole thread Raw
In response to Re: Request for Implementation of Custom Error Messages for CHECK Constraints  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-hackers
Tree view 
On Mon, May 12, 2025 at 11:22:21AM -0700, David G. Johnston wrote:
> On Monday, May 12, 2025, Bruce Momjian <bruce@momjian.us> wrote:
> 
>     Yeah, you could name the constraint
>     "Custom_error_message_when_the_condition_is_not_met." and then just
>     convert underscore to spaces and display that to the user.
> 
>  The 63 byte limit seems much more likely to be a factor if the name has to
> serve the duty of a human-friendly error message.

Yes, that would be a limiting factor.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  Do not let urgent matters crowd out time for investment in the future.

pgsql-hackers by date:

Previous
From: Matthias van de Meent
Date:
Subject: Re: Proposal: Exploring LSM Tree‑Based Storage Engine for PostgreSQL (Inspired by MyRocks)
Next
From: Aleksander Alekseev
Date:
Subject: Re: Proposal: Exploring LSM Tree‑Based Storage Engine for PostgreSQL (Inspired by MyRocks)