On 01/21/2014 02:51 PM, Susan Cassidy wrote:
When I tried to do CREATE EXTENSION IF NOT EXISTS
/usr/pgsql-9.2/share/extension/plpgsql.control with schema public;
it gave me
ERROR: syntax error at or near "EXTENSION"
CREATE LANGUAGE worked just fine. I only tried CREATE EXTENSION because
the manual said that CREATE LANGUAGE was deprecated.
If you trying to install plpgsql it is installed by default from 9.0+
If you trying to install something else you only need the extension name
not the file path, so just plpgsql in this case.
Susan
--
Adrian Klaver
adrian.klaver@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
