Re: Indexes on expressions that include user-defined functions are not reindexed when the function definition is changed

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Dmytry Strikha <dm(dot)strikha(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: Indexes on expressions that include user-defined functions are not reindexed when the function definition is changed
Date: 2019-06-05 18:36:00
Message-ID: 20190605183600.GA11763@alvherre.pgsql
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 2019-May-29, Dmytry Strikha wrote:

> Could this get a special mention in the documentation for Indexes on
> expressions? Most unfamiliar users will look there to figure out the
> correct way to create the index and will be at least warned.

That sounds reasonable. Care to submit a patch?

--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2019-06-05 21:36:48 BUG #15836: Casting 'of' to boolean type should throw an invalid input syntax
Previous Message Alvaro Herrera 2019-06-05 18:27:42 Re: BUG #15831: pgadmin bug: add column and comment failure when you alter table