Can't add fkey in browser20

From: Pete Forman <gsez020_at_compo.bedford.waii.com>
Date: 1997/10/17
Message-ID: <tug1q0wij9.fsf_at_compo.bedford.waii.com>#1/1


I have been unable to define a relationship in the schema editor of Oracle browser. The error message is BRW-15380: Foreign key must reference primary or unique key.

The referenced column is a primary key - it is shown in bold. Adding a NOT NULL constraint did not help. The same error is indicated whether using ctrl-MS1 or the Define Relationship dialog to try to add the foreign key.

The relationship can be added using SQL*Plus and then shows up after restarting the schema editor. EDIT_SCHEMA has been enabled in BROWSER_PROFILE. Versions are

    Oracle Browser - Extended Edition, 2.0.9.2.5 Production     Oracle Server 7.3.2
    AIX 4.1.4

-- 
Pete Forman
Western Geophysical
pete.forman_at_bedford.waii.com
Received on Fri Oct 17 1997 - 00:00:00 CEST

Original text of this message