Re: Re: Unexpected result from ALTER FUNCTION— looks like a bug

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: Unexpected result from ALTER FUNCTION— looks like a bug
Дата
Msg-id 2715948.1650425528@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Unexpected result from ALTER FUNCTION— looks like a bug  ("David G. Johnston" <david.g.johnston@gmail.com>)
Ответы Re: Unexpected result from ALTER FUNCTION— looks like a bug  (Bryn Llewellyn <bryn@yugabyte.com>)
Список pgsql-general
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> Might I suggest the following:
> + /*
> + * For each action, modify procForm to type-safely set the new value.
> + * However, because the SET clause is repeatable we handle it
> + * a bit differently, modifying the underlying tuple directly.  So
> + * make sure to leave that conditional block for last.
  + */

Actually, the reason proconfig is handled differently is that it's
a variable-length field, so it can't be represented in the C struct
that we overlay onto the catalog tuple to access the fixed-width
fields cheaply.  I'm not sure that insisting that that stanza be
last is especially useful advice for future hackers, because someday
there might be more than one variable-length field that this function
needs to update.

            regards, tom lane



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

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Unexpected result from ALTER FUNCTION— looks like a bug
Следующее
От: Ram Pratap Maurya
Дата:
Сообщение: RE: Huge archive log generate in Postgresql-13