MIME-Version: 1.0
From: Jeff Janes <jeff.janes@gmail.com>
Date: Wed, 27 Nov 2019 11:33:03 -0500
Message-ID: 
 <CAMkU=1z7Qky8c0TQ011wPgiriy3qVHVZeOhYgaOccqScRPM19w@mail.gmail.com>
Subject: document effect of USAGE on foreign server to dblink
To: pgsql-docs@postgresql.org
Content-Type: multipart/mixed; boundary="000000000000ae93ae0598568d72"
Precedence: bulk

--000000000000ae93ae0598568d72
Content-Type: multipart/alternative; boundary="000000000000ae93ac0598568d70"

--000000000000ae93ac0598568d70
Content-Type: text/plain; charset="UTF-8"

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

--000000000000ae93ac0598568d70
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">I think that the permissions=C2=A0around the usage of fore=
ign server names as connection names in dblink should be documented, as in =
the attached.<div><br></div><div>Also, for dblink itself it says &quot;It i=
s recommended to use the foreign-data wrapper dblink_fdw when defining the =
foreign server&quot;.=C2=A0 Is there a reason for this recommendation?=C2=
=A0 postgres_fdw seems to work fine on the surface, is there some hidden tr=
ap in using it?<br><div><br></div><div>Cheers,</div><div><br></div><div>Jef=
f</div></div></div>

--000000000000ae93ac0598568d70--

--000000000000ae93ae0598568d72
Content-Type: application/octet-stream; name="server_dblink_priv.patch"
Content-Disposition: attachment; filename="server_dblink_priv.patch"
Content-Transfer-Encoding: base64
Content-ID: <f_k3hi2wrm0>
X-Attachment-Id: f_k3hi2wrm0

ZGlmZiAtLWdpdCBhL2RvYy9zcmMvc2dtbC9kZGwuc2dtbCBiL2RvYy9zcmMvc2dtbC9kZGwuc2dt
bAppbmRleCAwYmUwNzc0Li5hMTcxYTAwIDEwMDY0NAotLS0gYS9kb2Mvc3JjL3NnbWwvZGRsLnNn
bWwKKysrIGIvZG9jL3NyYy9zZ21sL2RkbC5zZ21sCkBAIC0xODI5LDcgKzE4MjksOCBAQCBSRVZP
S0UgQUxMIE9OIGFjY291bnRzIEZST00gUFVCTElDOwogICAgICAgPHBhcmE+CiAgICAgICAgRm9y
IGZvcmVpZ24gc2VydmVycywgYWxsb3dzIGNyZWF0aW9uIG9mIGZvcmVpZ24gdGFibGVzIHVzaW5n
IHRoZQogICAgICAgIHNlcnZlci4gIEdyYW50ZWVzIG1heSBhbHNvIGNyZWF0ZSwgYWx0ZXIsIG9y
IGRyb3AgdGhlaXIgb3duIHVzZXIKLSAgICAgICBtYXBwaW5ncyBhc3NvY2lhdGVkIHdpdGggdGhh
dCBzZXJ2ZXIuCisgICAgICAgbWFwcGluZ3MgYXNzb2NpYXRlZCB3aXRoIHRoYXQgc2VydmVyLiBH
cmFudGVlcyBtYXkgYWxzbyB1c2UgdGhlIGZvcmVpZ24KKyAgICAgICBzZXJ2ZXIgYXMgYSBjb25u
ZWN0aW9uIG5hbWUgaW4gPHhyZWYgbGlua2VuZD0iZGJsaW5rIi8+LgogICAgICAgPC9wYXJhPgog
ICAgICA8L2xpc3RpdGVtPgogICAgIDwvdmFybGlzdGVudHJ5Pgo=
--000000000000ae93ae0598568d72--