Re: constraints and InnoDB

2002-11-27 Thread Heikki Tuuri
Dyego, - Original Message - From: "Dyego Souza do Carmo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Mysql maillist" <[EMAIL PROTECTED]> Sent: Wednesday, November 27, 2002 2:44 PM Subject: constraints and InnoDB > Hi ! :D > >

Re: constraints and InnoDB

2002-11-27 Thread Rafal Jank
> >Is there a way to create constraints that implements the rules I >need? > Not really. You would have to use deferrable constraints (checked at commit, not after statement) like in Oracle. For now Innodb doesn't support it. P.S. query,sql -- _/_/ _/_/_/ - RafaƂ Jan

constraints and InnoDB

2002-11-27 Thread Dyego Souza do Carmo
Hi ! :D I would like you help me to solve the following problem: Suppose the tables below: create table book ( Bk_Id integer(4) unsigned not null auto_increment primary key, Bk_Name varchar(20) ) type = innoDb; create table page ( Pg_Id integer(4) unsigned not n