Tom Lane wrote:
> * How should one invoke nextval() and friends on such a sequence?
> Directly applying the existing convention, eg, nextval('sequencename'),
> won't work because those functions are declared to return int4. One
I'm not really a hacker, but why couldn't you simply change nextval to return int8 in all cases? Presumably there is an automatic (and silent) conversion from int8 to int4 where the range fits? The overhead of creating an int8 return value for an old-style int4 sequence (and converting it back to int4 for the INSERT/UPDATE) seems very small.
I'm missing something obvious again?
Allan.