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

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Demitri Muna <postgresql(at)demitri(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Getting "could not read block" error when creating an index on a function.
Date: 2020-12-30 19:49:32
Message-ID: 61B3A8FF-C56A-4619-86D0-8D30D05225CB@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Dec 30, 2020, at 11:48, Christophe Pettus <xof(at)thebuild(dot)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(at)thebuild(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2020-12-30 20:14:31 Re: Getting "could not read block" error when creating an index on a function.
Previous Message Christophe Pettus 2020-12-30 19:48:26 Re: Getting "could not read block" error when creating an index on a function.