Bug with very low negative sequence values

["Lucas Deters" <deters(at)cefetsc(dot)edu(dot)br>]

Hello,

A bug report:

Platform: Ubuntu 7.10, Pentium M
Language: English Version
Distribution: Ubuntu .deb (apt-get)
Version: 1.4.3

I'm trying to create a sequence like this:

CREATE SEQUENCE seqlingua
  INCREMENT 1
  MINVALUE -2147483648
  MAXVALUE 2147483647
  START -2147483648
  CACHE 1;

But PGAdmin show this DDL in the interface:

CREATE SEQUENCE seqlingua
  INCREMENT 1
  MINVALUE 18446744071562067968
  MAXVALUE 2147483647
  START 18446744071562067968
  CACHE 1;
ALTER TABLE seqlingua OWNER TO postgres;

The backup script also contain problems.

The return value from select nextval('seqlingua') is correct (-2147483648).

Thank you, sorry my bad english

Lucas Augusto Deters


-- 
Lucas Augusto Deters
Coordenador de Sistemas (CEFET/SC)
deters(at)cefetsc(dot)edu(dot)br
(48) 3221-0519