Tom Lane wrote:
Andrew Chernow <a...@esilo.com> writes:
Tom Lane wrote:
Merlin Moncure <mmonc...@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?

How is that related?


Well, the format is called "external", yet the oid is internal. It seem like a contradiction. Maybe I'm being to literal but i think external format should present an identifier other servers can understand/map.

If you can't fix oids, external format is useless to the outside world.

You have to be prepared to find out what type the OID belongs to.
There's at least one client library (maybe JDBC) that maintains
a cache of a SELECT from pg_type for exactly this purpose.  Most


Yeah, libpqtypes looks them up by schema.name as one registers them, PQregisterTypeHandler. Although this works, it feel more like a work around. I think it would be cleaner if a dns-like resolution was not required.

Andrew






--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to