maria-discuss team mailing list archive
-
maria-discuss team
-
Mailing list archive
-
Message #00887
deferrable constraints syntax?
Hi all,
I'm trying to create a deferrable foreign key constraint, according to the knowledge base article at https://kb.askmonty.org/en/constraint_type-foreign-key-constraint/. The syntax of "deferrable initially deferred" doesn't seem to be recognised. Without it, the tables are created just fine. I'm using MariaDB 5.5.31. Example:
create table one (
id int primary key
);
create table two (
id int primary key,
one_ref int,
constraint fk foreign key(one_ref) references one(id) deferrable initially deferred
);
=> error:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'deferrable initially deferred
)' at line 4
Any idea what's wrong? Is this only supported in MariaDB 10.x?
Thanks!
Best regards
Joeri Leemans
Follow ups