On 2018-Jun-08, Alvaro Herrera wrote:
> Actually, the column order doesn't matter for a trigger function,
> because these don't refer to columns by number but by name. So unless
> users write trigger functions in C and use hardcoded column numbers
> (extremely unlikely), I think this is not an issue. In other words, in
> the interesting cases the trigger functions are the same for all
> partitions -- therefore upgrading from separate per-partition triggers
> to one master trigger in the partitioned table is not going to be that
> difficult, ISTM.
One last thing. This wording has been there since pg10; the only thing
that changed is that it now says "BEFORE ROW triggers" instead of "Row
triggers". I don't think leaving it there one more year is going to get
us too much grief, TBH.
I'm going to leave this as an open item for one or two more weeks and
see if there's more support for Ashutosh's PoV; but if not, my proposal
is to close it without changing anything further.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
