CMDBuild Forum

Conversione db 0.9 a 1.0

Old Versions
#1

Salve,

 

vista la ormai uscita dal supporto della 0.90 avrei l'esigenza di poter convertire il db di una installazione 0.90 in 1.0x.

 

l'attivazione dello script fallisce con errori, il log dell'esecuzione è il seguente:

 

psql -U postgres -d cmdb10 -f "CMDBuild-1.0R3\update0.90_to_1.0R1.sql"


CREATE SCHEMA
COMMENT
ALTER TABLE
ALTER TABLE
UPDATE 65
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
ALTER TABLE
psql:update0.90_to_1.0R1.sql:50: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "Loo
kUp_pkey" for table "LookUp"
CREATE TABLE
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
COMMENT
INSERT 0 603
ALTER TABLE
 deletetriggers
----------------
 t
(1 riga)

psql:update0.90_to_1.0R1.sql:76: WARNING:  nonstandard use of \' in a string literal LINE 1: SELECT  'select pg_attribute.attnum as AttributeDBIndex, pg_...
                ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...
').
QUERY:  SELECT  'select pg_attribute.attnum as AttributeDBIndex, pg_attribute.at
tname as AttributeName
                from "pg_class", "pg_attribute"
                where pg_class.relname = \'' ||  $1  || '\' and pg_attribute.att
relid = pg_class.oid and pg_attribute.attnum > 0 AND pg_attribute.atttypid > 0 a
nd pg_table_is_visible(pg_class.oid);'
CONTEXT:  PL/pgSQL function "createtriggers" line 17 at OPEN
psql:update0.90_to_1
.0R1.sql:76: WARNING:  nonstandard use of \' in a string literal
LINE 3:   where pg_class.relname = \'' ||  $1  || '\' and pg_attribu...
                                                  ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...
').
QUERY:  SELECT  'select pg_attribute.attnum as AttributeDBIndex, pg_attribute.at
tname as AttributeName
                from "pg_class", "pg_attribute"
                where pg_class.relname = \'' ||  $1  || '\' and pg_attribute.att
relid = pg_class.oid and pg_attribute.attnum > 0 AND pg_attribute.atttypid > 0 a
nd pg_table_is_visible(pg_class.oid);'
CONTEXT:  PL/pgSQL function "createtriggers" line 17 at OPEN
psql:update0.90_to_1
.0R1.sql:76: WARNING:  nonstandard use of \' in a string literal
LINE 1: SELECT   $1  || '\'\'U\'\', '
                        ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...
').
QUERY:  SELECT   $1  || '\'\'U\'\', '
CONTEXT:  PL/pgSQL function "createtriggers" line 27 at assignment
psql:update0.90_to_1
.0R1.sql:76: WARNING:  nonstandard use of \' in a string literal
LINE 2:   CREATE FUNCTION after_archive_row_'|| $1 ||'() RETURNS TRI...
                                                     ^
HINT:  Use '' to write quotes in strings, or use the escape string syntax (E'...
').
QUERY:  SELECT '
                CREATE FUNCTION after_archive_row_'|| $1 ||'() RETURNS TRIGGER A
S ''
                DECLARE
                myrecord record;
                BEGIN
                myrecord = OLD;
                myrecord."Status" = \'\'U\'\';
                IF(TG_OP=''''UPDATE'''') THEN
                        NEW."BeginDate" = now();
                END IF;
                SELECT INTO myrecord."Id" '|| $2 ||';
                --INSERT INTO "'|| $1 ||'_history" VALUES (myrecord.*, OLD."Id",
 now());
                '|| $3 ||'

                RETURN NEW;
                END;
                '' LANGUAGE ''plpgsql'';
                '
CONTEXT:  PL/pgSQL function "createtriggers" line 61 at EXECUTE statement
 createtriggers
----------------
 t
(1 riga)

UPDATE 23
UPDATE 56
UPDATE 8
UPDATE 3
UPDATE 0
UPDATE 2
UPDATE 2
UPDATE 3
UPDATE 3
UPDATE 0
UPDATE 0
UPDATE 0
UPDATE 0
DROP TABLE
DROP TRIGGER
psql:update0.90_to_1
.0R1.sql:103: ERROR:  relation "system_classcatalog" does not exist
DELETE 75
CREATE FUNCTION
psql:update0.90_to_1
.0R1.sql:143: ERROR:  relation "system_classcatalog" does not exist
CONTEXT:  SQL statement "select classid from system_classcatalog where classname
='LookUp'"
PL/pgSQL function "updateflowlookups" line 7 at SQL statement
DROP FUNCTION
ALTER TABLE
psql:update0.90_to_1
.0R1.sql:148: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
"Map_UserRole_pkey" for table "Map_UserRole"
ALTER TABLE
ALTER TABLE
psql:update0.90_to_1
.0R1.sql:152: NOTICE:  ALTER TABLE / ADD PRIMARY KEY will create implicit index
"Map_UserRole_history_pkey" for table "Map_UserRole_history"
ALTER TABLE
CREATE FUNCTION
CREATE TRIGGER
CREATE TRIGGER
DROP VIEW
DROP VIEW
DROP VIEW
DROP VIEW
DROP VIEW
DROP VIEW
DROP VIEW
DROP VIEW
DROP VIEW
DROP VIEW
DROP VIEW
DROP VIEW
DROP FUNCTION
DROP FUNCTION
psql:update0.90_to_1
.0R1.sql:192: NOTICE:  function createasset(pg_catalog.varchar,pg_catalog.varcha
r,pg_catalog.int4,pg_catalog.varchar,pg_catalog.varchar,pg_catalog.bool,pg_catal
og.varchar) does not exist, skipping
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
psql:update0.90_to_1
.0R1.sql:210: NOTICE:  function getreference(pg_catalog.varchar,pg_catalog.bool)
 does not exist, skipping
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
psql:update0.90_to_1
.0R1.sql:259: NOTICE:  function sortlookup() does not exist, skipping
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
DROP FUNCTION
psql:update0.90_to_1
.0R1.sql:268: ERROR:  function system_disablealltriggers() does not exist
LINE 1: select system_disablealltriggers();
               ^
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts.
psql:update0.90_to_1
.0R1.sql:269: ERROR:  function system_regeneratereferencetriggers() does not exi
st
LINE 1: select system_regeneratereferencetriggers();
               ^
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts.
psql:update0.90_to_1
.0R1.sql:270: ERROR:  function system_disablealltriggers() does not exist
LINE 1: select system_disablealltriggers();
               ^
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts.
psql:update0.90_to_1
.0R1.sql:271: ERROR:  function system_updateallaftertriggers() does not exist
LINE 1: select system_updateallaftertriggers();
               ^
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts.
psql:update0.90_to_1
.0R1.sql:272: ERROR:  function system_disablealltriggers() does not exist
LINE 1: select system_disablealltriggers();
               ^
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts.
psql:update0.90_to_1
.0R1.sql:273: ERROR:  function system_updateregclasses() does not exist
LINE 1: select system_updateregclasses();
               ^
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts.
psql:update0.90_to_1
.0R1.sql:274: ERROR:  function system_enablealltriggers() does not exist
LINE 1: select system_enablealltriggers();
               ^
HINT:  No function matches the given name and argument types. You might need to
add explicit type casts.
UPDATE 118
DELETE 0

avete indicazioni che possano risolvere il problema?

 

Grazie