Hi Mark,

The easiest fix is simply to edit the sequence name, or the column's
default value using pgAdmin. Both should take a few seconds. I will take
a look at the bug though - thanks.

Regards, Dave.

> -----Original Message-----
> From: Mark Levene [mailto:[EMAIL PROTECTED] 
> Sent: 28 March 2003 03:30
> To: [EMAIL PROTECTED]
> Subject: [pgadmin-support] Migration Wizard problem
> 
> 
> 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 ...
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
> 


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to