From: | "Carlos Leite" <carlos(dot)leite(at)govonline(dot)com(dot)br> |
---|---|
To: | <pgadmin-support(at)postgresql(dot)org> |
Subject: | Support - Access Migration - autonumber field becomes INT4 |
Date: | 2002-12-05 04:02:44 |
Message-ID: | BMEJLHBPMCBIPICLGEMAOEPKCDAA.carlos.leite@govonline.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
I´m trying to migrate an access Database using Database Migration Wizard.
The wizard define the sequences like that
-- Sequence: agente_visita_id_agentevisita_k
CREATE SEQUENCE agente_visita_id_agentevisita_k INCREMENT 1 MINVALUE 1
MAXVALUE 9223372036854775807 CACHE 1;
SELECT setval('agente_visita_id_agentevisita_k', 172);
But the field that will USE that sequence is defined as INT4,
shouldn´t it be INT8 ??
-- Table: agente_visita
CREATE TABLE agente_visita (
id_agentevisita int4 DEFAULT
nextval('"agente_visita_id_agentevisita_key"'::text),
id_visita int8,
id_local int8,
id_equipa int8,
id_agente int8
) WITH OIDS;
I´ll have a big problem, because as we know, I cant change a column type
without DROP IT.
May you help me please...
Thanks in Advance
Carlos Leite
GovOnline
tel: 55+11+31656113
e-mail: carlos(dot)leite(at)govonline(dot)com(dot)br
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2002-12-05 08:52:04 | Re: Support - Access Migration - autonumber field becomes INT4 |
Previous Message | Dave Page | 2002-12-04 17:05:36 | Re: Help request |