Support - Access Migration - autonumber field becomes INT4

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

Browse pgadmin-support by date

  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