Date: Tue, 9 Feb 2010 11:07:52 +0100
From: Lutz Steinborn <l.steinborn@4c-ag.de>
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: migration problem 8.1.17 --> 8.4.2
Message-Id: <20100209110752.1b21538f.l.steinborn@4c-ag.de>
In-Reply-To: <201002091158.47353.achill@matrix.gatewaynet.com>
References: <20100209094831.22eece8c.l.steinborn@4c-ag.de>
	<201002091135.46170.achill@matrix.gatewaynet.com>
	<20100209105438.9c44eb73.l.steinborn@4c-ag.de>
	<201002091158.47353.achill@matrix.gatewaynet.com>
Organization: 4c AG
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

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