Skip site navigation (1) Skip section navigation (2)

Re: extension facility (was: revised hstore patch)

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: "David E(dot) Wheeler" <david(at)kineticode(dot)com>
Cc: Dimitri Fontaine <dfontaine(at)hi-media(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: extension facility (was: revised hstore patch)
Date: 2009-07-23 11:08:57
Message-ID: 5962B730-95CB-4E18-8AFD-0AFCCF35923E@gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
On Jul 23, 2009, at 2:44 AM, "David E. Wheeler" <david(at)kineticode(dot)com>  
wrote:

> On Jul 22, 2009, at 1:11 PM, Robert Haas wrote:
>
>> If you keep an old and a new version of the datatype, you can't
>> upgrade a tuple at a time, but you can at least upgrade one column at
>> a time, which is still better than a kick in the head.
>
> And as long as you're willing to deprecate how far back you'll go in  
> doing such updates, thus keeping the maintenance of your code  
> reasonable over time.

Of course.

>
>> If you make the extension-upgrade facility rewrite everything, you
>> have to do your entire cluster in one shot.  That will work for some
>> people, but not for all.  And unless you ship both versions of hstore
>> with either PG 8.4 or PG 8.5, you're going to need the conversion to
>> be done inside pg_migrator, which introduces a whole new level of
>> complexity that I think we'd be better off without.
>
> Well, it depends. If there could be some sort of defined interface  
> for pg_migrator could call to migrate any data type (this issue  
> applies mainly to types, yes?), then an extension author just needs  
> to implement that interface. No?

Yes... but "if" and "just" can paper over a good deal of complexity,  
and it's not clear to me that there's any compensating advantage.

...Robert 

In response to

Responses

pgsql-hackers by date

Next:From: Laurent LabordeDate: 2009-07-23 11:22:59
Subject: Re: Higher TOAST compression.
Previous:From: Richard HuxtonDate: 2009-07-23 10:50:02
Subject: Re: Extensions User Design

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group