Postgres Pro
Downloads
Home   >   mailing lists

Re: Getting "could not read block" error when creating an index on a function. - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Getting "could not read block" error when creating an index on a function.
Date
Msg-id 61B3A8FF-C56A-4619-86D0-8D30D05225CB@thebuild.com
Whole thread Raw
In response to Re: Getting "could not read block" error when creating an index on a function.  (Christophe Pettus <xof@thebuild.com>)
List pgsql-general
Tree view 

> 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 by date:

Previous
From: Christophe Pettus
Date:
Subject: Re: Getting "could not read block" error when creating an index on a function.
Next
From: Tom Lane
Date:
Subject: Re: Getting "could not read block" error when creating an index on a function.