-----Original Message----- From: Dave Page [mailto:[EMAIL PROTECTED]] Sent: Sunday, December 22, 2002 2:31 PM To: Reshat Sabiq; [EMAIL PROTECTED] Subject: RE: [pgadmin-support] Access-postgreSQL migration (extra invalid foreign key added)
------- It's certainly possible. The Migration Wizard is a bit hit 'n' miss to be honest as I wrote it without ever migrating a database except for the odd test using Northwind/Biblio. Is it possible to get a schema only copy of your mdb file to look at please? ------- Sure. How should I get that schema? I have the postgreSQL statements in pgAdmin, but I don't know how to obtain the same from Access. --------- We do sort of assume there are no \n's or \r's in your object names... --------- That is correct; I do not have new lines in object names. In fact, I shouldn't have any in that database. But I was thinking it might be there behind the scenes. But it is strange that only 1 out of 10 foreign keys get the invalid duplicate statement. P.S. Thanks for the great tool. Things like that can get done with time. Sincerely, r. ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]