Bug with very low negative sequence values

From: "Lucas Deters" <deters(at)cefetsc(dot)edu(dot)br>
To: pgadmin-support(at)postgresql(dot)org
Subject: Bug with very low negative sequence values
Date: 2008-01-10 13:44:38
Message-ID: 79c2e4500801100544j15aded42m3cd506ded2585849@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Dave Page 2008-01-10 18:35:49 Re: Bug with very low negative sequence values
Previous Message Dave Page 2008-01-10 10:21:54 Re: bug: the schema oid can't be located, please refresh all schemas