Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g4qmx-0002MV-Mf for pgsql-docs@arkaria.postgresql.org; Tue, 25 Sep 2018 17:06:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g4qmw-0003to-41 for pgsql-docs@arkaria.postgresql.org; Tue, 25 Sep 2018 17:06:18 +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_SHA384:256) (Exim 4.89) (envelope-from ) id 1g4qmv-0003th-Hx for pgsql-docs@lists.postgresql.org; Tue, 25 Sep 2018 17:06:17 +0000 Received: from mail-yw1-xc41.google.com ([2607:f8b0:4864:20::c41]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1g4qms-0008GE-Jt for pgsql-docs@lists.postgresql.org; Tue, 25 Sep 2018 17:06:17 +0000 Received: by mail-yw1-xc41.google.com with SMTP id q129-v6so9599729ywg.8 for ; Tue, 25 Sep 2018 10:06:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=joeconway.com; s=google; h=subject:to:references:from:openpgp:autocrypt:message-id:date :user-agent:mime-version:in-reply-to; bh=T75CFlEhHt05UyzO4w/HQJKMsr91x7mBzYvaVRQz1xE=; b=SOjt9D8Ak1NaVCU6huULAaake9qxuAk9ASHwmtSPo64l19fOowznxA/53Ud7EtFsay KdNvxyXgHrWPqWS/5yQUjp72J555+hosOsB8FWWlw5f5NwVGuW5D/PWWDwxvvYd2RTHQ VugGWW6iSVtq5NHC2l/iBIb2pAC+IKYTtVqa13y1Co560HRrPNvZffd2AuDs1UqGNEG5 f7WO3W/bpWLbW/wUbVQgaiz6CYH4J2dmdJryeMfWLO66hed0wZyqGtgx0a5ow3hegUHi d8ykIvSy1mE2ESRieL7DJQ1e7V1WtF60w/xi3N4Lok7LEE3Iu9eSMoFMXZTifwvliUPK L5uw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:to:references:from:openpgp:autocrypt :message-id:date:user-agent:mime-version:in-reply-to; bh=T75CFlEhHt05UyzO4w/HQJKMsr91x7mBzYvaVRQz1xE=; b=pxnSHJU3nfvhemD/UY38NzjwGqTue2bEQhUl+fDFZYUaHr2ox4rPdcuSRD1pj9swx3 d2r/1T+U8zzLQwl3ArGA+5JVSRKRTCeKj5duHYjuVAs418Y0XWwimjE1GOg4jNK6bGVx w/qw5KyJXhxSVtZiB7Ss18j1YY0JS/SpNONWh6xizLJdB80vxHvTJO7iNLnXnSzREXiA 1AzHsweUXcKupwf4tJ9EpxHCc0kaBi0zxzKOyxxPv7zeFSVtxktkUuV5HfryPr7nQeCN iwP5MubUdJRnMoLZB/Ov7Uyb5Uv0AAsyMXy1HtvAQO6DAz1sSg1V/b/4LKfXR9E2JO5E pIxg== X-Gm-Message-State: ABuFfog2G3Lws0A224PVokDZnXy/D6ZAmoI57xibub0HYdZ5Zzac6R01 3IQYAPQHaTwFE7DvMjJ06NcB/Te1Ksk= X-Google-Smtp-Source: ACcGV61V2mwG4BaBZWXjt3toXlgRoISLuqWmkVcQR42DtEhw2nJgmy4J8WubPxYzZMHUp4HAb0bJlA== X-Received: by 2002:a81:3d12:: with SMTP id k18-v6mr1084419ywa.452.1537895171005; Tue, 25 Sep 2018 10:06:11 -0700 (PDT) Received: from [192.168.4.41] ([72.17.18.98]) by smtp.gmail.com with ESMTPSA id v74-v6sm1343591ywa.19.2018.09.25.10.06.10 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 25 Sep 2018 10:06:10 -0700 (PDT) Subject: Re: dblink_get_result returns NULL if remote query throws error To: agomez@ebsco.com, pgsql-docs@lists.postgresql.org References: <153789006006.1219.7158416078641854892@wrigleys.postgresql.org> From: Joe Conway Openpgp: preference=signencrypt Autocrypt: addr=mail@joeconway.com; keydata= xsFNBEpXMCsBEADDnXUQzjlyi/cX02Gtdy2CLcroE5CsC7DJKdOBDbfgn0kfiIYoV5JniG4l VyzZUodY8yUAagqLYolh0UkBzs9N+qkm7erde4ypw3jzVQ37BuzIvk3nMUbuDZDgxWqX+nVS sKc+BQ5BpzgCHg48leoRO2ohjvYnUhgH3j2rFZCzaj6qQ7mv+XoxOJmUlVQtG06Jwkk7Vu14 7U9nMMM6hyUKzVnmCphnlcMNo26UyVU70MwFfFJgcI0c5fpp8byN56eD6VJVnufO5WAuEhzE qcrSJR2FAlmM90GBY+6vP29twLDCHuSFvrnujNCx/BvCC/a3/gPvyAFp4JtMm9eXAmq3m/Kw 94nTJXVdcbQeQQDp3KIG7MmWS4lnGvPn8v0CjgNaLvZXFLo1FgmUVsyEq1Lww4iRLa6sbpXJ ESx15UEue1k1YZM9C+4F/o3aeKNsAienjw2EXFzcaxIg/C4P493VMi3Qa8ycVxR5iYhUbYdo DFIUQhbFNsYfrtW/qZAELT3FCYFpZYG01e9Hj+cBrXXgyDDkQ5Lq4mlvmkRvuxn61V6Au4HA 0sJiCox5pM1FvzT+aI8HY1BYaiB9Pl4fhpKgmhhlSuglk9v39S4jmlUIb45iLAUVpeNM6Qjm 69pf5da9sm4aGFa7YlDSKf/WcU7z9ITZxsilOi2n7YJiwG7kTQARAQABzR9Kb2UgQ29ud2F5 IDxtYWlsQGpvZWNvbndheS5jb20+wsF8BBMBAgAmAhsDBwsJCAcDAgEGFQgCCQoLBBYCAwEC HgECF4AFAlpoksUCGQEACgkQMyt+aLaZQ0p4XQ/9F4WSf4ZFuL3ae356ApVqnLxphHXeXHli ePZe7qosvXMQLN9Y2m5cQwqojsQh4pZujIi4Iwxw7ORg6HbMO8dMhyu8TlDavErcgO561hG7 /TCcCLf5SkadxBqYWAJH09W8S2iC3gQtS+qs4Y7sIvRi881EsPzG5Lrzu7Ei8ufqsSnbLUQk zAaKjK3IzAFvzA3VCg/8Aqhf8obhqL0j5I5DNOpAt2U4gkEzIrX1g5xSXpRLMHLEK7hPViY8 pFQyRvyZioE4hckNsnidCgiv4HefJUFRIVxDkHBeLhTzqTPloesFT/bskhckIS6F4suMx044 WTTW6UiARuWw3aaBTmxay2rjPCsGaJPawzY0O3HlNlZherCzuBpa+Qk1kMLkcxMlYjCrMgIR YyBpIK46ltPQaog4Ujh21w1Z8m/ufG5v/HTuLdXM9hGfTlW7aY6psCAV/MwfycDHLRMc+UY7 W2cp6DlWQ7GHLP+vzvBcl5Odi04EhcYnHMZjKvRFsxhE0LZcTejrtxPkDgR9G59irlIx1+py ziK2B0hs7Er1Yq7qQGQiQGLoglSNDsvsUeyMGyabasmUd5xrRO35SpGv+hyYGAZ3Pyk9Vtxl CO7BJkZiV9YSMHp6hOdmYZd4SZRChd9sKd6eSw1xIlBALz1ZHuQVMBuZvuVGFsS81Zqckb/2 D5rOwU0ESlcyJwEQAOkTBb9yDhJbMUgvhM11rZwT5tm4Y9TqtEHn0Zy3t9g7bdFFpMvav/KE Nd3oAtLFpMDf+H3AggFk4ftUwJwiVgJ88ilvCynJUGXiuYIaexY4DLgn4xpnuiEpYEFVdWnl w7dWVTc62exfqIz9bSWRzwfBCY9ruYGEb4RDPDSNSAVyI7sxHzef2asiYxIcxrTrw5VugWNl PZcV5/EJ6PUvATjBF2TBkXV7KOciQng2tsQGrGMkY5mduNqwpuh6zfPcVF8LeObe96wv5ZhP RpO79nef7hnK2lJogp3JIo558Jlbz9WHtQEMZR85+bUhtI825QyNAFz3Jrn7NMgvDikc2OrW o7YMgMC5hDSWVFqA6/EQCNnDWGABWgeYHZFpnPwsvUWIYdhSilUuj/Tuzvz9ZmucFNbQbauD Qw6VQ38ofGnoYDZFJsGncprB8dBi4tDrIQ+1RlIh6C2Z/eMipqJOT26+spluTjouvnKT0S5y OgyX0PjbsysgwQdCGNJLHOjhHbSpSmOLaduV3CQo/0+DHT/TBjYfIXjTWouY9TkGxG4eNrxU 0u2xAy5bMqOPmsFdjLTWlQUlF/fTMhB54XwI3FHWgnSnXZzStDTmTebLNdT/ftgliAzA81uM j49j0exv731/v+7udLA1bV8gnZ01zQCASDpWiRQR3fgwcugSUqgRABEBAAHCwV8EGAEIAAkF AkpXMicCGwwACgkQMyt+aLaZQ0pwAQ//bjcWnZg/jjRQ9gbZUGMqniItZYRglBMKIqt4Fia3 79JmHwTvavnFkJ8XMZ56UB0FIrgS+sUkRH6cPRQR+7Qi392LD021DXgSsz9CwFHjFyBGHwLE OTRcfYQbtJy0shHDJB4aQTOX3ERDH1PsvJNuevmQMzS0DWFav9+xMz9rKP4N+HffoBIZE0C1 xIE43nD4eLsbycte9sVIrmlNuUti3qUxJAQw8HwfJ6ZbBInHxquApR16uD1u99o6XlndFrDl Y22tRmHCM0bR81GfGNdcU3Uo+rG/R/k4qa7s9/dgKvMbyH3fHhp/ceKag80Xo8IFurRl0ZJP 3sHJ2QDHCVLat7jRZ+43hi1WlIhFbrgn6IyI0i7XR/W8JjrC5MsKq4TUwGH077sU/kcHYebV JZRbUUst2hAGHDFVBcG12qoKf+ltL9qXJc1y7BGeCoUW6QjOpljpq6ZL4FQUsM0RSRjs5egE 3szPcIf5SyPK6WDOApoAq6M7BBFMGDZwEylYMtr0YekA1u86UA9D2xwLHEbBBp/uiby1c9Jb PJ1Pn8zJP8WZNeRw4Q9TtqVK09+oLirMUSpIDd6KdZ1VgRxOK2re7tjDvkVuYsSrsiJ+1iJN Enp9iK0ok0DlJpSCe6KhkxpaTdeoWMXdKuJWec0NIqoAd54ZgBPnr+UPxTixgPq/p6Q= Message-ID: Date: Tue, 25 Sep 2018 13:06:09 -0400 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:52.0) Gecko/20100101 Thunderbird/52.9.1 MIME-Version: 1.0 In-Reply-To: <153789006006.1219.7158416078641854892@wrigleys.postgresql.org> Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="EpA9cunZ653HVgPzgUi76CHJUAd6Rz043" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk This is an OpenPGP/MIME signed message (RFC 4880 and 3156) --EpA9cunZ653HVgPzgUi76CHJUAd6Rz043 Content-Type: multipart/mixed; boundary="K2yBigkS2niyeWB3xBVpLiSIcYkRsYfKW"; protected-headers="v1" From: Joe Conway To: agomez@ebsco.com, pgsql-docs@lists.postgresql.org Message-ID: Subject: Re: dblink_get_result returns NULL if remote query throws error References: <153789006006.1219.7158416078641854892@wrigleys.postgresql.org> In-Reply-To: <153789006006.1219.7158416078641854892@wrigleys.postgresql.org> --K2yBigkS2niyeWB3xBVpLiSIcYkRsYfKW Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 09/25/2018 11:41 AM, PG Doc comments form wrote: > The following documentation comment has been logged on the website: >=20 > Page: https://www.postgresql.org/docs/9.3/static/contrib-dblink-get-res= ult.html > Description: >=20 > Please consider clarifying this page: > https://www.postgresql.org/docs/current/static/contrib-dblink-get-resul= t.html > to state that if you call=20 > select dblink_get_result ('mylink',false), you will receive back a NULL= if > the remote query threw an error. It is not clear on the page. At least = an > example would be nice. I will look at this as well as the similar one from a month+ ago that has been languishing in my inbox. Joe --=20 Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development --K2yBigkS2niyeWB3xBVpLiSIcYkRsYfKW-- --EpA9cunZ653HVgPzgUi76CHJUAd6Rz043 Content-Type: application/pgp-signature; name="signature.asc" Content-Description: OpenPGP digital signature Content-Disposition: attachment; filename="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v2 iQIcBAEBCAAGBQJbqmsBAAoJEDfy90M199hlzHMP/3lkKBBsyTPIxPPbQXq47r5j VYbDKsQCHYJeMaQE5iykSHmRE6dbLXJVM6vphS/W4TOAJHpzNU812ivhk93JGDKu YB9pvucX0/uf65SP8aFAGtsA6IuNyCTVHyCMob6VnknCaPAQjzqRINXaDNr0Yrr2 Z51goTqZLt1/7TLqyeleOem+Mbt+8jJeVA5beT2nJcblOKyjQLO+Uf5jDqERoI39 3p7boPUFK7BdW80WS80B20NZEWLNYek4CJQFVWMaeQfwrny+Nz1c74oqFCuMYGH4 N/ZgObu+I3V795tQfrDYz/GGl3ppZH4Gaao1iOFeeUSJmok5Oxj64SanPz38GHBk ZVCF9NL1s4IRPGjqV7vNT+Eu3G+E2Ebg/WNoPeY/5UnZbBLcWLoRlZ+JRZrfuuRQ eH97QEJoZtWSV6mb1BRLNPoiDMKuW/eLPr6XrHAUkGrs5bomxQolmvrhJ4ZVVlay /ox/KsItJK20Yjdxtn554A9HNMMWTMVhrK9/xjz1LHqSw/OgDU6wji/EoyEXdBWP iyvy1m1hwL6zeTqIo45pQubLGSYrt6aB5P6VKUpc9AnaBMecg77uQ51BrINqpy4L ml6E3YSMTXat8dkvOa6XLzAp8bblFNy23p+baaypWY3KE+qyIKeQUBI8IR3Y2X44 YF011Y+eZyoAIGAu4+lU =X9PU -----END PGP SIGNATURE----- --EpA9cunZ653HVgPzgUi76CHJUAd6Rz043--