Postgres Pro
Downloads
Home   >   mailing lists

PG Migration Wizard - Mailing list pgadmin-support

From Mark Levene
Subject PG Migration Wizard
Date
Msg-id 012901c2f73b$cc406aa0$0201a8c0@markdell
Whole thread Raw
List pgadmin-support
Tree view
Hi
 
The "Default" values don't seem to come across from an Access database using the PG Migration Wizard, (except for the "autonumber fields").
 
For example, using the Migration Wizard to bring the tables across, I get
 
---snip---
   "StartRange" integer,
   "EndRange" integer,
   "StartDate" date,
   "EndDate" date,
---snip---
 
whereas, I wanted
 
---snip---
   "StartRange" integer DEFAULT 0,
   "EndRange" integer DEFAULT 0,
   "StartDate" date DEFAULT now(),
   "EndDate" date DEFAULT '2299-12-31'::date,
---snip---
 
Now, I could go and check each table, however it would be great if they came across.
 
Thanks for a wonderful product (which I will continue to say until hell freezes over!)
 
 
Thanks,
Mark ...

pgadmin-support by date:

Previous
From: "Dave Page"
Date:
Subject: Re: PgMigration error when migrating Dbase tables
Next
From: "Dave Page"
Date:
Subject: Re: PG Migration Wizard