Hi,

I prefer to replicate my POSGREsql Database by applying these commands,

pg_dump mydatabase > somefile

I sucessfully dumped without any errors.

But when I tried to rebuild the same database using

psql -d mydatabase < somefile

ERROR: foreign key constraint "sys_report_id_fk" cannot be implemented
DETAIL: Key columns "report_id" and "report_id" are of incompatible types: integer and character varying.

Note : the existing database is working smoothly but I cant replicate it

pls throw some Light !