Jan Solca wrote : >Hi,
>Hope that someone can help me since I'm stuck here and >don't really understand why I'm getting the error. >I have two table cat and users. >create table category ( > id integer default serial, > label varchar(50) UNIQUE, > commenttext long, > primary key (id) >) >create table users ( > id integer default serial, > login varchar(50) NOT NULL UNIQUE, > role varchar(10) DEFAULT 'user', > deleted char(1) default 'f', > session_id char(32) DEFAULT NULL, > password char(32), > email char(50), > primary key (id) >) >Up to here no problem, but as I tried to define the >proc table I got the -7040 error message stating that >"referential constraint not allowed". >create table process ( > id integer default serial, > label varchar(50), > category_id integer references category(id), > commenttext long, > owner_id integer references users(id) , > create_time timestamp DEFAULT now(), > create_user integer references users(id) on >delete set null, > examine char(1), > primary key (id) >) Please have a look into http://listserv.sap.com/pipermail/sapdb.general/2001-April/007021.html Thomas -- Thomas Anhaus SAP DB, SAP Labs Berlin [EMAIL PROTECTED] http://www.sapdb.org/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
