| Subject | Impossible to create a new database from a script |
|---|---|
| Author | Walter R. Ojeda Valiente |
| Post date | 2018-03-17T13:12:47Z |
Hello everybody
I am using Firebird 2.5.8 in Windows 7.
I have a script file which contains the lines for create a database and theirs domains, tables, triggers, and so on.
The problem is in the lines of comments.
CREATE DATABASE '127.0.0.1/3050:E:\SQL\SQL_MUAN\DATABASES\MUAN_MASTER_21.FDB'
USER 'SYSDBA'
PASSWORD 'masterkey'
PAGE_SIZE = 4096
DEFAULT CHARACTER SET ISO8859_1
COLLATION ES_ES;
SET AUTODDL ON;
-- More lines here
COMMENT ON COLUMN ADICIONALES.ADI_SERVID IS 'Servidor Nº';
-- More lines here
The database is created, no problem there. But on the line: COMMENT ON COLUMN the folowing error appears:
This operation is not defined for system tables.Unsuccessful metadata update.
MODIFY RDB$RELATION_FIELDS failed.
Malformed string.
Thinking that the problem would be the CHARACTER SET, I had changed it to WIN1252, ASCII, NONE, and the same error continues. It is impossible to create the database.
If I delete the lines which start with COMMENT ON COLUMN (there are a lot of them, because each column of each table has a comment) then the database can be created. But I don't want to delete the comments, it is a team's work and people needs to read those comments.
So, there is a solution?
Is this a bug of Firebird?
Somebody knows how to solve this problem?
Thanks in advance.
Walter.
