pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedmigration problem 8.1.17 --> 8.4.2
5+ messages / 2 participants
[nested] [flat]
* migration problem 8.1.17 --> 8.4.2
@ 2010-02-09 08:48 Lutz Steinborn <l.steinborn@4c-ag.de>
0 siblings, 1 reply; 5+ messages in thread
From: Lutz Steinborn @ 2010-02-09 08:48 UTC (permalink / raw)
To: pgsql-admin
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.
Any idea what the problem is ?
Kindly regards
Lutz
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: migration problem 8.1.17 --> 8.4.2
@ 2010-02-09 09:35 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Lutz Steinborn <l.steinborn@4c-ag.de>
0 siblings, 1 reply; 5+ messages in thread
From: Achilleas Mantzios @ 2010-02-09 09:35 UTC (permalink / raw)
To: pgsql-admin; +Cc: Lutz Steinborn <l.steinborn@4c-ag.de>
Óôéò 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?
>
> Any idea what the problem is ?
>
> Kindly regards
>
> Lutz
>
--
Achilleas Mantzios
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: migration problem 8.1.17 --> 8.4.2
@ 2010-02-09 09:54 Lutz Steinborn <l.steinborn@4c-ag.de>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 1 reply; 5+ messages in thread
From: Lutz Steinborn @ 2010-02-09 09:54 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin
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.
--
Lutz
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: migration problem 8.1.17 --> 8.4.2
@ 2010-02-09 09:58 Achilleas Mantzios <achill@matrix.gatewaynet.com>
parent: Lutz Steinborn <l.steinborn@4c-ag.de>
0 siblings, 1 reply; 5+ messages in thread
From: Achilleas Mantzios @ 2010-02-09 09:58 UTC (permalink / raw)
To: pgsql-admin; +Cc: Lutz Steinborn <l.steinborn@4c-ag.de>
Óôéò 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?
>
> --
> Lutz
>
--
Achilleas Mantzios
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: migration problem 8.1.17 --> 8.4.2
@ 2010-02-09 10:07 Lutz Steinborn <l.steinborn@4c-ag.de>
parent: Achilleas Mantzios <achill@matrix.gatewaynet.com>
0 siblings, 0 replies; 5+ messages in thread
From: Lutz Steinborn @ 2010-02-09 10:07 UTC (permalink / raw)
To: Achilleas Mantzios <achill@matrix.gatewaynet.com>; +Cc: pgsql-admin
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
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~2010-02-09 10:07 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-02-09 08:48 migration problem 8.1.17 --> 8.4.2 Lutz Steinborn <l.steinborn@4c-ag.de>
2010-02-09 09:35 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2010-02-09 09:54 ` Lutz Steinborn <l.steinborn@4c-ag.de>
2010-02-09 09:58 ` Achilleas Mantzios <achill@matrix.gatewaynet.com>
2010-02-09 10:07 ` Lutz Steinborn <l.steinborn@4c-ag.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox