On 3/7/18 20:57, Alvaro Herrera wrote: > So, unless someone has a brilliant idea on how to construct a column > mapping from partitioned table to partition, I'm going back to the > design I was proposing earlier, ie., creating individual pg_trigger rows > for each partition that are essentially adjusted copies of the ones for > the partitioned table.
Yes, that seems easiest. The idea of having only one pg_trigger entry was derived from the assumption that we wouldn't need the other ones for anything. But if that doesn't apply, then it's better to just go with the straightforward way instead of bending the single-pg_trigger way to our will. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
