Re: change oid of a pg_type - Mailing list pgsql-hackers

From Andrew Chernow
Subject Re: change oid of a pg_type
Date
Msg-id 49E106EF.1020408@esilo.com
Whole thread Raw
In response to Re: change oid of a pg_type  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: change oid of a pg_type  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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/


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_dumpall --clean is completely broken
Next
From: Tom Lane
Date:
Subject: Re: pg_dumpall --clean is completely broken