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@[EMAIL PROTECTED]
> wrote:
> Hello,
>
> A bug re****t:
>
> 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
>

-- 
Sent from my mobile device

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster