db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrej Tibaut <andrej.tib...@uni-mb.si>
Subject RE: ON UPDATE CASCADE in derby
Date Fri, 25 Nov 2005 13:55:20 GMT
That was also my original question months ago. We made a way around this
programatically. Obviously, nothing changed until today.

Regards,
Andrej

÷-----Original Message-----
÷From: Vasja Pupkin [mailto:trash@gonivo.org.ua]
÷Sent: 24. november 2005 13:43
÷To: derby-user@db.apache.org
÷Subject: ON UPDATE CASCADE in derby
÷
÷Is there any chance to implement such statement in derby?
÷
÷CREATE TABLE A (
÷    ax INTEGER NOT NULL,
÷
÷    PRIMARY KEY(ax)
÷);
÷
÷CREATE TABLE B (
÷
÷    bx INTEGER NOT NULL,
÷
÷    FOREIGN KEY (bx)     REFERENCES A (ax)
÷    ON UPDATE CASCADE -- can't make this work
÷    ON DELETE CASCADE
÷);
÷
÷
÷P.S. I found this working in HSQL, M$SQL, PostgreSQL... but
÷not in debry :(
÷
÷




Mime
View raw message