Bug with very low negative sequence values
От | Lucas Deters |
---|---|
Тема | Bug with very low negative sequence values |
Дата | |
Msg-id | 79c2e4500801100544j15aded42m3cd506ded2585849@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Bug with very low negative sequence values
|
Список | pgadmin-support |
Hello,<br /><br />A bug report:<br /><br />Platform: Ubuntu 7.10, Pentium M<br />Language: English Version<br />Distribution:Ubuntu .deb (apt-get)<br />Version: 1.4.3<br /><br />I'm trying to create a sequence like this:<br /><br />CREATESEQUENCE seqlingua <br /> INCREMENT 1<br /> MINVALUE -2147483648<br /> MAXVALUE 2147483647<br /> START -2147483648<br/> CACHE 1;<br /><br />But PGAdmin show this DDL in the interface:<br /><br />CREATE SEQUENCE seqlingua<br/> INCREMENT 1<br /> MINVALUE 18446744071562067968 <br /> MAXVALUE 2147483647<br /> START 18446744071562067968<br/> CACHE 1;<br />ALTER TABLE seqlingua OWNER TO postgres;<br /><br />The backup script also containproblems.<br /><br />The return value from select nextval('seqlingua') is correct (-2147483648). <br /><br />Thankyou, sorry my bad english<br /><br />Lucas Augusto Deters<br /><br clear="all" /><br />-- <br />Lucas Augusto Deters<br/>Coordenador de Sistemas (CEFET/SC)<br /><a href="mailto:deters@cefetsc.edu.br">deters@cefetsc.edu.br</a><br />(48)3221-0519
В списке pgadmin-support по дате отправления: