Re: v12.4 pg_dump .sql fails to load data via psql

For the case where it actually matters we do exactly this.  Triggers.  For check constraints, assuming you actually apply them to the existing data when they are enabled or created, there is little benefit to be gained compared to just evaluating the rows as they are recorded.  That benefit would be strictly performance related in any case - there are no timing issues because check constraints can only reference the table upon which they are created.

I would suggest you not "work-around this" at all but instead properly define triggers to implement the desired logic.  That was the take-away you were intended from reading the documentation section you quoted (note, you should generally check current version documentation, 9.4 is seriously out-of-date).

David J.

P.S. As others have been doing, it is customary to post replies inline (or strictly at the bottom at worst) with the material you are replying to, and to liberally trim away unneeded context.  The mailing list thread for the conversation is much easier to consume when people do this.