Postgres Pro
Downloads
Home   >   mailing lists

Thread: Bug with very low negative sequence values

Bug with very low negative sequence values

From
"Lucas Deters"
Date:
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

Re: Bug with very low negative sequence values

From
"Dave Page"
Date:
Please try v1.8.1 - you should not see this problem.

Regards, Dave

On 1/10/08, Lucas Deters <deters@cefetsc.edu.br> wrote:
> 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@cefetsc.edu.br
> (48) 3221-0519
>

-- 
Sent from my mobile device