Re: 64-bit sequences - Mailing list pgsql-hackers

From Tom Lane
Subject Re: 64-bit sequences
Date
Msg-id 20300.961820593@sss.pgh.pa.us
Whole thread Raw
In response to Re: 64-bit sequences  (Paul Caskey <paul@nmxs.com>)
Responses Re: 64-bit sequences  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
Paul Caskey <paul@nmxs.com> writes:
> Okay, cool.  Similar subject: What about making the oid 64-bit?

Let's just say you'd be opening a *much* larger can of worms there,
because Oid is used all over the place whereas only a few routines
know anything about sequences.

This is (or should be) on the TODO list but I wouldn't recommend it
as your first backend programming project.

> At first glance, this seems easier to change than the sequence
> generator, since you guys do a good job of using sizeof() and the Oid
> typedef.

Except for all the places that assume Oid is interchangeable with int.
Finding them is left as an exercise for the student...
        regards, tom lane


pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: query failed , don't know why
Next
From: Tom Lane
Date:
Subject: Re: query failed , don't know why