Jean-Michel OLTRA a �crit :
bonjour,
Le jeudi 26 ao�t 2004, Xavier CAMIER a �crit...
Thank you for replying but as explained in the mail the trigger I created appears nowhere and that's my problem.
Yes I did it and I'm wondering how it can be refused as it appears nowhere at all :-(
Below is a message of mine and Thomas Anhaus answer. As you can see, I couldn't drop a fk which didn't appear in DOMAIN.FOREIGNKEYS...
I did recover the database.
Sent: Sonntag, 4. Januar 2004 20:21 To: MaxDb Subject: foreign key
I try to execute some statement and... -24988,ERR_SQL: sql error -3007,Invalid sequence of DML and DDL statements
well, may be a problem with the last FOREIGN KEY I added on Christmas... I search DOMAIN.FOREIGNKEYS for this table: no foreign key using the name I thought.
I then try to add this FOREIGN KEY with an ALTER TABLE statement: -24988,ERR_SQL: sql error -6006,Duplicate name
So I try now to drop this foreign key with another ALTER TABLE DROP FOREIGN KEY: -24988,ERR_SQL: sql error -4009,Unknown referential constraint name
I fear that that your catalog concerning foreign keys is corrupted. From experience I know that it will be hard to find the reason for that corruption after the event. This requires knowledge about the schema, and all actions executed on it. If you remember that, please let me know. Otherwise I recommend to recover the database to a valid state.
Merci,
I hate reading that kind of answer but that's also what I thought :-) Anyway as explained in one of my previous posts, when I drop the table the curors, views... linked to the droped table are also dropped. Everything seems working fine now.
Thanks for your help.
P.S. There will be a new thread soon about cascade triggers
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
