Re: adding a constraint to child table that references a column of the parent table that is not part of the primary key
From: Carlos <miotromailcarlos_at_netscape.net>
Date: Fri, 29 Jan 2010 05:48:19 -0800 (PST)
Message-ID: <7e263286-bb34-47fb-96d9-f2597bc7d7ff_at_m25g2000yqc.googlegroups.com>
On Jan 29, 2:34 pm, yossarian <yossaria..._at_operamail.com> wrote:
> 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.
Date: Fri, 29 Jan 2010 05:48:19 -0800 (PST)
Message-ID: <7e263286-bb34-47fb-96d9-f2597bc7d7ff_at_m25g2000yqc.googlegroups.com>
On Jan 29, 2:34 pm, yossarian <yossaria..._at_operamail.com> wrote:
> 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.
It's not about 'table is mutating', it's about multiuser envirnoment and concurrency.
Cheers.
carlos. Received on Fri Jan 29 2010 - 07:48:19 CST