Skip site navigation (1) Skip section navigation (2)

Re: Data Migration Wizard & FoxPro memo question

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: pgadmin-support(at)postgresql(dot)org,Paul Haddon <paullist(at)mail(dot)hartingdale(dot)com(dot)au>,Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Subject: Re: Data Migration Wizard & FoxPro memo question
Date: 2002-03-08 07:51:28
Message-ID: MXQsgtfkqf5h.ks9fFJHH@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
Hi Paul,

No, this is not normal - text fields should work fine. Do you have a sample (or can you create one) of your database that you can send me for testing?

Regards, Dave

_____________Original message ____________
Subject:	[pgadmin-support] Data Migration Wizard & FoxPro memo question
Sender:	Paul Haddon <paullist(at)mail(dot)hartingdale(dot)com(dot)au>
Date:		Fri,  8 Mar 2002 07:46:32 +0000

I'm trying to convert some Visual FoxPro databases across 
to Postgresql. I came across pgAdmin II and it's working
well except for the memo fields.

When I migrate a FoxPro file the structure is created 
correctly, with the memo field being set up as a text
field; but no data is subsequently inserted into 
Postgresql. Looking at the logs shows '' as the data
to insert into the text(memo) field.

Is this a known problem, a settings issue on my part 
or a version issue (pgAdmin, odbc, Posgres etc)?

Thanks

Paul Haddon
Technical Services Manager
Hartingdale Internet


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org



pgadmin-support by date

Next:From: Tim Finch, FosterFinch LtdDate: 2002-03-08 11:04:02
Subject: Re: Can not connect with PG Admin after
Previous:From: Paul HaddonDate: 2002-03-08 00:13:24
Subject: Data Migration Wizard & FoxPro memo question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group