Re: Table rewrite supporting functions for event triggers
Greg Sabino Mullane <htamfids@gmail.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: pgsql-docs <pgsql-docs@lists.postgresql.org>
Date: 2024-09-03T15:10:57Z
Lists: pgsql-docs
On Mon, Sep 2, 2024 at 9:57 PM Laurenz Albe <laurenz.albe@cybertec.at> wrote: > I think that it would be better to add a reference to > > https://www.postgresql.org/docs/16/functions-event-triggers.html#FUNCTIONS-EVENT-TRIGGER-TABLE-REWRITE > than to repeat that information. > > If you feel that "The exact meaning of the codes is release dependent" is > unnecessarily > vague, that sentence should be changed. > Okay, that's a good point, will do so in the next patch. A "bitmap of reasons" to me would mean that each reason is a bit, and if > two reasons apply at the same time, both bits are set. But that's clearly not what you > mean, because > "a column has a new data type" is not the same as "the table has changed > persistence" > and at the same time "a column has changed a default value". > > Perhaps "a bitmap of reasons" should simply become "the reason". > No, it really is a bitmap, as you can get a reason of "5" for example, if you change the persistence and a data type in the same ALTER TABLE command, e.g. alter table foo set unlogged, alter id type bigint; But I wrote it wrong: they should be 1,2,4,8. Cheers, Greg
Commits
-
doc: Add better description for rewrite functions in event triggers
- 93a596c73517 13.17 landed
- bca802600c7f 14.14 landed
- 14440d3b07af 15.9 landed
- a1b859c6893a 16.5 landed
- 709ce29b1656 17.1 landed
- 4b7bba49e712 18.0 landed