Re: migration problem 8.1.17 --> 8.4.2

On Tue, 9 Feb 2010 11:58:46 +0200
Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:

> Στις Tuesday 09 February 2010 11:54:38 ο/η Lutz Steinborn έγραψε:
> > On Tue, 9 Feb 2010 11:35:45 +0200
> > Achilleas Mantzios <achill@matrix.gatewaynet.com> wrote:
> >
> > > Στις Tuesday 09 February 2010 10:48:31 ΞΏ/Ξ· Lutz Steinborn έγραψΡ:
> > > > Hi,
> > > >
> > > > then importing an pg_dump result from a 8.1.17 to a 8.4.2 some varchar fields
> > > > are not imported and left blank. I've checked the dump file if the fields are
> > > > correct dumped and they are.
> > > > So it looks like the import is not working as expected.
> > >
> > > Are you getting any messages during dump/restore?
> > No and dumping/importing only on table give me the same problem.
>
> Could you post the table schema and some sample data which can reproduce the problem?
>

\d cm_category
                                       Table "public.cm_category"
     Column     |            Type             |
Modifiers
----------------+-----------------------------+----------------------------------------------------------
 id             | integer                     | not null default nextval
('cm_category_id_seq'::regclass) modified_by    | character varying(200)      |
 language       | character varying(10)       |
 active         | boolean                     |
 position       | integer                     |
 created_at     | timestamp without time zone |
 modified_at    | timestamp without time zone |
 created_by     | character varying(200)      |
 catalog_name   | character varying(500)      |
 level          | integer                     |
 name           | character varying(500)      |
 description    | text                        |
 thumbnail      | character varying(1000)     |
 content_type   | character varying(50)       |
 original_id    | character varying(100)      |
 system_name    | character varying(100)      |
 system_version | character varying(50)       |
Indexes:
    "cm_category_pkey" PRIMARY KEY, btree (id) CLUSTER
    "idx_cm_category_active" btree (active)
    "idx_cm_category_catalog_name" btree (catalog_name)
    "idx_cm_category_content_type" btree (content_type)
    "idx_cm_category_language" btree ("language")
    "idx_cm_category_level" btree ("level")
    "idx_cm_category_original_id" btree (original_id)
    "idx_cm_category_system_name" btree (system_name)
    "idx_cm_category_system_version" btree (system_version)



Example from table dump:

894367  anonym  DE  t   0   2009-11-15 08:45:56.413266  2009-11-15
08:45:56.413266  anonym  pPool-5556070003-6556071008 1
Präzisions-Feinfilterregler|800 l/min*  Anwendung: Präzisions-Feinfilterregler
werden eingesetzt, um einen genauen Druck - unabhängig von Vordruck und
Durchflussleistung - einzustellen. Sie werden z.B. für Steuer- und Regelanlagen
in der Verfahrenstechnik eingesetzt, wo hohe Anforderungen   \N  category
D749284932A9462585B9404F7EEEF9CE


Example after import in the db:

select * from cm_category where id=894367;
   id   | modified_by | language | active | position |
created_at         |        modified_at         | created_by |
catalog_name         | level |                  name
|
description
          | thumbnail | content_type |           original_id            | system_name | system_version  

--------+-------------+----------+--------+----------+----------------------------+----------------------------+------------+-----------------------------+-------+----------------------------------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+--------------+----------------------------------+-------------+----------------
 894367 | anonym      | DE       | t      |        0 | 2009-11-15
08:45:56.413266 | 2009-11-15 08:45:56.413266 | anonym     |
pPool-5556070003-6556071008 |     1 |  |  |           | category     |
D749284932A9462585B9404F7EEEF9CE |             |


May be the \N in the description confusing the import ?



--
Lutz