Re: Getting "could not read block" error when creating an index on a function.

Поиск
Список
Период
Сортировка
От Christophe Pettus
Тема Re: Getting "could not read block" error when creating an index on a function.
Дата
Msg-id 61B3A8FF-C56A-4619-86D0-8D30D05225CB@thebuild.com
обсуждение исходный текст
Ответ на Re: Getting "could not read block" error when creating an index on a function.  (Christophe Pettus <xof@thebuild.com>)
Список pgsql-general

> On Dec 30, 2020, at 11:48, Christophe Pettus <xof@thebuild.com> wrote:
>
> This might be a good use for a generated column.
>
>     https://www.postgresql.org/docs/current/ddl-generated-columns.html

I take that back; the generation formula has to be immutable as well.  Perhaps a column populated by a trigger?
--
-- Christophe Pettus
   xof@thebuild.com




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

Предыдущее
От: Christophe Pettus
Дата:
Сообщение: Re: Getting "could not read block" error when creating an index on a function.
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Getting "could not read block" error when creating an index on a function.