Re: hstores in pl/python - Mailing list pgsql-hackers

From Jan Urbański
Subject Re: hstores in pl/python
Date
Msg-id 4D08E006.1080006@wulczer.org
Whole thread Raw
In response to Re: hstores in pl/python  (Dmitriy Igrishin <dmitigr@gmail.com>)
Responses Re: hstores in pl/python  (Florian Pflug <fgp@phlo.org>)
List pgsql-hackers
On 15/12/10 16:25, Dmitriy Igrishin wrote:
> 2010/12/15 Jan Urbański <wulczer@wulczer.org>
>> So how about just adding a text column to pg_type and a IDENTIFIER
>> keywork to CREATE TYPE. It's not guaranteed to be unique, but isn't it
>> pushing the argument to the extreme? Someone can change around bool and
>> text type oids, too... And then hstore_plpython looks up the well-known
>> identifier, sets up a RVV with the OID and everyone's happy.
>>
> How IDENTIFIER differs from name ? org.postgresql.hstore vs hstore ?

Hm, now that I think of it, the only real difference is that you don't
use search_path to look it up. So public.hstore is just as good an
identifier...

I could live with plpython_hstore_type = "public.hstore", I guess.
hstore_plpython would look at that GUC, look up the type, set up a RVV
containing the OID and plpython would use it.

Cheers,
Jan


pgsql-hackers by date:

Previous
From: Dmitriy Igrishin
Date:
Subject: Re: hstores in pl/python
Next
From: Robert Haas
Date:
Subject: Re: unlogged tables