Re: LSMB 1.3.5 and PostgreSQL 9.1

[Philippe Scheltà <..hidden..>]

On Mon, 21 Nov 2011 17:02:34 -0800, Chris Travers wrote:
> > The directory /usr/pgsql-9.1/share/extension/ has these files.
> >
> > -rw-r--r-- 1 root root Â4839 Sep 23 02:26 pg_trgm--1.0.sql
> > -rw-r--r-- 1 root root  177 Sep 23 02:26 pg_trgm.control
> > -rw-r--r-- 1 root root Â4092 Sep 23 02:26 
> > pg_trgm--unpackaged--1.0.sql
> > ...
> > -rw-r--r-- 1 root root 15573 Sep 23 02:26 tsearch2--1.0.sql
> > -rw-r--r-- 1 root root  313 Sep 23 02:26 tsearch2.control
> > -rw-r--r-- 1 root root Â8951 Sep 23 02:26 
> > tsearch2--unpackaged--1.0.sql
> > ...
> > -rw-r--r-- 1 root root Â2013 Sep 23 02:26 tablefunc--1.0.sql
> > -rw-r--r-- 1 root root  174 Sep 23 02:26 tablefunc.control
> > -rw-r--r-- 1 root root Â1004 Sep 23 02:26 
> > tablefunc--unpackaged--1.0.sql
> >
> > Are these the new naming conventions?
>
> 9.1 moved from the contrib system to an extension system for managing
> this sort of behavior.  Create extension is supposed load the proper
> packages etc. for you.

To succeed in the upgrade with postgresql 9.1 I had to copy the 
extension sql files, as an example with tablefunc :

# cp tablefunc--1.0.sql tablefunc.sql

Regards

Philippe

--
http://www.migratis.net