Re: adding a constraint to child table that references a column of the parent table that is not part of the primary key
From: yossarian <yossarian99_at_operamail.com>
Date: Fri, 29 Jan 2010 14:34:52 +0100
Message-ID: <4b62e3fd$0$713$5fc30a8_at_news.tiscali.it>
Carlos wrote:
Date: Fri, 29 Jan 2010 14:34:52 +0100
Message-ID: <4b62e3fd$0$713$5fc30a8_at_news.tiscali.it>
Carlos wrote:
> Because of the read-commited mode, triggers cannot help you here.
Strange... I tried to write the trigger anyway and it seems to work. No "table is mutating..." error. Received on Fri Jan 29 2010 - 07:34:52 CST