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

ALTER EXTENSION UPGRADE, v3

From: Dimitri Fontaine <dimitri(at)2ndQuadrant(dot)fr>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: ALTER EXTENSION UPGRADE, v3
Date: 2011-02-01 18:21:03
Message-ID: m2y65zfwfk.fsf@2ndQuadrant.fr (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

PFA version 3 of the ALTER EXTENSION PATCH, cleaned and merged against
recent HEAD and extension's branch from which I just produced the v30
patch.

It includes a way to upgrade "from null", that is from pre-9.1, and the
specific upgrade files to achieve that for all contribs.  That goes like
this:

dim=# \i ~/pgsql/exts/share/contrib/lo.sql
CREATE DOMAIN
CREATE FUNCTION
CREATE FUNCTION
dim=# create wrapper extension lo;
CREATE EXTENSION
dim=# alter extension lo upgrade;
ALTER EXTENSION
dim=# alter extension lo set schema utils;
ALTER EXTENSION
dim=# \dx lo
    Objects in extension "lo"
       Object Description        
---------------------------------
 function utils.lo_manage()
 function utils.lo_oid(utils.lo)
 type utils.lo
(3 rows)

Regards,
-- 
Dimitri Fontaine
http://2ndQuadrant.fr     PostgreSQL : Expertise, Formation et Support


Attachment: upgrade_extension.v3.patch.gz
Description: application/octet-stream (24.2 KB)

Responses

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2011-02-01 18:30:12
Subject: Re: Spread checkpoint sync
Previous:From: Bruce MomjianDate: 2011-02-01 18:10:35
Subject: Re: pg_upgrade fails for non-postgres user

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