Subject | Firebird 3: Not able to UPDATE RDB$Procedures |
---|---|
Author | Chuck Belanger |
Post date | 2018-05-31T15:51:26Z |
Hello:
Per googling and Carlos Cantu's FB3 Migration Guide (page: 110), we are
still allowed to set RDB$PROCEDURE_SOURCE = null, and yet when trying to
do just that on my app's converted FB2.5 to FB3 database, I am getting
"update not allowed on Systems tables." ISC ERROR CODE 335545030
I noticed a mention that at some point there will be another option to
blank out this metadata information, but more likely in FB4.
To make this issue more interesting, from within IB_Expert, I can do an
update of the RDB$Procedures table on one converted DB, but not on the
working DB. As far as I can tell the tables and DB are essentially the same.
Does anyone know what is going on here? Is there another way to blank
out the Procedure source code?
Thank you!
Chuck Belanger
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
Per googling and Carlos Cantu's FB3 Migration Guide (page: 110), we are
still allowed to set RDB$PROCEDURE_SOURCE = null, and yet when trying to
do just that on my app's converted FB2.5 to FB3 database, I am getting
"update not allowed on Systems tables." ISC ERROR CODE 335545030
I noticed a mention that at some point there will be another option to
blank out this metadata information, but more likely in FB4.
To make this issue more interesting, from within IB_Expert, I can do an
update of the RDB$Procedures table on one converted DB, but not on the
working DB. As far as I can tell the tables and DB are essentially the same.
Does anyone know what is going on here? Is there another way to blank
out the Procedure source code?
Thank you!
Chuck Belanger
---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus