| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> |
| Cc: | Alexander Reichstadt <lxr(at)mac(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Question on datatypes returned for "select oid, typname from pg_type" |
| Date: | 2012-03-09 21:04:10 |
| Message-ID: | 5695.1331327050@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Gavin Flower <GavinFlower(at)archidevsys(dot)co(dot)nz> writes:
> On 10/03/12 09:15, Tom Lane wrote:
>> The built-in data types have hand-assigned OIDs, as depicted in
>> src/include/catalog/pg_type.h. While those aren't quite
>> guaranteed-frozen, we've never changed one that I can recall, and are
>> not very likely to in the future.
> That kind of reasoning makes me nervous!
> What if some developer wants to change the OIDs assigned for some
> reason, and is blissfully unaware that people depend on those precise
> values?
The committers are well aware of this, at least, so I would be very
surprised to see a random reassignment of type OIDs slip through.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Randy Ficker | 2012-03-09 22:17:39 | Re: 9.1 causing "out of shared memory" error and higher serialization conflicts |
| Previous Message | Gavin Flower | 2012-03-09 21:00:19 | Re: Question on datatypes returned for "select oid, typname from pg_type" |