[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: LSMB 1.3.5 and PostgreSQL 9.1

Le 23/11/2011 01:10, David A. Bandel a écrit :

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:

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).

It is what I had to do to succeed in the lsmb upgrade to version 1.3, probably due to something needed tablefunc.sql
in the upgrade script.