PG Migration Wizard

From: "Mark Levene" <Mark(at)UnderGlass(dot)co(dot)nz>
To: <pgadmin-support(at)postgresql(dot)org>
Subject: PG Migration Wizard
Date: 2003-03-31 04:12:40
Message-ID: 012901c2f73b$cc406aa0$0201a8c0@markdell
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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 ...

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2003-03-31 19:03:17 Re: PG Migration Wizard
Previous Message Dave Page 2003-03-28 21:42:12 Re: PgMigration error when migrating Dbase tables