Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.92)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1jHCMh-0000B3-Ts
	for pgsql-docs@arkaria.postgresql.org; Wed, 25 Mar 2020 20:11:04 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1jHCMg-00047g-Fl
	for pgsql-docs@arkaria.postgresql.org; Wed, 25 Mar 2020 20:11:02 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <bruce@momjian.us>)
	id 1jHCMg-00047Y-7o
	for pgsql-docs@lists.postgresql.org; Wed, 25 Mar 2020 20:11:02 +0000
Received: from momjian.us ([72.94.173.45])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <bruce@momjian.us>)
	id 1jHCMc-0007B9-7m
	for pgsql-docs@lists.postgresql.org; Wed, 25 Mar 2020 20:11:01 +0000
Received: from bruce by momjian.us with local (Exim 4.92)
	(envelope-from <bruce@momjian.us>)
	id 1jHCMY-0007dA-6b; Wed, 25 Mar 2020 16:10:54 -0400
Date: Wed, 25 Mar 2020 16:10:54 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, protodef@gmail.com,
	pgsql-docs@lists.postgresql.org
Subject: Re: optionally schema-qualified for table_name
Message-ID: <20200325201054.GA27957@momjian.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>
 <af0208b5-7811-955b-3ddf-d5839c4a4798@2ndquadrant.com>
 <20200324205818.GA32258@momjian.us>
 <4b09907d-96de-c1da-34cd-787877503385@2ndquadrant.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <4b09907d-96de-c1da-34cd-787877503385@2ndquadrant.com>
User-Agent: Mutt/1.10.1 (2018-07-13)
List-Id: <pgsql-docs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-docs@lists.postgresql.org>
List-Owner: <mailto:pgsql-docs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-docs>
Precedence: bulk

On Wed, Mar 25, 2020 at 01:46:54PM +0100, Peter Eisentraut wrote:
> On 2020-03-24 21:58, Bruce Momjian wrote:
> > That is a good point. I used CREATE VIEW as an example because that is
> > what the user reported, but it seems only create_view and reindexed use
> > a schema name qualification:
> > 
> > 	$ grep  -l '<replaceable>schema</replaceable>' *.sgml
> > 	create_view.sgml
> > 	reindexdb.sgml
> > 
> > The reindexdb use is because of -S (reindex schema), which makes sense.
> > The create view case is used in an example of CREATE RECURSIVE VIEW and
> > should probably be removed.
> 
> The CREATE RECURSIVE VIEW example is making a specific point about schema
> qualification, which is explained below the example.

OK, so I guess everything is fine and we can just go back to other
business.  :-)   Sorry for the distraction.

-- 
  Bruce Momjian  <bruce@momjian.us>        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 +