From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andres Freund <andres@anarazel.de>
Cc: Andrew Dunstan <andrew@dunslane.net>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Joe Conway <mail@joeconway.com>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Corey Huinker <corey.huinker@gmail.com>
Cc: Nikita Glukhov <n.gluhov@postgrespro.ru>
Cc: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Subject: Re: Error-safe user functions
Date: Mon, 05 Dec 2022 20:19:26 -0500
Message-ID: <3524499.1670289566@sss.pgh.pa.us> (raw)
In-Reply-To: <20221206011404.i7gxuuzna25ej2hr@alap3.anarazel.de>
References: <20221205174231.6wpmbuxafnfzlbuh@alvherre.pgsql>
<85e40849-4458-bbb9-62ee-d9e7faf0c7dc@dunslane.net>
<3323802.1670263204@sss.pgh.pa.us>
<3496391.1670276406@sss.pgh.pa.us>
<20221205234734.sab3fuxy6q2sokjd@alap3.anarazel.de>
<3518534.1670285891@sss.pgh.pa.us>
<20221206005607.lxcrazckoalptwds@alap3.anarazel.de>
<3523582.1670288815@sss.pgh.pa.us>
<20221206011404.i7gxuuzna25ej2hr@alap3.anarazel.de>
Andres Freund <andres@anarazel.de> writes:
> On 2022-12-05 20:06:55 -0500, Tom Lane wrote:
>> Hmm, either I'm confused or you're stating that backwards --- aren't
>> the hard-error code paths already tested by our existing tests?
> What I'd like to test is a hard error, either due to an input function
> that wasn't converted or because it's a type of error that can't be
> handled "softly", but when using the "safe" interface.
Oh, I see. That seems like kind of a problematic requirement,
unless we leave some datatype around that's intentionally not
ever going to be converted. For datatypes that we do convert,
there shouldn't be any easy way to get to a hard error.
I don't really quite understand why you're worried about that
though. The hard-error code paths are well tested already.
regards, tom lane
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: tgl@sss.pgh.pa.us, andres@anarazel.de, andrew@dunslane.net, alvherre@alvh.no-ip.org, mail@joeconway.com, robertmhaas@gmail.com, corey.huinker@gmail.com, n.gluhov@postgrespro.ru, pgsql-hackers@lists.postgresql.org
Subject: Re: Error-safe user functions
In-Reply-To: <3524499.1670289566@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox