Re: Bug with very low negative sequence values

Please try v1.8.1 - you should not see this problem.

Regards, Dave

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

--
Sent from my mobile device