Re: pg_get_constraintdef failing with cache lookup error

Поиск
Список
Период
Сортировка
От Michael Paquier
Тема Re: pg_get_constraintdef failing with cache lookup error
Дата
Msg-id CAB7nPqRCWCCicwUpNt79FP_J2royv54B9z=1zXvhCUQe3BCg9w@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_get_constraintdef failing with cache lookup error  (Robert Haas <robertmhaas@gmail.com>)
Список 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

Вложения

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Thomas Munro
Дата:
Сообщение: Re: BUG #12990: Missing pg_multixact/members files (appears to have wrapped, then truncated)
Следующее
От: georgi-georgiev-pgsql@japannext.co.jp
Дата:
Сообщение: BUG #13182: pgadmin3 not showing in application list