Re: change oid of a pg_type

From: Andrew Chernow <ac(at)esilo(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: change oid of a pg_type
Date: 2009-04-11 21:09:03
Message-ID: 49E106EF.1020408@esilo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Tom Lane wrote:
> Merlin Moncure <mmoncure(at)gmail(dot)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/

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2009-04-11 21:18:45 Re: pg_dumpall --clean is completely broken
Previous Message Bruce Momjian 2009-04-11 20:54:28 Re: pg_dumpall --clean is completely broken