From: | "Hugo J(dot) Curti" <hcurti(at)exa(dot)unicen(dot)edu(dot)ar> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-bugs(at)postgresql(dot)org |
Subject: | Re: BUG #8152: strange behavior regarding after triggers and inheritance |
Date: | 2013-05-13 22:09:54 |
Message-ID: | 519164B2.20304@exa.unicen.edu.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
El 13/05/13 17:06, Tom Lane escribió:
> hcurti(at)exa(dot)unicen(dot)edu(dot)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:hcurti(at)exa(dot)unicen(dot)edu(dot)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-----
From | Date | Subject | |
---|---|---|---|
Next Message | lr | 2013-05-14 04:31:51 | BUG #8156: PostGIS crash with immutable functions when immutable function throws an error |
Previous Message | Tom Lane | 2013-05-13 20:06:39 | Re: BUG #8152: strange behavior regarding after triggers and inheritance |