Re: Miigration Wizard ignores not nulls & defau

The wizard doesn't support binary data at all. Whilst it can be useful,
bear in mind that this code was ripped out of pgAdmin I about 35 years
ago, and hasn't been touched much since :-(

Regards, Dave.

-----Original Message-----
From: Corneliu GALEV [mailto:Corneliu(dot)Galev(at)cefin(dot)com]
Sent: 20 May 2003 07:16
To: Roger Gordon
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Miigration Wizard ignores not
nulls & defau


I also noticed that varbinary fields are not migrated properly.
I maped varbinary to bytea and fileds values are not migrated at all
(I'm migrating from MSSQL7)

-----Original Message-----
From: Roger Gordon [mailto:Roger(at)emojo(dot)com]
Sent: Monday, 19 May 2003 12:46
To: pgadmin-support(at)postgresql(dot)org
Subject: [pgadmin-support] Miigration Wizard ignores not
nulls & default values

Hi,

Noticed 2 problems migrating from SQLServer 2000 using
pgAdmin 1.4.12:

1. NOT NULLs other than the primary key code
migrate over as NULLs
2. Default values are not migrated

I'm writing a script to fix these errors, but any advice
would be most appreciated....

Thanks,

Roger