| From: | Christophe Pettus <xof(at)thebuild(dot)com> |
|---|---|
| To: | Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> |
| Cc: | Bryn Llewellyn <bryn(at)yugabyte(dot)com>, pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: User's responsibility when using a chain of "immutable" functions? |
| Date: | 2022-06-29 13:41:35 |
| Message-ID: | F7C03996-CE0C-4CEB-927B-3201FEBE9248@thebuild.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Jun 28, 2022, at 23:42, Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at> wrote:
> That is not enough in the general case. You are not allowed to redefine
> an IMMUTABLE function in a way that changes its behavior [...]
I think "not allowed" is putting it too strongly. It would be a bit much to ask that every single user-written immutable function be 100% perfect when it is rolled out, and never have to fix any bugs in them. However, you definitely *do* have to understand that there are administrative consequences for doing so, like rebuilding indexes and invalidating session caches. I think that the OP's statement that you can't ever use user-defined functions from an immutable function is too strong, too; you need to be aware of the consequences if you change an immutable function in a way that alters the return result for a previously-valid set of arguments.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Özge Özyavuz | 2022-06-29 13:43:28 | RE: help for pg_wal issue |
| Previous Message | Amit Kapila | 2022-06-29 10:48:12 | Re: Support logical replication of DDLs |