Re: General error;-7040 POS(1) Referential constraint not allowed.

[Sven K�hler]

what did i do wrong?
what might cause this error?

it's a simple create table command.

i'm still searching for a small example to reproduce this, but it's harder than i thought.

i couldn't find any simpler test-case.
i cannot imagine, why this should fail, but the last create table command fails (with the error in the subject):

CREATE TABLE base_landesverb�nde (
id_lvb INT DEFAULT SERIAL,
PRIMARY KEY (id_lvb))
//
CREATE TABLE base_bundesl�nder (
id_bundesland INT DEFAULT SERIAL,
PRIMARY KEY (id_bundesland))
//
CREATE TABLE data_benutzer (
id_benutzer INT DEFAULT SERIAL,
id_lvb INT ,
FOREIGN KEY id_lvb(id_lvb) REFERENCES base_landesverb�nde(id_lvb) ON DELETE CASCADE,
PRIMARY KEY (id_benutzer))
//
CREATE TABLE pa_data_artikel (
id_artikel INT DEFAULT SERIAL,
id_lvb INT ,
id_bundesland INT ,
FOREIGN KEY id_lvb(id_lvb) REFERENCES base_landesverb�nde(id_lvb) ON DELETE CASCADE,
FOREIGN KEY id_bundesland(id_bundesland) REFERENCES base_bundesl�nder(id_bundesland) ON DELETE CASCADE,
PRIMARY KEY (id_artikel))
//
CREATE TABLE pa_data_artikel_hist (
id_hist INT DEFAULT SERIAL,
id_artikel INT NOT NULL,
id_benutzer INT ,
FOREIGN KEY id_artikel(id_artikel) REFERENCES pa_data_artikel(id_artikel) ON DELETE CASCADE,
FOREIGN KEY id_benutzer(id_benutzer) REFERENCES data_benutzer(id_benutzer) ON DELETE SET NULL,
PRIMARY KEY (id_hist))

What have i dont wrong?
Thx
Sven


_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general