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.89)
	(envelope-from <pgsql-docs-owner+archive@lists.postgresql.org>)
	id 1ihytU-0000JA-Bc
	for pgsql-docs@arkaria.postgresql.org; Thu, 19 Dec 2019 16:43:20 +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 1ihytT-0005UZ-3i
	for pgsql-docs@arkaria.postgresql.org; Thu, 19 Dec 2019 16:43:19 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256)
	(Exim 4.89)
	(envelope-from <bruce@momjian.us>)
	id 1ihytS-0005US-Of
	for pgsql-docs@lists.postgresql.org; Thu, 19 Dec 2019 16:43:18 +0000
Received: from momjian.us ([72.94.173.45])
	by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <bruce@momjian.us>)
	id 1ihytP-0004ke-Lq
	for pgsql-docs@postgresql.org; Thu, 19 Dec 2019 16:43:17 +0000
Received: from bruce by momjian.us with local (Exim 4.92)
	(envelope-from <bruce@momjian.us>)
	id 1ihytO-0006LJ-Le; Thu, 19 Dec 2019 11:43:14 -0500
Date: Thu, 19 Dec 2019 11:43:14 -0500
From: Bruce Momjian <bruce@momjian.us>
To: Jeff Janes <jeff.janes@gmail.com>
Cc: pgsql-docs@postgresql.org
Subject: Re: document effect of USAGE on foreign server to dblink
Message-ID: <20191219164314.GO30116@momjian.us>
References: 
 <CAMkU=1z7Qky8c0TQ011wPgiriy3qVHVZeOhYgaOccqScRPM19w@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
Content-Disposition: inline
Content-Transfer-Encoding: 8bit
In-Reply-To: 
 <CAMkU=1z7Qky8c0TQ011wPgiriy3qVHVZeOhYgaOccqScRPM19w@mail.gmail.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, Nov 27, 2019 at 11:33:03AM -0500, Jeff Janes wrote:
> I think that the permissions around the usage of foreign server names as
> connection names in dblink should be documented, as in the attached.

Uh, this looks like an odd place to document it, since this part is
talking about permissions.

> Also, for dblink itself it says "It is recommended to use the foreign-data
> wrapper dblink_fdw when defining the foreign server".  Is there a reason for
> this recommendation?  postgres_fdw seems to work fine on the surface, is there
> some hidden trap in using it?

I have no idea.

---------------------------------------------------------------------------


> 
> Cheers,
> 
> Jeff

> diff --git a/doc/src/sgml/ddl.sgml b/doc/src/sgml/ddl.sgml
> index 0be0774..a171a00 100644
> --- a/doc/src/sgml/ddl.sgml
> +++ b/doc/src/sgml/ddl.sgml
> @@ -1829,7 +1829,8 @@ REVOKE ALL ON accounts FROM PUBLIC;
>        <para>
>         For foreign servers, allows creation of foreign tables using the
>         server.  Grantees may also create, alter, or drop their own user
> -       mappings associated with that server.
> +       mappings associated with that server. Grantees may also use the foreign
> +       server as a connection name in <xref linkend="dblink"/>.
>        </para>
>       </listitem>
>      </varlistentry>


-- 
  Bruce Momjian  <bruce@momjian.us>        http://momjian.us
  EnterpriseDB                             http://enterprisedb.com

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