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

From Thomas Lockhart
Subject Re: 64-bit sequences
Date
Msg-id 39542977.D90592FF@alumni.caltech.edu
Whole thread Raw
In response to 64-bit sequences  (Paul Caskey <paul@nmxs.com>)
Responses Re: 64-bit sequences  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
> > Mainly it's that int8 isn't supported on all our platforms.  As a
> > compile-time option it might be reasonable...

Or maybe better, as another type, say SERIAL64? That way both could be
available on some platforms. Also...

> Similar subject: What about making the oid 64-bit?  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.  
> Changing the typedef to "unsigned long long" should cover 
> everything...?  I will test it.

Again, a 64bit vs 32 bit issue. We have "pass by value" and "pass by
reference" data types, and we have conventionally made everything bigger
than 32bits a "by reference" type. Going to a 64bit OID or SERIAL type
may mess with that convention, but it may be good to revisit this and
remind ourselves why we have that convention in the first place.

Your other questions are related (I think) to the by-ref vs by-val
issue.
                  - Thomas


pgsql-hackers by date:

Previous
From: Tatsuo Ishii
Date:
Subject: Re: About the pid and opts files
Next
From: Thomas Lockhart
Date:
Subject: Re: query failed , don't know why