bug with foreign keys

[Thomas Markus]

Hi,

i got a problem with foreign keys in 7.4.3-032

2 tables with 2 fks

if i run

ALTER TABLE TABLE1 ADD  FOREIGN KEY
        FBTABLE1_1 ( REFCOL1 ) REFERENCES TABLE2 (ID)
                ON DELETE RESTRICT;

ALTER TABLE TABLE1 ADD  FOREIGN KEY
        FBTABLE1_2 ( REFCOL1 ) REFERENCES TABLE2 (ID)
                ON DELETE RESTRICT;

all works ok. but if i change one delete rule, the second comes with
[-4009]: Unknown referential constraint name

i want execute

ALTER TABLE TABLE1 ADD  FOREIGN KEY
        FBTABLE1_1 ( REFCOL1 ) REFERENCES TABLE2 (ID)
                ON DELETE CASCADE;

ALTER TABLE TABLE1 ADD  FOREIGN KEY
        FBTABLE1_2 ( REFCOL1 ) REFERENCES TABLE2 (ID)
                ON DELETE SET NULL;

how can i perform this?

REFCOL1 is set to NOT NULL
REFCOL2 is nullable

thanks

--
Thomas Markus
Tel: 030 29 36 399 - 18
mailto:[EMAIL PROTECTED]
Proventis GmbH
Torellstr. 1
10243 Berlin

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]