Subject | RE: [firebird-support] Firebird Dependency issue |
---|---|
Author | Alan McDonald |
Post date | 2006-03-14T11:17:43Z |
> Hi,please don't set your emails to high importance.
>
> I have application using Firebird 1.5.2 as the Database. Now the
> application has a feature of receiving application updates and hence
> automatically updating itself without any user intervention. But I
> facing an issue with updating the schema or procedures in my database
> since firebird maintains a dependency list in RDB$DEPENDENCIES system
> table. I want to know that is there any way where I can disable the
> dependencies for the procedures or tables I am altering then apply the
> scripts and then enable or recreate the dependencies again.
>
>
>
> Regards,
>
> Mahendra Nepali
the answer to this is "not without trashing your database" sooner or later.
A safer approach is to upgrade your application with a database upgrade
script. Your DB has a table which contains a version number. Each time the
app starts it tests a match between the application and the db, if required,
the application runs the upgrade script after first ensuring that it's the
only connection to the DB... there are other details which we can chat about
if this sounds interting to you.
Alan