Re: Delete of child-entry locks father-table

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: 8 Dec 2006 02:55:06 -0800
Message-ID: <1165575306.523500.196660@j44g2000cwa.googlegroups.com>

thomas.kyte_at_oracle.com wrote:
> a) don't look at the lock table
> b) why does a delete from child lock parent
>
> It seems unambiguous to me - no lock table is involved and they say an
> operation on child locks parent - which it doesn't
>
> so, I guess unless they clarify - we'll never really know :)
> ...

Tom, the subject of the thread is a bit misleading.

TEST_CONFIG is the parent (father) table and TEST_PRODUCTION is the child table. Buried in the OP is the following: LOCK TABLE TEST_CONFIG IN EXCLUSIVE MODE NOWAIT; The post also contains this code, which seems a bit unusual: ALTER TABLE TEST_CONFIG ADD (
  FOREIGN KEY (PREVID)
    REFERENCES TEST_CONFIG (CONFIGID)
    ON DELETE SET NULL DEFERRABLE INITIALLY IMMEDIATE); Could the above be the source of the problem?

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Fri Dec 08 2006 - 04:55:06 CST