Re: pg_get_constraintdef failing with cache lookup error - Mailing list pgsql-bugs

From Michael Paquier
Subject Re: pg_get_constraintdef failing with cache lookup error
Date
Msg-id CAB7nPqRCWCCicwUpNt79FP_J2royv54B9z=1zXvhCUQe3BCg9w@mail.gmail.com
Whole thread Raw
In response to Re: pg_get_constraintdef failing with cache lookup error  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-bugs
On Tue, Apr 28, 2015 at 3:15 AM, Robert Haas <robertmhaas@gmail.com> wrote:
> On Mon, Apr 27, 2015 at 11:16 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Michael Paquier <michael.paquier@gmail.com> writes:
>>> pg_get_constraintdef() fails rather easily:
>>> =# select pg_get_constraintdef(1);
>>> ERROR:  cache lookup failed for constraint 1
>>
>> It's expected that the caller will supply a valid pg_constraint OID.
>> I don't think it's necessary to go out of our way to throw a friendlier
>> error message if the OID isn't found.
>
> It's clearly at least a bug in the comment to complain that it can't
> happen if in fact it can.  But I would argue that we should never hit
> an elog just because of bad user input.

Fine for me to just remove the comment, constraintdef is the only *def
function that has such one.
--
Michael

Attachment

pgsql-bugs by date:

Previous
From: Thomas Munro
Date:
Subject: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Next
From: georgi-georgiev-pgsql@japannext.co.jp
Date:
Subject: BUG #13182: pgadmin3 not showing in application list