Re: ?How create a one serial decimal(500,0) column or simulate it with bigint multicolumns serial?

On Sunday, January 7, 2018, Dani <danielcheagle(at)gmail(dot)com> wrote:

> Hi!
> Thanks for the quotes!
>
> My need is one column per table (primary id and auto_increment) and
> bigger max value than bigint :-). for now the max value for a sequence
> in Postgresql is bigint.
>
>
Create two bigint sequences. Call nextval on the first one. If the value
given is somewhere near the max call nextval on the other and reset the
first one, otherwise use currentval on the other sequence.

That should get you started: the docs should be able to fill in the blanks.

Frankly, I'd wait to add that second bigint until you are nearing
exhaustion of the first bigint sequence. Given you expected volume how
long until the first sequence is exhausted?

David J.