Re: change oid of a pg_type

Tom Lane wrote:
> Merlin Moncure <mmoncure@gmail.com> writes:
>> Is there any way to adjust the oid of an already created pg_type
> 
> No.
> 
> 

Then why are oids sent in some type's external binary format?  If you 
can't fix oids, external format is useless to the outside world.  Since 
you CAN modify a type's name all day long, shouldn't schema.typname be 
the external way to reference types?  Or, perhaps, another mechanism. 
There are some very powerful things that could be achieved, with a more 
portable way of referencing types.

-- 
Andrew Chernow
eSilo, LLC
every bit counts
http://www.esilo.com/