Fwd: Problems with Error Messages wrt Domains, Checks

2018-03-17 Thread john frazer
-- Forwarded message -- From: john frazer Date: Sat, Mar 17, 2018 at 6:28 PM Subject: Re: Problems with Error Messages wrt Domains, Checks To: "David G. Johnston" Thanks for your consideration, I'll try to be brief. > As such, it could be anywher

Problems with Error Messages wrt Domains, Checks

2018-03-17 Thread john frazer
Today I realized a number of points where PostgreSQL (v10.3) is rather lackluster and sparse in its error messages. The first point is illustrated by this code: drop schema if exists X cascade;create schema X; create domain X.an_illegal_regex as text check ( value ~ '(' ); create table X.table_wi