Re: Question on datatypes returned for "select oid, typname from pg_type"

Gavin Flower <GavinFlower@archidevsys.co.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