Hi
We have a similar setting for skipping actually doing the constraint
checking, but what we __don't__ allow is setting up constraints that
reference non-existent tables.
Note that we already support a lot of MySQL-specific syntax, like the
"ENGINE=" stuff, which we just ignore.
You could try getting a schema dump where the constraints are specified
out-of-line, that might make it easier to apply.
Regards, Noel.
On 2013-07-17 09:09, Patrick Wright wrote:
Hi Noel
in MySQL itself, it is possible to skip constraint checks on create
tables (apparently) via
SET FOREIGN_KEY_CHECKS = 0;
(http://dev.mysql.com/doc/refman/5.6/en/server-system-variables.html#sysvar_foreign_key_checks,
"Disabling foreign key checking can be useful for reloading InnoDB
tables in an order different from that required by their parent/child
relationships.")
How that is actually implemented in the MySQL server, and whether
that's at all possible in H2, is another question.
In practical terms, my problem is that I am not the owner of this
schema, so if I create a cleaned-up version of the database dump, with
tables in dependency order, then I have to maintain that across
changes to the original schema. I'm already doing some simple
pre-processing to remove MySQL syntax that H2 appears to not accept
(things like the ENGINE=). But with tables that's a more
time-consuming problem to solve as it involves re-ordering chunks of
the script.
If this behavior is not supported in H2, I'll see if I can get
separate dumps for tables without constraints, and for the constraints
alone.
Thanks again for the clarification.
Patrick
On Tuesday, July 16, 2013 6:15:49 PM UTC+2, Noel Grandin wrote:
Sorry, there isn't much we can do about that.
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
--
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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/groups/opt_out.
