Обсуждение: Support - Access Migration - autonumber field becomes INT4

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.leite@govonline.com.br

Hi,

I've updated this to int8. The max value is the default from PostgreSQL btw...

There is an updated DLL on cvs.pgadmin.org in the binaries directory if you wish to give it a shot.

Regards, Dave.

> -----Original Message-----
> From: Carlos Leite [mailto:carlos.leite@govonline.com.br]
> Sent: 05 December 2002 04:03
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] Support - Access Migration -
> autonumber field becomes INT4
>
>
> 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.leite@govonline.com.br
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
http://archives.postgresql.org