On 28 June 2013 16:09, David Greco wrote:

Yes, renaming the trigger does in fact work. Any thoughts on the theory of
this behavior? i.e. is this ANSI compliant? Or should there be a mechanism
in place that guarantees the FK-enforcement trigger runs after all others?
Hmm, it doesn't conform to the SQL standard, which clarifies that with NOTE
31, p.66 in 4.17.2 though doesn't specifically mention triggers.

We claim conformance to the standard on this.

You can change the name of the constraint that implements the FKs on the
DDL but can't change the names of the underlying triggers except by doing
that directly, which doesn't seem that useful.

Should we have a parameter to define precedence of RI checks? We could hoik
out the triggers and execute them last, or leave them as they are,
depending upon the setting.

  Simon Riggs http://www.2ndQuadrant.com/
  PostgreSQL Development, 24x7 Support, Training & Services

Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 6 of 8 | next ›
Discussion Overview
grouppgsql-general @
postedJun 28, '13 at 12:45p
activeJun 28, '13 at 4:57p



site design / logo © 2021 Grokbase