Subject Re: [firebird-support] Re: Default DRI action configuration
Author Mark Rotteveel
> --- In firebird-support@yahoogroups.com, "unordained" <unordained_00@...>
> wrote:
> >
> > ---------- Original Message -----------
> > From: "sqlsvr" <sqlsvr@...>
> > > Is there anyway to specify the default DRI action in the Firebird
> configuration?
> > ------- End of Original Message -------
> >
> > By which you mean "unless otherwise specified, I want my foreign keys to
> be
> > (e.g.) ON UPDATE CASCADE, ON DELETE SET NULL"? Not that I know of.
> >
> > -Philip
> >
>
>
> Yes, exactly. This would be a very useful feature to have. Could be
> defined at the configuration level and overridden at the database level and table
> level.

I disagree, it would lead to weird bugs and unexpected errors, because a script and/or program designed with the default behavior in mind could behave totally different, cause data-loss etc when it is run on a server that has the default changed (or on a database that was created using that changed setting).
--
GMX DSL: Internet-, Telefon- und Handy-Flat ab 19,99 EUR/mtl.
Bis zu 150 EUR Startguthaben inklusive! http://portal.gmx.net/de/go/dsl