Subject | Re: [firebird-support] Re: From Restriced to CASCADE on delete |
---|---|
Author | Nando Dessena |
Post date | 2008-01-17T07:53:25Z |
Fidel,
Nando>> FWIW Firebird allows both RESTRICT and NO ACTION, and
Nando>> differentiates between them in the system tables (i.e. it is
Nando>> able to rebuild an ADD CONSTRAINT statement correctly). AFAIR
Nando>> IB always has.
j> Hum... which version of Firebird are you talking about? I have tried
j> the RESTRICT keyword on FB2.0.3 and it rejected it.
Sorry, I wasn't clear. RESTRICT is what you get if you don't specify
an ON UPDATE/ON DELETE clause, whereas NO ACTION you have to state
explicitly. They behave the same in Firebird.
Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================
Nando>> FWIW Firebird allows both RESTRICT and NO ACTION, and
Nando>> differentiates between them in the system tables (i.e. it is
Nando>> able to rebuild an ADD CONSTRAINT statement correctly). AFAIR
Nando>> IB always has.
j> Hum... which version of Firebird are you talking about? I have tried
j> the RESTRICT keyword on FB2.0.3 and it rejected it.
Sorry, I wasn't clear. RESTRICT is what you get if you don't specify
an ON UPDATE/ON DELETE clause, whereas NO ACTION you have to state
explicitly. They behave the same in Firebird.
Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================