Re: Oid registry - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: Oid registry
Date
Msg-id 50611666.6030804@dunslane.net
Whole thread Raw
In response to Re: Oid registry  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: Oid registry
Re: Oid registry
Re: Oid registry
Re: Oid registry
List pgsql-hackers
On 09/24/2012 09:37 PM, Peter Eisentraut wrote:
> On Mon, 2012-09-24 at 18:59 -0400, Andrew Dunstan wrote:
>> This rather overdue mail arises out the developer's meeting back in
>> May, where we discussed an item I raised suggesting an Oid registry.
>>
>> The idea came from some difficulties I encountered when I did the
>> backport of the JSON work we did in 9.2 to 9.1, but has wider
>> application. Say someone writes an extension that defines type A. You
>> want to write an extension that takes advantage of that type, but it's
>> difficult if you don't know the type's Oid,
> Could you fill the rest of us in with some technical details about why
> this might be necessary and what it aims to achieve?

Well, an obvious case is how record_to_json handles fields. If it knows 
nothing about the type all it can do is output the string value. That 
doesn't work well for types such as hstore. If it could reliably 
recognize a field as an hstore it might well be able to do lots better.

cheers

andrew



pgsql-hackers by date:

Previous
From: Brian Weaver
Date:
Subject: Re: Patch: incorrect array offset in backend replication tar header
Next
From: "Karl O. Pinc"
Date:
Subject: Re: Doc patch to note which system catalogs have oids