Re: jsonb and nested hstore

On 2014-03-05 10:10:23 -0600, Merlin Moncure wrote:
> On Wed, Mar 5, 2014 at 9:52 AM, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > On Wed, Mar 5, 2014 at 09:19:33AM -0600, Merlin Moncure wrote:
> >> *All* non-sql standard types ought to be in extensions in an ideal world.
> >
> > I have seen your opinion on this but there have been enough
> > counter-arguments that I am not ready to head in that direction.
>
> The only counter argument given is that this will prevent people from
> being able to use extensions because they A: can't or won't install
> contrib packages or B: are too stupid or lazy to type 'create
> extension json'. Note I'm discussing 'in core extension vs in core
> built in'. 'out of core extension' loosely translates to 'can't be
> used by the vast majority of systems.

There's the absolutely significant issue that you cannot reasonably
write extensions that interact on a C level. You can't call from
extension to extension directly, but you can from extension to pg core
provided ones.

Greetings,

Andres Freund

--
Andres Freund http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services