On Tue, 9 Feb 2010 11:58:46 +0200
Achilleas Mantzios <achill [at] matrix.gatewaynet.com> wrote:
> =CE=A3=CF=84=CE=B9=CF=82 Tuesday 09 February 2010 11:54:38 =CE=BF/=CE=B7=
Lutz Steinborn =CE=AD=CE=B3=CF=81=CE=B1=CF=88=CE=B5:
> > On Tue, 9 Feb 2010 11:35:45 +0200
> > Achilleas Mantzios <achill [at] matrix.gatewaynet.com> wrote:
> >
> > > =CE=9E=C2=A3=CE=9F=C2=84=CE=9E=CE=89=CE=9F=C2=82 Tuesday 09 Februar=
y 2010 10:48:31 =CE=9E=CE=8F/=CE=9E=C2=B7 Lutz Steinborn =CE=9E=C2=AD=CE=9E=
=C2=B3=CE=9F=C2=81=CE=9E=C2=B1=CE=9F=C2=88=CE=9E=CE=85:
> > > > Hi,
> > > >
> > > > then importing an pg_dump result from a 8.1.17 to a 8.4.2 some va=
rchar fields
> > > > are not imported and left blank. I've checked the dump file if th=
e 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 reproduc=
e 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=C3=A4zisions-Feinfilterregler|800 l/min* Anwendung: Pr=C3=A4zisions-F=
einfilterregler
werden eingesetzt, um einen genauen Druck - unabh=C3=A4ngig von Vordruck =
und
Durchflussleistung - einzustellen. Sie werden z.B. f=C3=BCr Steuer- und R=
egelanlagen
in der Verfahrenstechnik eingesetzt, wo hohe Anforderungen \N category
D749284932A9462585B9404F7EEEF9CE
Example after import in the db:
select * from cm_category where id=3D894367;
id | modified_by | language | active | position |
created_at | modified_at | created_by |
catalog_name | level | name
| =
description =
=
| thumbnail | content_type | o=
riginal_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
--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
