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 1g4sSB-0006t6-Ng for pgsql-docs@arkaria.postgresql.org; Tue, 25 Sep 2018 18:53:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1g4sS7-0001Bp-TP for pgsql-docs@arkaria.postgresql.org; Tue, 25 Sep 2018 18:52:55 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1g4sS7-0001Bh-7h for pgsql-docs@lists.postgresql.org; Tue, 25 Sep 2018 18:52:55 +0000 Received: from mail-yw1-xc44.google.com ([2607:f8b0:4864:20::c44]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1g4sRz-00015S-Oh for pgsql-docs@lists.postgresql.org; Tue, 25 Sep 2018 18:52:53 +0000 Received: by mail-yw1-xc44.google.com with SMTP id e201-v6so3697767ywa.3 for ; Tue, 25 Sep 2018 11:52:47 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=joeconway.com; s=google; h=subject:from:to:references:openpgp:autocrypt:message-id:date :user-agent:mime-version:in-reply-to; bh=SNXdXSxKHDmKiZTOb4sJV5fOdskh+KmaNFFr7Is0oCI=; b=KInLJmu+4N4m9/5wpw0rL8o+kVkZPw5E9RH69qngNzHBHSoo5ZT0CZMZFvC9UFNNCB tz94miaId775R3AI1ohJJh0m2q9BY8V8Eih2qTlCeKWrjxcud/zeowV327L0G56jjle9 d2lXwQYK8fdEVw0Iy3qaM9gQzmqEXLEoYXxn6fgLNRDEN6dgGWlTRgajiKnPelD/jj0I qwGHaoeit1h50n3eKfWDVUW5XUfqFJ45dRj/5yP3VmnMcf69rctuowx7F7B4rQ8ADDVW tNtuNZKSkrfFCI/DbWMECZVu1AAVIlC7Wd6+D9ZhkNaRn7O5VcLW/YgdNDuEDC8goA4+ RP9g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:subject:from:to:references:openpgp:autocrypt :message-id:date:user-agent:mime-version:in-reply-to; bh=SNXdXSxKHDmKiZTOb4sJV5fOdskh+KmaNFFr7Is0oCI=; b=UDN10ZjDueMkPWK9lQoWtfzfMOZDtbcMNS8dh5/yfzQwzYlic4/v2tfjaF/gjXNftw 9JXLH74kmk9hWjN+w3axCklg27n0aH3L9mpvjxdCF6W8eJeb3jmdmUF4KbqOer9ZuKeg BZyPF8wF6EuLjjFLoBpCZdaYu3c8HLGPIkG/WG3VZAdsvsOUegY9scdAXHtqW7TQgpJz jV7n2E+oaE5MBul6USlAKfirDNdN4A8tGboCgDtcpT6xVCJ2xGTaFzM/NAOrNBiJ7PU1 uW4OxeALtDfWRYAR2iqRbgw1ws7A93NKnTyDShrVqtwVSqXQbSyzo0FZNr3GzXGUFw3L kDYw== X-Gm-Message-State: ABuFfogy3boqrsp8cmSkYdIteFAVDciAbptN1Ee8Ll5XkT4B0BpeOAAF E6sd8v/N9W69vMQbiwf0B5hotndJWB8= X-Google-Smtp-Source: ACcGV62/VDRuzOkxHQ7+E1kEHrioQ4Lp8vI/PUbK9b5zAJ56gIYjhZRt9t0hYkI5w8lVwB9V8dvj7g== X-Received: by 2002:a81:608a:: with SMTP id u132-v6mr1290534ywb.89.1537901566487; Tue, 25 Sep 2018 11:52:46 -0700 (PDT) Received: from [192.168.4.41] ([72.17.18.98]) by smtp.gmail.com with ESMTPSA id v74-v6sm1681914ywa.19.2018.09.25.11.52.45 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Tue, 25 Sep 2018 11:52:45 -0700 (PDT) Subject: Re: dblink_get_result returns NULL if remote query throws error From: Joe Conway To: agomez@ebsco.com, pgsql-docs@lists.postgresql.org References: <153789006006.1219.7158416078641854892@wrigleys.postgresql.org> 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: <993e2a0a-c968-9abd-9183-d5edc73b1326@joeconway.com> Date: Tue, 25 Sep 2018 14:52:45 -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: Content-Type: multipart/signed; micalg=pgp-sha256; protocol="application/pgp-signature"; boundary="c7xX29Wz6vcuUy1mV18ByM5QataSijb0G" 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) --c7xX29Wz6vcuUy1mV18ByM5QataSijb0G Content-Type: multipart/mixed; boundary="WoaSGHfV4jK7p04ySSI19dxHnyVwGxNEI"; protected-headers="v1" From: Joe Conway To: agomez@ebsco.com, pgsql-docs@lists.postgresql.org Message-ID: <993e2a0a-c968-9abd-9183-d5edc73b1326@joeconway.com> Subject: Re: dblink_get_result returns NULL if remote query throws error References: <153789006006.1219.7158416078641854892@wrigleys.postgresql.org> In-Reply-To: --WoaSGHfV4jK7p04ySSI19dxHnyVwGxNEI Content-Type: text/plain; charset=utf-8 Content-Language: en-US Content-Transfer-Encoding: quoted-printable On 09/25/2018 01:06 PM, Joe Conway wrote: > 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-re= sult.html >> Description: >>=20 >> Please consider clarifying this page: >> https://www.postgresql.org/docs/current/static/contrib-dblink-get-resu= lt.html >> to state that if you call=20 >> select dblink_get_result ('mylink',false), you will receive back a NUL= L if >> the remote query threw an error. It is not clear on the page. At least= an >> example would be nice. >=20 > I will look at this as well as the similar one from a month+ ago that > has been languishing in my inbox. Actually, the doc page says this: 8<-------------- fail_on_error If true (the default when omitted) then an error thrown on the remote side of the connection causes an error to also be thrown locally. If false, the remote error is locally reported as a NOTICE, and the function returns no rows. 8<-------------- The case you describe does *not* return NULL, it returns no rows, which is exactly what the above says. I don't see anything needing fixing. If you have evidence otherwise, please provide an example. Joe --=20 Crunchy Data - http://crunchydata.com PostgreSQL Support for Secure Enterprises Consulting, Training, & Open Source Development --WoaSGHfV4jK7p04ySSI19dxHnyVwGxNEI-- --c7xX29Wz6vcuUy1mV18ByM5QataSijb0G 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 iQIcBAEBCAAGBQJbqoP9AAoJEDfy90M199hloVQP+wSxpLbjftQn3WRxWpMCUKPC z5QKYYGKHw3gM8gRmsF3vuxKre7OV8VlZELMgi+or5QVPtNwusSXOeWy7Trgm2bl LhDPOZLKKD+Wpz0QEs/0HdtgKLVlArqmiqvFlG64zOGw9tq2/ZndF7Z9sBqhcSq7 gI6f/lHILs1gn9kfvlpiTu9ht8bHwSvEMb4AsnZd6+ja70sZRPyMrI1OicMciZu5 1Z7iHo3Pf7EYYMVa0NGTknt4EU0VlgXgWrHX2kTMG7m7IFp6/kAu1TI+L5UZmhBB RapUlDqqhxNYRI/UD4a+ujkj0IQ7q+qEg1AMWAzHq3Dh0LH3oMlJDl3Y3lU8NxHs rfmFDnrdfuITpt8AuiEhlm58NJDOCZ0NlJiWuJ9zNetbWGqs49Roxc//uLO4KNwd 92bmeYNag5MozXtwdwY6u8DrGy/zhLsR2Q9f/hIH31S+2CHq1vqirvoN7liRxA4M 88o5TZPgHXUkXK4Wpx3SuUC+cSSm5srMRiSeKE3vlnNYMMOobTdCLdcVSy/brpUF k/lpo6+YZncEj5KUp7j+0A1z0ldWMbHkZ2gR6H4VKnckadleZdppmZkw9y2xFFiz Idnbxwyz6FRejmWE1/wZLDXKpu+ph6UudQRuhp8veIDLYGBOnoBsKkvU+ySaBmYo j2Z452U68h2H3FpjFpqj =1ILw -----END PGP SIGNATURE----- --c7xX29Wz6vcuUy1mV18ByM5QataSijb0G--