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 <>
Date: Fri, 29 Jan 2010 05:48:19 -0800 (PST)
Message-ID: <>

On Jan 29, 2:34 pm, yossarian <> 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.


carlos. Received on Fri Jan 29 2010 - 07:48:19 CST

Original text of this message