bad data with Foreign Key constraint

Hi All,

I have found that there are some foreign keys in our detail tables while
there are not primary keys in master tables.

Yes, we have FK constraints on detail tables.

I could not think how it can happen. PG (7.3.2) does not have "disable
constraint" like Oracle, does it?

Sample data from PG:

select rid from c except select rid from r;

rid

-------------

7686396

7688003

7906141

7974816

8033807

(5 rows)

\d c

Table "public.c"

Column | Type |
Modifiers

---------------+--------------------------+-----------------------------
-----------------------

cid | integer | not null default
nextval('c_id_seq'::text)

rid | integer | not null

others...|

Indexes: c_pkey primary key btree (cid),

c_rid_idx btree (rid)

Foreign Key constraints: $1 FOREIGN KEY (rid) REFERENCES r(rid) ON
UPDATE NO ACTION ON DELETE CASCADE

Thank for your help!