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)