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: [EMAIL PROTECTED]


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Reply via email to