I'm having trouble migrating DB from postgreSQL 7.4 to 7.4.7:
During restore I'm geting all kind of errors like :
********************************************************************
ERROR: column "txt_name" has a type conflict
DETAIL: character varying versus pg_catalog.varchar
********************************************************************
(txt_name is inherited field)
********************************************************************
ERROR: relation "doc_inventory" does not exist
ERROR: column "txt_name" has a type conflict
DETAIL: character varying versus pg_catalog.varchar
********************************************************************
(txt_name is inherited field)
********************************************************************
ERROR: relation "doc_inventory" does not exist
ERROR: column "f_has_doc" is of type boolean but _expression_ is of type
integer
HINT: You will need to rewrite or cast the _expression_.
HINT: You will need to rewrite or cast the _expression_.
ERROR: column "dat_pay_term_in" is of type timestamp without time zone
but _expression_ is of type integer
HINT: You will need to rewrite or cast the _expression_.
HINT: You will need to rewrite or cast the _expression_.
********************************************************************
I've also tryed to move DB from 7.4 (linux) to 7.4 (cygwin) but same errors acured.
I've also tryed to move DB from 7.4 (linux) to 7.4 (cygwin) but same errors acured.
Is there some bug in 7.4 or pg_dumpall i should know about ?
Any idea?
Boris