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
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 |