Re: Problem migrating from 8.0.3 to 8.2.3

There is that part and doesn't have any errors:

CREATE TABLE clap_file_info (
    fileid integer DEFAULT
nextval('public.clap_file_info_fileid_seq'::text) NOT NULL,
    filename text NOT NULL,
    created timestamp with time zone DEFAULT ('now'::text)::timestamp(6)
with time zone NOT NULL,
    "owner" valid_user NOT NULL
);
CREATE TABLE
ALTER TABLE public.clap_file_info OWNER TO labadmin;
...
CREATE TABLE event_occurrence (
    event_occurrence_id integer DEFAULT
nextval('public.event_occurrence_event_occurrence_id_seq'::text) NOT
NULL,
    event_id serial_ref NOT NULL,
    event_timestamp timestamp with time zone DEFAULT
('now'::text)::timestamp(6) with time zone NOT NULL,
    testrun_id serial_ref,
    user_id valid_user NOT NULL
);
CREATE TABLE
ALTER TABLE public.event_occurrence OWNER TO labadmin;
ALTER TABLE
CREATE SEQUENCE event_occurrence_event_occurrence_id_seq
    INCREMENT BY 1
    NO MAXVALUE
    NO MINVALUE
    CACHE 1;
CREATE SEQUENCE
ALTER TABLE public.event_occurrence_event_occurrence_id_seq OWNER TO
labadmin;
ALTER TABLE
ALTER SEQUENCE event_occurrence_event_occurrence_id_seq OWNED BY
event_occurrence.event_occurrence_id;
ALTER SEQUENCE

Absolutely no errors when it is created.

BTW:

labdb=# \dT valid_user
                List of data types
 Schema |    Name    |        Description
--------+------------+----------------------------
 public | valid_user | valid PostgreSQL user name
(1 row)

labdb=# \dT+ valid_user
                           List of data types
 Schema |    Name    | Internal name | Size |        Description
--------+------------+---------------+------+---------------------------
-
 public | valid_user | valid_user    | 64   | valid PostgreSQL user name
(1 row)

Did I miss anything?

Anton Pikhteryev
Network Administrator, Tools Group
Sandvine Incorporated
Phone: 519.880.2400 ext. 2923
http://www.sandvine.com



> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: Friday, March 16, 2007 12:29 PM
> To: Anton Pikhteryev
> Cc: pgsql-admin@postgresql.org
> Subject: Re: [ADMIN] 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
>