-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 El 13/05/13 17:06, Tom Lane escribió: > hcu...@exa.unicen.edu.ar writes: >> PostgreSQL version: 8.4.17 > >> After statments triggers on child tables are sometimes executed and >> sometimes are not. As I far as I could see, when the after trigger is >> defined in only one of the tables it may not get executed, wether when it is >> defined in every inherited table it does, but >> which one is undetermined. > > This test case appears to work the way you're expecting in 9.0 and > later. I didn't immediately find a mention of such a change in the > commit logs; perhaps it got fixed as a side-effect of the changes that > moved trigger processing into ModifyTable plan nodes. Anyway, I doubt > we'd consider changing trigger behavior in 8.4.x at this late date. > You should update to a newer release series if this is a problem for you. > > regards, tom lane
Thank you Tom, The update to 9.x is already planned, and the workaround I mentioned in the post works for me. regards, Hugo - -- mailto:hcu...@exa.unicen.edu.ar http://www.exa.unicen.edu.ar/~hcurti Firma digital GPG/PGP: http://www.exa.unicen.edu.ar/~hcurti/firma_hcurti.asc Puede hacer una donación indirecta (gratis) de un plato de comida para un niño de la Argentina ahora mismo ingresando a http://www.porloschicos.com/servlet/PorLosChicos?comando=donar -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.10 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAlGRZLEACgkQy9s+D7eSFvn2uwCeL3v4sQpkLgvN3xmHIVYN/2Ic NEcAoOrR+NXMzfarmgKxjDSun2docaC5 =6buB -----END PGP SIGNATURE----- -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs