Skip site navigation (1) Skip section navigation (2)

Re: Bug with very low negative sequence values

From: "Dave Page" <dpage(at)postgresql(dot)org>
To: "Lucas Deters" <deters(at)cefetsc(dot)edu(dot)br>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Bug with very low negative sequence values
Date: 2008-01-10 18:35:49
Message-ID: 937d27e10801101035o58932d21o720825a0aa9cf5df@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
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

In response to

pgadmin-support by date

Next:From: Guy RouillierDate: 2008-01-11 04:41:15
Subject: Export to clipboard
Previous:From: Lucas DetersDate: 2008-01-10 13:44:38
Subject: Bug with very low negative sequence values

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group