Bug with very low negative sequence values

------=_Part_19135_32064731.1199972678470
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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@[EMAIL PROTECTED]
(48) 3221-0519

------=_Part_19135_32064731.1199972678470
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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&#39;m trying to create a sequence
like this:<br><br>CREATE SEQUENCE seqlingua
<br>&nbsp; INCREMENT 1<br>&nbsp; MINVALUE -2147483648<br>&nbsp; MAXVALUE
2147483647<br>&nbsp; START -2147483648<br>&nbsp; CACHE 1;<br><br>But
PGAdmin show this DDL in the interface:<br><br>CREATE SEQUENCE
seqlingua<br>&nbsp; INCREMENT 1<br>&nbsp; MINVALUE 18446744071562067968
<br>&nbsp; MAXVALUE 2147483647<br>&nbsp; START
18446744071562067968<br>&nbsp; CACHE 1;<br>ALTER TABLE seqlingua OWNER TO
postgres;<br><br>The backup script also contain problems.<br><br>The
return value from select nextval(&#39;seqlingua&#39;) is correct
(-2147483648).
<br><br>Thank you, 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@[EMAIL PROTECTED]
">deters@[EMAIL PROTECTED]
>
<br>(48) 3221-0519

------=_Part_19135_32064731.1199972678470--