referential integrity

[Arne Gehlhaar]

Hi again.

I am trying to create these ref. integrity constraints on a table:

alter table TABLE1
    add foreign key FK_TAB1_TAB2 (t2id)
       references TABLE2 (t2id) on delete restrict
alter table TABLE1
    add foreign key FK_TAB1_TAB3 (t3id)
       references TABLE3 (t3id) on delete cascade
The first one works, the second one results in an error:

General error;-8030 POS(1) Column must be indexed.
Why? Both referenced columns (t2id, t3id) are primary keys.

Who can help?
Arne
--
Institute of Shipping Economics and Logistics    http://www.isl.org/
Arne Gehlhaar                                mailto:[EMAIL PROTECTED]
Universitaetsallee GW1 Block A                phone:+49.421.22096.49
D-28359 Bremen, Germany                         fax:+49.421.22096.55
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general