Re: pg_partition_tree crashes for a non-defined relation - Mailing list pgsql-hackers

From Tom Lane
Subject Re: pg_partition_tree crashes for a non-defined relation
Date
Msg-id 19520.1544382449@sss.pgh.pa.us
Whole thread Raw
In response to Re: pg_partition_tree crashes for a non-defined relation  (Stephen Frost <sfrost@snowman.net>)
Responses Re: pg_partition_tree crashes for a non-defined relation
Re: pg_partition_tree crashes for a non-defined relation
List pgsql-hackers
Stephen Frost <sfrost@snowman.net> writes:
> * Tom Lane (tgl@sss.pgh.pa.us) wrote:
>> ... especially in code that's highly unlikely to break once written.

> I don't entirely buy off on the argument that it's code that's 'highly
> unlikely to break once written' though- we do add new relkinds from time
> to time, for example.  Perhaps we could have these functions run just
> once per relkind.

Well, the relevant code is likely to be "if relkind is not x, y, or z,
then PG_RETURN_NULL".  If we add a new relkind and forget to consider the
function, the outcome is a NULL result that perhaps should not have been
NULL ... but a test like this won't help us notice that.

            regards, tom lane


pgsql-hackers by date:

Previous
From: Sergei Kornilov
Date:
Subject: Re: [HACKERS] REINDEX CONCURRENTLY 2.0
Next
From: Marti Raudsepp
Date:
Subject: [PATCH] Minor cleanups of BRIN code