Re: ON UPDATE CASCADE - is there such a thing?

From: harry <a_at_abc.com>
Date: Thu, 24 Jun 2004 15:44:40 GMT
Message-ID: <IFCCc.1646$%_1.15951000@news-text.cableinet.net>

Should have included this -

ALTER TABLE required_resource ADD ( CONSTRAINT fk_reqres_resnameid FOREIGN KEY ( res_name_id ) REFERENCES MANPOWER_FORECAST ( res_name_id ) ON DELETE CASCADE ); so if "res_name_id" changes in "MANPOWER_FORECAST" I want all "res_name_id"'s in "required_resource" to be updated! Received on Thu Jun 24 2004 - 10:44:40 CDT

This message: [ Message body ]
Next message: Oliver Zeigermann: "Re: Serializable transactions get rolled back while there are no othertransactions running?!"
Previous message: harry: "ON UPDATE CASCADE - is there such a thing?"
In reply to: harry: "ON UPDATE CASCADE - is there such a thing?"
Next in thread: Michel Cadot: "Re: ON UPDATE CASCADE - is there such a thing?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US