Re: [BUGS] BUG #14616: error message without schema

OK, I understand.

We have one database with 283 schemas. Every schema have an "account" table.

Thanks for the \errverbose. Can I somehow in pgadmin?


> Ódor Balázs <balazs@obiserver.hu> writes:
>> db=# create schema test;
>> CREATE SCHEMA
>> db=# create domain test.testdomain as varchar(200);
>> CREATE DOMAIN
>> db=# create table test.testtable (col test.testdomain);
>> CREATE TABLE
>> db=# insert into test.testtable (col) values ('test text');
>> INSERT 0 1
>> db=# alter domain test.testdomain add constraint testdomain_check check
>> (value ~ 'a.+');
>> ERROR:  column "col" of table "testtable" contains values that violate
>> the new constraint
> The data you're after *is* available in the extended fields of that error:
>
> db=# \errverbose
> ERROR:  23514: column "col" of table "testtable" contains values that violate the new constraint
> SCHEMA NAME:  test
> TABLE NAME:  testtable
> COLUMN NAME:  col
> LOCATION:  validateDomainConstraint, typecmds.c:2750
>
> We've had multiple conversations about whether to include objects' schema
> names in the primary error message text, and so far the answer continues
> to be "no".  There seem to be more people who would find it to be clutter
> than would find it to be useful.  Certainly it wouldn't make sense to
> change that style decision for just this one message.
>
>             regards, tom lane



-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs