Thread: inconstistent inheritance in 7.1?
Why does a SELECT apply to all tables, including inherited ones and not UPDATEs or DELETEs? Is there a way to UPDATE a whole table hierarchy in one fell swoop? TIA -- HIPPOLYTE: Donnerai-je l'exemple � la t�m�rit� ? Et dans un fol amour ma jeunesse embarqu�e... (Ph�dre, J-B Racine, acte 1, sc�ne 1)
On Thu, Feb 22, 2001 at 02:45:46PM +0100, Louis-David Mitterrand wrote: > Why does a SELECT apply to all tables, including inherited ones and not > UPDATEs or DELETEs? Is there a way to UPDATE a whole table hierarchy in > one fell swoop? Oops, I take that back; indeed it UPDATEs and DELETEs apply to inherited tables, however triggers don't. -- OENONE: De quel droit sur vous-m�me osez-vous attenter ? Vous offensez les Dieux auteurs de votre vie ; (Ph�dre, J-B Racine, acte 1, sc�ne 3)