Re: LSMB 1.3.5 and PostgreSQL 9.1

["David A. Bandel" <..hidden..>]

2011/11/22 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

Umm. No, you don't.  The CREATE EXTENSION does this.  With 9.1,
there's a new structure.  To check, run psql:
psql -U postgres your_database
at the SQL prompt (database=#) enter:
\dx<Enter>

you should see something like this:
                                 List of installed extensions
   Name    | Version |   Schema   |                        Description
-----------+---------+------------+------------------------------------------------------------
 plpgsql   | 1.0     | pg_catalog | PL/pgSQL procedural language
 tablefunc | 1.0     | public     | functions that manipulate whole
tables, including crosstab

See the Version number?  It corresponds to the tablefunc--1.0.sql
version number.

Unlike the contrib stored procedures, extensions aren't inherited from
template1 (don't ask me why, they just aren't).

>
> Regards
>
> Philippe
>
> --
> http://www.migratis.net
>
>
> ------------------------------------------------------------------------------
> All the data continuously generated in your IT infrastructure
> contains a definitive record of customers, application performance,
> security threats, fraudulent activity, and more. Splunk takes this
> data and makes sense of it. IT sense. And common sense.
> http://p.sf.net/sfu/splunk-novd2d
> _______________________________________________
> Ledger-smb-users mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-users
>

Ciao,

David A. Bandel
-- 
Two things are infinite: the universe and human stupidity; and I'm not
sure about the the universe. -- Albert Einstein
Visit my web page at: http://david.bandel.us/