Re: optionally schema-qualified for table_name

2020-03-22 Thread Tom Lane
Bruce Momjian  writes:
> I see what you mean.  The attached patch fixes this, as well as
> adjusting the error message.  I didn't see any other cases.

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.

regards, tom lane




Re: optionally schema-qualified for table_name

2020-03-22 Thread Bruce Momjian
On Sun, Mar 22, 2020 at 03:05:01PM -0400, Tom Lane wrote:
> Bruce Momjian  writes:
> > I see what you mean.  The attached patch fixes this, as well as
> > adjusting the error message.  I didn't see any other cases.
> 
> 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.

I don't see any other messages with "table.column".  Do you want?

Specify OWNED BY column or OWNED BY NONE.

-- 
  Bruce Momjian  https://momjian.us
  EnterpriseDB https://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+  Ancient Roman grave inscription +




Re: optionally schema-qualified for table_name

2020-03-22 Thread Tom Lane
Bruce Momjian  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.

regards, tom lane




Re: optionally schema-qualified for table_name

2020-03-22 Thread Bruce Momjian
On Sun, Mar 22, 2020 at 06:20:04PM -0400, Tom Lane wrote:
> Bruce Momjian  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.

-- 
  Bruce Momjian  https://momjian.us
  EnterpriseDB https://enterprisedb.com

+ As you are, so once was I.  As I am, so you will be. +
+  Ancient Roman grave inscription +