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 ...
|
- Re: [pgadmin-support] PG Migration Wizard Mark Levene