Subject: Re: optionally schema-qualified for table_name
To: Bruce Momjian <bruce@momjian.us>, Tom Lane <tgl@sss.pgh.pa.us>
References: <158399268229.5708.13296960177949398026@wrigleys.postgresql.org>
 <20200322001310.GA2031@momjian.us> <22707.1584903901@sss.pgh.pa.us>
 <20200322201518.GB2031@momjian.us> <4628.1584915604@sss.pgh.pa.us>
 <20200323012757.GC2031@momjian.us>
Cc: protodef@gmail.com, pgsql-docs@lists.postgresql.org
From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Organization: 2ndQuadrant
Message-ID: <af0208b5-7811-955b-3ddf-d5839c4a4798@2ndquadrant.com>
Date: Tue, 24 Mar 2020 21:35:25 +0100
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.14; rv:52.0)
 Gecko/20100101 Thunderbird/52.9.1
MIME-Version: 1.0
In-Reply-To: <20200323012757.GC2031@momjian.us>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Language: en-US
Content-Transfer-Encoding: 7bit
Precedence: bulk

On 2020-03-23 02:27, Bruce Momjian wrote:
> On Sun, Mar 22, 2020 at 06:20:04PM -0400, Tom Lane wrote:
>> Bruce Momjian <bruce@momjian.us> writes:
>>> On Sun, Mar 22, 2020 at 03:05:01PM -0400, Tom Lane wrote:
>>>> I don't really think this is an improvement, mainly because that
>>>> error message is inventing a notation that we do not use in any
>>>> other error message.
>>
>>> What do you suggest?  The current message is:
>>
>>> 	Specify OWNED BY table.column or OWNED BY NONE.
>>
>> Yeah, and I think that's okay as-is, or at least we can't make it better
>> without fairly whole-sale changes of our documentation practices.
>> The fact that a table name can be schema-qualified is usually implicit,
>> and I don't see why this place cries out for making it explicit
>> more than other places.  You could as well complain that there's
>> nothing explicit here about double-quoting practices.
> 
> OK, I will do just the documentation patch for this then.

The same criticism applies to the documentation patch, I think.  We 
don't usually make the schema part explicit.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services