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