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)
Список
Дерево обсуждения
Getting "could not read block" error when creating an index on a function. Demitri Muna <postgresql@demitri.com>
Re: Getting "could not read block" error when creating an index on a function. Tom Lane <tgl@sss.pgh.pa.us>
Re: Getting "could not read block" error when creating an index on a function. Demitri Muna <postgresql@demitri.com>
Re: Getting "could not read block" error when creating an index on a function. Christophe Pettus <xof@thebuild.com>
Re: Getting "could not read block" error when creating an index on a function. Christophe Pettus <xof@thebuild.com>
Re: Getting "could not read block" error when creating an index on a function. Karsten Hilbert <Karsten.Hilbert@gmx.net>
Re: Getting "could not read block" error when creating an index on a function. Tom Lane <tgl@sss.pgh.pa.us>
Re: Getting "could not read block" error when creating an index on a function. Demitri Muna <postgresql@demitri.com>
> On Dec 30, 2020, at 11:48, Christophe Pettus 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
Дата:
От: Tom Lane
Дата:
