X-Original-To: pgadmin-support-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id C4234D1B4EA for ; Sat, 10 Jan 2004 05:06:00 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 57434-08 for ; Sat, 10 Jan 2004 01:05:30 -0400 (AST) Received: from virtrail.com (elelab17.ee.nus.edu.sg [137.132.165.136]) by svr1.postgresql.org (Postfix) with ESMTP id 10650D1B457 for ; Sat, 10 Jan 2004 01:05:29 -0400 (AST) Received: from Spooler by virtrail.com (Mercury/32 v3.32) ID MO00003C; 10 Jan 04 13:08:19 +0800 Received: from spooler by virtrail.com (Mercury/32 v3.32); 10 Jan 04 13:08:05 +0800 Received: from virtrail.com (137.132.165.55) by virtrail.com (Mercury/32 v3.32) with ESMTP ID MG00003B; 10 Jan 04 13:07:55 +0800 Message-ID: <3FFF8801.5040505@virtrail.com> Date: Sat, 10 Jan 2004 13:05:05 +0800 From: gary User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.4) Gecko/20030624 Netscape/7.1 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgadmin-support@postgresql.org Subject: bug? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/22 X-Sequence-Number: 2701 hi, i have succesfully migrated the MSSQL database to postgresql using the database migration wizard of pgadmin. is there a way to disable the naming modification during the migration process. .for example, all the foreign key is append with the string '_fk' . And one thing i notice is that if my MSSQL index name contain the string 'name' eg IX_UC_Community_name, migration will rename it to IX_UC_Community_-0 great software though! thanks gary