Re: error messages without schema name - Mailing list pgsql-general

From Tom Lane
Subject Re: error messages without schema name
Date
Msg-id 8360.1166028241@sss.pgh.pa.us
Whole thread Raw
In response to Re: error messages without schema name  ("Filip Rembiałkowski" <plk.zuber@gmail.com>)
List pgsql-general
"=?UTF-8?Q?Filip_Rembia=C5=82kowski?=" <plk.zuber@gmail.com> writes:
> I heard from my PostgreSQL teacher, that all such messages should be
> corrected in the source code, to include schema name too.

I doubt we'd ever do that, because in most scenarios it'd just be
unnecessary clutter, and the primary error messages are supposed to
be kept short.

What probably should happen someday is to add additional fields to error
reports that carry object name, schema name, and so forth.  I think
these wouldn't be displayed normally but you could always turn on
"verbose" mode if you needed to see them.  This approach is needed to
support applications that want to know, for example, which constraint
failed during an INSERT without having to try to extract it from the
possibly-translated message text.

            regards, tom lane

pgsql-general by date:

Previous
From: "Tomi N/A"
Date:
Subject: Re: grant select on all tables of schema or database
Next
From: Palle Girgensohn
Date:
Subject: Re: [girgen@FreeBSD.org: Re: port fault on pg_ctl's