Hello Yong, Thank you for the quick reply.
Thanks Sri Krishna On Thu, May 26, 2011 at 6:13 PM, Yong Liang <[email protected]> wrote: > Hi Sri, > > Sorry that your case is not supported in the current version. We will > investigate it and hopefully can add this feature in the next release. > > Yong > > > On 11-05-26 11:26 AM, "Sri Krishna Suresh Kumar" <[email protected]> > wrote: > >> Hello Again, >> >> I am trying to setup a database with relations into biomart. >> I am facing a problem where there is multi-relation between the tables. >> For example I am trying to setup the following table with the structure >> >> CREATE TABLE Parent >> ( >> id int(10) NOT NULL, >> sample varchar(10) NOT NULL, >> PRIMARY KEY (id) >> ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >> >> CREATE TABLE Child >> ( >> id1 int(10) NOT NULL, >> id2 int(10) NOT NULL, >> relation varchar(10) NOT NULL, >> INDEX (id1), >> INDEX (id2), >> FOREIGN KEY (id1) REFERENCES Parent (id), >> FOREIGN KEY (id2) REFERENCES Parent (id) >> ) ENGINE=InnoDB DEFAULT CHARSET=utf8; >> >> In this case, Biomart does not allow to add the database and gives an >> error saying "An relation already exist between these two keys" and >> throws out an exception. I was wondering if this can be avoided? Or >> how would one go about setting such relations. >> >> Thanks and Regards, >> Sri Krishna >> _______________________________________________ >> Users mailing list >> [email protected] >> https://lists.biomart.org/mailman/listinfo/users > > > _______________________________________________ Users mailing list [email protected] https://lists.biomart.org/mailman/listinfo/users
