Robert Knutsson

I missed that, thanks for the clarification Fred

Hi, When reading http://hsqldb.org/doc/guide/databaseobjects-chapt.html#dbc_schema_def_statements I see the syntax for constraint creation supports adding INITIALLY DEFERRED as check time. However I cant seem to get this to work, instead getting a syntax error. Assuming i have two tables, bar and foo. each containing an id and bar also containging a field ext This is the query I execute alter table public.bar add constraint bar_foo foreign key (ext) references public.foo(id) INITIALLY DEFERRED DEFERRABLE;...