Problem restoring chado schema

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Problem restoring chado schema

Antonio Nhani Jr
Hi,
I've just restored chado (Pg) database with the main backup (empty  
database) and the following erros occured:

=========
ERROR:  function create_point(integer, integer) does not exist
LINE 1: SELECT box (create_point(0, $1), create_point($2,500000000))
                     ^
HINT:  No function matches the given name and argument types. You  
might need to add explicit type casts.
QUERY:  SELECT box (create_point(0, $1), create_point($2,500000000))
CONTEXT:  SQL function "boxrange" during inlining
SQL statement "SELECT fk."group_id" FROM ONLY "frange"."featuregroup"  
fk LEFT OUTER JOIN ONLY "public"."feature" pk ON ( pk."feature_id"  
OPERATOR(pg_catalog.=) fk."group_id") WHERE pk."feature_id" IS NULL  
AND (fk."group_id" IS NOT NULL)"
ERROR:  function create_point(integer, integer) does not exist
LINE 1: SELECT box (create_point(0, $1), create_point($2,500000000))
                     ^
HINT:  No function matches the given name and argument types. You  
might need to add explicit type casts.
QUERY:  SELECT box (create_point(0, $1), create_point($2,500000000))
CONTEXT:  SQL function "boxrange" during inlining
SQL statement "SELECT fk."object_id" FROM ONLY "frange"."featuregroup"  
fk LEFT OUTER JOIN ONLY "public"."feature" pk ON ( pk."feature_id"  
OPERATOR(pg_catalog.=) fk."object_id") WHERE pk."feature_id" IS NULL  
AND (fk."object_id" IS NOT NULL)"
ERROR:  function create_point(integer, integer) does not exist
LINE 1: SELECT box (create_point(0, $1), create_point($2,500000000))
                     ^
HINT:  No function matches the given name and argument types. You  
might need to add explicit type casts.
QUERY:  SELECT box (create_point(0, $1), create_point($2,500000000))
CONTEXT:  SQL function "boxrange" during inlining
SQL statement "SELECT fk."srcfeature_id" FROM ONLY  
"frange"."featuregroup" fk LEFT OUTER JOIN ONLY "public"."feature" pk  
ON ( pk."feature_id" OPERATOR(pg_catalog.=) fk."srcfeature_id") WHERE  
pk."feature_id" IS NULL AND (fk."srcfeature_id" IS NOT NULL)"
ERROR:  function create_point(integer, integer) does not exist
LINE 1: SELECT box (create_point(0, $1), create_point($2,500000000))
                     ^
HINT:  No function matches the given name and argument types. You  
might need to add explicit type casts.
QUERY:  SELECT box (create_point(0, $1), create_point($2,500000000))
CONTEXT:  SQL function "boxrange" during inlining
SQL statement "SELECT fk."subject_id" FROM ONLY  
"frange"."featuregroup" fk LEFT OUTER JOIN ONLY "public"."feature" pk  
ON ( pk."feature_id" OPERATOR(pg_catalog.=) fk."subject_id") WHERE  
pk."feature_id" IS NULL AND (fk."subject_id" IS NOT NULL)"

=========

Are they due to empty database?

Regards,

Antonio


Antonio Nhani Jr
Núcleo de Melhoramento e Biotecnologia
54 3316 5833 / 5829
Embrapa Trigo - Rod. BR 285 Km 294
99001-970 Passo Fundo/RS



------------------------------
Aviso de confidencialidade:

- Esta mensagem da Empresa Brasileira de Pesquisa Agropecuária (Embrapa), empresa pública federal regida pelo disposto na Lei Federal nº 5.851, de 7 de dezembro de 1972, é enviada exclusivamente a seu destinatário e pode conter informações confidenciais, protegidas por sigilo profissional. Sua utilização desautorizada é ilegal e sujeita o infrator às penas da lei. Se você a recebeu indevidamente, queira, por gentileza, reenviá-la ao emitente, esclarecendo o equívoco.

Confidentiality note:

- "This message from Empresa Brasileira de Pesquisa Agropecuária (Embrapa), a government company established under Brazilian law (5.851/72), is directed exclusively to its addressee and may contain confidential data, protected under professional secrecy rules. Its unauthorized use is illegal and may subject the transgressor to the law's penalties. If you are not the addressee, please send it back, elucidating the failure".