Skip site navigation (1) Skip section navigation (2)

Re: Support - Access Migration - autonumber field becomes INT4

From: "Dave Page" <dpage(at)vale-housing(dot)co(dot)uk>
To: <carlos(dot)leite(at)govonline(dot)com(dot)br>, <pgadmin-support(at)postgresql(dot)org>
Subject: Re: Support - Access Migration - autonumber field becomes INT4
Date: 2002-12-05 08:52:04
Message-ID: 03AF4E498C591348A42FC93DEA9661B8128D06@mail.vale-housing.co.uk (view raw or flat)
Thread:
Lists: pgadmin-support
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(dot)leite(at)govonline(dot)com(dot)br] 
> Sent: 05 December 2002 04:03
> To: pgadmin-support(at)postgresql(dot)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(dot)leite(at)govonline(dot)com(dot)br
> 
> 
> ---------------------------(end of 
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
> 
http://archives.postgresql.org

pgadmin-support by date

Next:From: MacropacDate: 2002-12-05 10:39:43
Subject: unsubscribe
Previous:From: Carlos LeiteDate: 2002-12-05 04:02:44
Subject: Support - Access Migration - autonumber field becomes INT4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group