Migration Wizard problem - Mailing list pgadmin-support

Hi

I have a problem with a database brought in from an MS Access database
through the "Database Migration Wizard".

I have a table ("tblPurchaseOrderDetails") which has a field
("PurchaseOrderDetailID"). In Access this is an "Autonumber" field.

The "default" value generated for "PurchaseOrderDetailID" by the
Migration Wizard is:

nextval('"tblPurchaseOrderDetails_PurchaseOrderDetailID_key"'::text)

However, the "Sequence Object" created by the Migration Wizard is:

"tblPurchaseOrderDetails_Purchas"

so when the "nextval" is looked up, it can't find the "Sequence".

Can the Migration Wizard be changed to "chop" the "Default" object for a
column to 31 characters to match the "Sequence"?

A work around is to pg_dump the database, then edit the file, then bring
it back in with psql (a lot of work)

I hope that this makes sense!

Herewith the dump from pg_dump
--------------------------------------------------
--
-- TOC Entry ID 54 (OID 34903)
--
-- Name: tblPurchaseOrderHeader_Purchase Type: SEQUENCE Owner: xxxx
--

CREATE SEQUENCE "tblPurchaseOrderHeader_Purchase" start 3 increment 1
maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 102 (OID 34922)
--
-- Name: tblPurchaseOrderHeader Type: TABLE Owner: xxxx
--

CREATE TABLE "tblPurchaseOrderHeader" (
    "PurchaseOrderID" bigint DEFAULT
nextval('"tblPurchaseOrderHeader_PurchaseOrderID_key"'::text) NOT NULL,
    "CompanyID" integer,
    "CountryID" integer,
    "SupplierID" integer,
    "EmployeeID" integer,
    "OrderDate" date,
    "PurchaseOrderNumber" character varying(30),
    "RequiredByDate" date,
    "PromisedByDate" date,
    "ShipName" character varying(50),
    "ShipAddress" character varying(255),
    "ShipCity" character varying(50),
    "ShipState" character varying(50),
    "ShipStateOrProvince" character varying(50),
    "ShipPostalCode" character varying(20),
    "ShipCountryID" integer,
    "ShipPhoneNumber" character varying(30),
    "ShipDate" date,
    "ShippingMethodID" integer,
    "FreightCharge" money,
    "SalesTaxRate" double precision,
    Constraint "tblPurchaseOrderHeader_pkey" Primary Key
("PurchaseOrderID")
);
--------------------------------------------------

Thanks,
Regards,
Mark ...