Re: Data Migration Wizard & FoxPro memo question

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