POC: contrib/unaccent as IMMUTABLE

From: Petru Ghita <petru(dot)ghita(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: POC: contrib/unaccent as IMMUTABLE
Date: 2020-10-03 10:53:35
Message-ID: CALv_7oVkmY9k6DVp47kqoJZZSp4tN7qjxdTuJrUbc7tNuvDXGQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,

Would it be possible to mark functions in contrib/unnaccent [1] as IMMUTABLE?

We would gain the possibility to use it to enforce uniqueness.

I understand that the main drawback is that unicode rules are
periodically updated. So it would be needed to reindex indices on
unaccent() after upgrade.

Thank you,
petru ghita

[1] https://github.com/postgres/postgres/tree/master/contrib/unaccent

Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2020-10-03 11:03:11 Re: VACUUM PARALLEL option vs. max_parallel_maintenance_workers
Previous Message Amit Kapila 2020-10-03 10:15:53 Re: Parallel copy