Re: Question on datatypes returned for "select oid, typname from pg_type" - Mailing list pgsql-general

From Tom Lane
Subject Re: Question on datatypes returned for "select oid, typname from pg_type"
Date
Msg-id 5695.1331327050@sss.pgh.pa.us
Whole thread Raw
In response to Question on datatypes returned for "select oid, typname from pg_type"  (Alexander Reichstadt <lxr@mac.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Francisco Figueiredo Jr."
Date:
Subject: Re: 9.1 causing "out of shared memory" error and higher serialization conflicts
Next
From: Gavin Flower
Date:
Subject: Re: Question on datatypes returned for "select oid, typname from pg_type"