Re: extension installation PB

On Sun, 2011-11-06 at 19:58 +0100, Jean-Yves F. Barbier wrote:
>
> I've an old script installing Pg extensions that I modified to fit
> from 9.1 paths & file names.
> However it throw errors for any extension package, ie:
>
> =# \i /usr/share/postgresql/9.1/extension/adminpack--1.0.sql

As of 9.1, you cannot run those files via \i. Now there is a simpler
way:

CREATE EXTENSION adminpack;

http://www.postgresql.org/docs/9.1/static/sql-createextension.html

Regards,
--
Devrim GÜNDÜZ
Principal Systems Engineer @ EnterpriseDB: http://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Community: devrim~PostgreSQL.org, devrim.gunduz~linux.org.tr
http://www.gunduz.org Twitter: http://twitter.com/devrimgunduz