Re: bug using sequences

Olivier Bouiron a écrit :
> I've found a mistake using PGADMIN 1.6 or PGADMIN 1.8 beta5:
> When I make a sequence with negative values, it works but PGADMIN is not
> able to show me the correct values.
>
> This is an exemple:
> PGADMIN shows me this:
>
> CREATE SEQUENCE dsi.dsi_pha_molecule_id_seq
> INCREMENT 18446744073709551615
> MINVALUE 18446744073709541616
> MAXVALUE 0
> START 18446744073709549616
> CACHE 1;
> ALTER TABLE dsi.dsi_pha_molecule_id_seq OWNER TO postgres;
>
> but in fact that sequence send me negative values...
>

Well, they are declared wxULongLong, ie unsigned long. I wonder why. It
should be simple enough to change that to wxLongLong. I'll write a patch
for this.

Regards.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com