Re: How to get schema name which violates fk constraint

From: "George Pavlov" <gpavlov(at)mynewplace(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Alvaro Herrera" <alvherre(at)commandprompt(dot)com>
Cc: "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, "Andrus" <kobruleht2(at)hot(dot)ee>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: How to get schema name which violates fk constraint
Date: 2008-10-22 17:39:04
Message-ID: 8C5B026B51B6854CBE88121DBF097A8602EF6351@ehost010-33.exch010.intermedia.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> >> In the second place, the reason most of our messages don't already
> >> contain schema names is that in the past we've judged it would be
> >> mostly clutter; and given the infrequency of complaints I see no
> >> reason to change that opinion.
>
> > I tend to disagree. We can run a poll in a wider audience.
>
> We already have a large poll: divide the number of complaints on this
> topic since 7.3 came out by the number of users ...

Since it seems like we are voting (!) let me say that fully informative
errors that include the schema would be very useful for those of us who
do use schemas to organize their tables. The generic "proper" way to
address a table in a schema (short of user path settings) is to qualify
it by its schema, so that's the unique fully descriptive name of the
table so all errors/diagnostics should reference that. Otherwise schemas
look like they are delegated to a second-class feature ("we have it so
we can check off a feature matrix, but our heart is not fully in it"). I
suspect lack of complaints is largely due to the (small) number of
people using namespaces -- the denominator should be users of the
feature, not all users...

George

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-10-22 17:40:16 Re: ALTER/DROP table/view assymmetry
Previous Message Tom Lane 2008-10-22 17:35:34 Re: How to view user defined TYPE