[Postgres-xc-developers] Issues with Sequences with negative increments

[Nikhil S. <ni...@st...>]

Hi all,

Consider the following:

create sequence seqname increment by -2;
select nextval('seqname');
ERROR:  GTM error, could not obtain sequence value

The above should have returned -1.

ISTM, the sequence fetching logic on the backend side has been coded
entirely with the assumption that sequences can never have negative values.
So a less than 0 value returned from get_next() is assumed to be a problem!
That's completely wrong. We need to deal with this properly. I will submit
a patch for this when I get some time soon.

Regards,
Nikhils
-- 
StormDB - http://www.stormdb.com
The Database Cloud