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@xxxxxxxxxxxxx]
> Sent: Friday, March 16, 2007 12:29 PM
> To: Anton Pikhteryev
> Cc: pgsql-admin@xxxxxxxxxxxxxx
> Subject: Re: [ADMIN] Problem migrating from 8.0.3 to 8.2.3
>
> "Anton Pikhteryev" <apikhteryev@xxxxxxxxxxxx> 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
>
