Re: Problem migrating from 8.0.3 to 8.2.3

"Anton Pikhteryev" <apikhteryev@sandvine.com> writes:
> COPY clap_file_info (fileid, filename, created, "owner") FROM stdin;
> ERROR:  type "char" is not a domain
> CONTEXT:  COPY clap_file_info, line 1, column owner: "mfgtest"

You have removed the parts of the dump that show the creation of
this table.  Please try again.

> I am thinking that it has something to do with usesysid not being
> consistent for valid_user type from 8.0.3 to 8.2.3.

Highly unlikely.  The error message must be coming from domain_in,
but why is that getting invoked?  I want to see the declaration of
that table and any data types or constraints it's using.

            regards, tom lane