Subject | FB 2.1 Metadata Upgrade Failure |
---|---|
Author | gorepj |
Post date | 2008-02-26T09:43:49Z |
I am experiencing some difficulty updating the metadata to FB2.1.
My DB has two tables with associated descriptions containing the
pound sign £, and some triggers that have embedded comments
containing non-ASCII letters.
I attempted to use the suggested metadata upgrade process and here's
my findings.
~~~~~~~~~~~~~~~~~~~~~~~~~~
Firebird correction text
Creating the procedures in the database
---------------------------------------
- 1. isql database.fdb
- 2. SQL> input 'misc/upgrade/metadata_charset_create.sql';
Should be
- 2. SQL> input '../misc/upgrade/metadata_charset_create.sql';
Fixing the metadata
-------------------
- 1. isql database.fdb
- 2. SQL> input 'misc/upgrade/metadata_charset_create.sql';
- 3. SQL> select * from rdb$fix_metadata('WIN1252'); -- replace
WIN1252 by your charset
- 4. SQL> commit;
Point 2 as above.
Point 3 executes OK
Point 4 fails for me. I get error `attempt to update read only
column'.
~~~~~~~~~~~~~~~~~~~~~~~~~
Regards
Peter Gore
My DB has two tables with associated descriptions containing the
pound sign £, and some triggers that have embedded comments
containing non-ASCII letters.
I attempted to use the suggested metadata upgrade process and here's
my findings.
~~~~~~~~~~~~~~~~~~~~~~~~~~
Firebird correction text
Creating the procedures in the database
---------------------------------------
- 1. isql database.fdb
- 2. SQL> input 'misc/upgrade/metadata_charset_create.sql';
Should be
- 2. SQL> input '../misc/upgrade/metadata_charset_create.sql';
Fixing the metadata
-------------------
- 1. isql database.fdb
- 2. SQL> input 'misc/upgrade/metadata_charset_create.sql';
- 3. SQL> select * from rdb$fix_metadata('WIN1252'); -- replace
WIN1252 by your charset
- 4. SQL> commit;
Point 2 as above.
Point 3 executes OK
Point 4 fails for me. I get error `attempt to update read only
column'.
~~~~~~~~~~~~~~~~~~~~~~~~~
Regards
Peter Gore