Received: from maia.hub.org (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id D361F632E12
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  9 Feb 2010 05:54:26 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia,
	port 10024) with ESMTP id 19057-04 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Tue,  9 Feb 2010 09:54:11 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mo-p00-ob.rzone.de (mo-p00-ob.rzone.de [81.169.146.161])
	by mail.postgresql.org (Postfix) with ESMTP id DF66B633307
	for <pgsql-admin@postgresql.org>; Tue,  9 Feb 2010 05:53:11 -0400 (AST)
DKIM-Signature: v=1; a=rsa-sha1; c=relaxed/relaxed; t=1265709190; l=585;
	s=domk; d=4c-ag.de;
	h=Content-Transfer-Encoding:Content-Type:Mime-Version:References:
	In-Reply-To:Subject:Cc:To:From:Date:X-RZG-CLASS-ID:X-RZG-AUTH;
	bh=xBN9F//z5U/jRSRqDuGHjaRrAKU=;
	b=aNmHgNLmwjhEbL7GeV5nrjXU+QCBLybT9JgNDVA/zYnMj0WFKMUsdQwPX51C852fhPe
	+kFhs7UpqhTgvlEb7wkL9C5xwNzX1HJ12vD85it9MFU9lNMnAbFGy4LsHOCHXC+FSLuHL
	MDNPb01XSCx2LXqHY0lS8ebvV+3WNTM3Lvg=
X-RZG-AUTH: :ICIXYUWhdf07X6m/b2XtAlrlJW5vzQNIp+WDp5lRVhY+t6aUn/IJXTddHpcPM4uN
X-RZG-CLASS-ID: mo00
Received: from localhost (p54AAAE02.dip.t-dialin.net [84.170.174.2])
	by post.strato.de (klopstock mo58) (RZmta 22.6)
	with ESMTP id p02e6dm199IEeA ; Tue, 9 Feb 2010 10:53:03 +0100 (MET)
Date: Tue, 9 Feb 2010 10:54:38 +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: <20100209105438.9c44eb73.l.steinborn@4c-ag.de>
In-Reply-To: <201002091135.46170.achill@matrix.gatewaynet.com>
References: <20100209094831.22eece8c.l.steinborn@4c-ag.de>
	<201002091135.46170.achill@matrix.gatewaynet.com>
Organization: 4c AG
X-Mailer: Sylpheed 2.6.0 (GTK+ 2.16.6; x86_64-pc-linux-gnu)
Mime-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.855 tagged_above=-10 required=5 tests=AWL=0.745,
	BAYES_00=-2.599
X-Spam-Level: 
X-Archive-Number: 201002/68
X-Sequence-Number: 33671

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