Re: Notes about int8 sequences - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Notes about int8 sequences
Date
Msg-id 24672.997133581@sss.pgh.pa.us
Whole thread Raw
In response to Notes about int8 sequences  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Re: Notes about int8 sequences
List pgsql-hackers
Allan Engelhardt <allane@cybaea.com> writes:
> I'm not really a hacker, but why couldn't you simply change nextval to
> return int8 in all cases?

Hmm.  That's a possibility.  There's some potential for trouble if an
application is expecting an int4 result from "SELECT nextval()" and
gets int8 instead, but if we think we could live with that...

Actually, if we thought we could live with that, my inclination would be
to blow off int4-based sequences altogether, and just redefine SEQUENCE
objects as operating on INT8.  Interesting thought, eh?
        regards, tom lane


pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Re: Re: AW: Re: OID wraparound: summary and proposal
Next
From: Allan Engelhardt
Date:
Subject: Re: Notes about int8 sequences