Re: request a new feature in fuzzystrmatch

From: Alvaro Herrera <alvherre(at)2ndquadrant(dot)com>
To: Joe Conway <mail(at)joeconway(dot)com>
Cc: dawninghu(at)gmail(dot)com, David Fetter <david(at)fetter(dot)org>, Cédric Villemain <cedric(at)2ndquadrant(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>, Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
Subject: Re: request a new feature in fuzzystrmatch
Date: 2013-07-01 15:09:32
Message-ID: 20130701150932.GC3757@eldon.alvh.no-ip.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-www

Joe Conway escribió:

> Actually, given that this change will create version 1.1 of the
> extension, I believe the 1.0 versions of the sql scripts should
> probably be removed entirely. Can someone with more knowledge of the
> extension facility comment on that?

Besides what Michael said, another thing is that you need to ensure that
if the functions are run with the 1.0 definitions, they don't crash
(i.e. you need to check the number of arguments actually passed to
function(s), and ensure no changes are made to the types of previously
existing arguments). You can test this by installing the 1.0 version in
a 9.3 database, then pg_upgrade, and test the functions without running
the ALTER EXTENSION UPGRADE.

--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Antonin Houska 2013-07-01 15:11:26 Shorter iterations of join_info_list
Previous Message Pavel Stehule 2013-07-01 15:06:13 Re: checking variadic "any" argument in parser - should be array

Browse pgsql-www by date

  From Date Subject
Next Message Peter Eisentraut 2013-07-03 02:47:42 Re: news ticker Services Policy -- time for a change?
Previous Message Michael Paquier 2013-06-30 02:55:16 Re: request a new feature in fuzzystrmatch