Disable Constraint

[Nitai @ Razuna]

Hi all,

I'm doing a rather huge import from a Oracle database to H2 and see
that I get errors like "Referential integrity constraint violation".

Now, I know why and thus the question is it possible to disable
constraint checking for the complete database or single tables?

I already checked the information_schema.settings and did not see
anything there.

Any help, much appreciated.

Kind Regards,
Nitai

--
See for yourself how easy it is to manage files today. Join the revolution!

Razuna SaaS On-Demand - Hosted Digital Asset Management Solution
http://www.razuna.com/

Razuna - Open Source Digital Asset Management
http://www.razuna.org/

Follow us on Twitter
http://twitter.com/razunahq

[Thomas Kellerer]

On Dec 29, 11:48 pm, "Nitai @ Razuna" <ni...@razuna.com> wrote:
> thus the question is it possible to disable
> constraint checking for the complete database or single tables?

http://www.h2database.com/html/grammar.html#set_referential_integrity

[Nitai @ Razuna]

Dude, I searched for 2 hours and could not see anything......... I
think it's time for bed now :-) Thanks a lot.

On Wed, Dec 30, 2009 at 12:33 AM, Thomas Kellerer
<google...@sql-workbench.net> wrote:
>> thus the question is it possible to disable
>> constraint checking for the complete database or single tables?
>
> http://www.h2database.com/html/grammar.html#set_referential_integrity
>

--