Skip site navigation (1) Skip section navigation (2)

Re: Problem migrating from 8.0.3 to 8.2.3

From: "Anton Pikhteryev" <apikhteryev(at)sandvine(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Problem migrating from 8.0.3 to 8.2.3
Date: 2007-03-16 17:36:13
Message-ID: F489AB573A749146B33461ECE080913A0108BEF5@EXCHANGE-1.sandvine.com (view raw or flat)
Thread:
Lists: pgsql-admin
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(at)sss(dot)pgh(dot)pa(dot)us] 
> Sent: Friday, March 16, 2007 12:29 PM
> To: Anton Pikhteryev
> Cc: pgsql-admin(at)postgresql(dot)org
> Subject: Re: [ADMIN] Problem migrating from 8.0.3 to 8.2.3 
> 
> "Anton Pikhteryev" <apikhteryev(at)sandvine(dot)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
> 

In response to

Responses

pgsql-admin by date

Next:From: Tom LaneDate: 2007-03-16 19:34:14
Subject: Re: Problem migrating from 8.0.3 to 8.2.3
Previous:From: Chris BrowneDate: 2007-03-16 17:10:27
Subject: Re: Slony sync times

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group