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 <br...@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 +
