Hi
There is some kind of constraint corruption here - the foreign key has become associated with the wrong index
internally. Not sure how that happened. It was probably a bug in an earlier version that we've fixed already, since I
could not find a sequence of commands that managed to replicate the situation.
This sequence seems to fix your problem :
ALTER TABLE TERMEJB DROP CONSTRAINT FK_TERMEJB_MASTERTERM_ID;
DROP INDEX TERMIDMASTERTERMFKINDEX;
ALTER TABLE TERMEJB ADD FOREIGN KEY (MASTERTERM_ID) REFERENCES TERMEJB(ID);
Just be sure to make a backup before you try it.
Regards, Noel.
On 2013-11-11 15:20, Ralf wrote:
FOREIGN KEY (*MASTERTERM_ID*) REFERENCES "PUBLIC"."TERMEJB"(*ID*);
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to h2-database+unsubscr...@googlegroups.com.
To post to this group, send email to h2-database@googlegroups.com.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
