| Subject | Re: [firebird-support] Re: From Restriced to CASCADE on delete |
|---|---|
| Author | Helen Borrie |
| Post date | 2008-01-16T23:27:31Z |
At 09:59 AM 17/01/2008, you wrote:
On the subject of use of the RESTRICT keyword as an action argument for referential constraints, I could be persuaded of that it was available in early implementations of RI in Interbase, because of the way NO ACTION is documented in the IB 5.5 Language Reference manual, viz. , "InterBase 5 maintains compatibility with the previous versions of InterBase, so changes to existing code are not required. The default action, NO ACTION, provides the same behavior as the previous version of InterBase." However, I can't find any reference to RESTRICT in the IB4 helpfiles for Windows...
./heLen
>--- In firebird-support@yahoogroups.com, Nando Dessena <nando@...> wrote:Or are we? Can you cite the source of this information?
>
>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.
>
>Hum... which version of Firebird are you talking about? I have tried
>the RESTRICT keyword on FB2.0.3 and it rejected it.
>
>I thought RESTRICT was supposed to be supported from FB2.0+
>
>Am I missing something here?
On the subject of use of the RESTRICT keyword as an action argument for referential constraints, I could be persuaded of that it was available in early implementations of RI in Interbase, because of the way NO ACTION is documented in the IB 5.5 Language Reference manual, viz. , "InterBase 5 maintains compatibility with the previous versions of InterBase, so changes to existing code are not required. The default action, NO ACTION, provides the same behavior as the previous version of InterBase." However, I can't find any reference to RESTRICT in the IB4 helpfiles for Windows...
./heLen