public inbox for [email protected]help / color / mirror / Atom feed
document effect of USAGE on foreign server to dblink 4+ messages / 2 participants [nested] [flat]
* document effect of USAGE on foreign server to dblink @ 2019-11-27 16:33 Jeff Janes <[email protected]> 2019-12-19 16:43 ` Re: document effect of USAGE on foreign server to dblink Bruce Momjian <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Jeff Janes @ 2019-11-27 16:33 UTC (permalink / raw) To: pgsql-docs I think that the permissions around the usage of foreign server names as connection names in dblink should be documented, as in the attached. 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? Cheers, Jeff Attachments: [application/octet-stream] server_dblink_priv.patch (608B, 3-server_dblink_priv.patch) download | inline diff: 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> ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: document effect of USAGE on foreign server to dblink 2019-11-27 16:33 document effect of USAGE on foreign server to dblink Jeff Janes <[email protected]> @ 2019-12-19 16:43 ` Bruce Momjian <[email protected]> 2019-12-19 20:54 ` Re: document effect of USAGE on foreign server to dblink Jeff Janes <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Bruce Momjian @ 2019-12-19 16:43 UTC (permalink / raw) To: Jeff Janes <[email protected]>; +Cc: pgsql-docs 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 <[email protected]> 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 + ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: document effect of USAGE on foreign server to dblink 2019-11-27 16:33 document effect of USAGE on foreign server to dblink Jeff Janes <[email protected]> 2019-12-19 16:43 ` Re: document effect of USAGE on foreign server to dblink Bruce Momjian <[email protected]> @ 2019-12-19 20:54 ` Jeff Janes <[email protected]> 2019-12-23 22:48 ` Re: document effect of USAGE on foreign server to dblink Bruce Momjian <[email protected]> 0 siblings, 1 reply; 4+ messages in thread From: Jeff Janes @ 2019-12-19 20:54 UTC (permalink / raw) To: Bruce Momjian <[email protected]>; +Cc: pgsql-docs On Thu, Dec 19, 2019 at 11:43 AM Bruce Momjian <[email protected]> wrote: > 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. > Yes, giving this permission gives you usage of it in a place that is non-obvious, and that the doc doesn't mention. Isn't the place about permission the correct place to document these non-obvious permissions? Cheers, Jeff ^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: document effect of USAGE on foreign server to dblink 2019-11-27 16:33 document effect of USAGE on foreign server to dblink Jeff Janes <[email protected]> 2019-12-19 16:43 ` Re: document effect of USAGE on foreign server to dblink Bruce Momjian <[email protected]> 2019-12-19 20:54 ` Re: document effect of USAGE on foreign server to dblink Jeff Janes <[email protected]> @ 2019-12-23 22:48 ` Bruce Momjian <[email protected]> 0 siblings, 0 replies; 4+ messages in thread From: Bruce Momjian @ 2019-12-23 22:48 UTC (permalink / raw) To: Jeff Janes <[email protected]>; +Cc: pgsql-docs On Thu, Dec 19, 2019 at 03:54:44PM -0500, Jeff Janes wrote: > > > On Thu, Dec 19, 2019 at 11:43 AM Bruce Momjian <[email protected]> wrote: > > 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. > > > Yes, giving this permission gives you usage of it in a place that is > non-obvious, and that the doc doesn't mention. Isn't the place about > permission the correct place to document these non-obvious permissions? How is using a foreign server name in dblink a permission? -- Bruce Momjian <[email protected]> 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 + ^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2019-12-23 22:48 UTC | newest] Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2019-11-27 16:33 document effect of USAGE on foreign server to dblink Jeff Janes <[email protected]> 2019-12-19 16:43 ` Bruce Momjian <[email protected]> 2019-12-19 20:54 ` Jeff Janes <[email protected]> 2019-12-23 22:48 ` Bruce Momjian <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox