Re: migration problem 8.1.17 --> 8.4.2

On Tue, 9 Feb 2010 11:58:46 +0200
Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com> wrote:

> Στις Tuesday 09 February 2010 11:54:38 ο/η Lutz Steinborn έγραψε:
> > On Tue, 9 Feb 2010 11:35:45 +0200
> > Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)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