Re: AW: General error;-6013 POS(1) Duplicate trigger definition

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/maxdb?unsub=gcdm-maxdb@xxxxxxxxxxx