It wasn't installed in the yum package that we used to install postgres 9.2. I had to add it. As I said, create language worked fine. Before I did create language, I got errors that the language didn't exist when I tried to create a function. After I created the language, those errors went away.
Susan On Tue, Jan 21, 2014 at 3:05 PM, Adrian Klaver <adrian.kla...@gmail.com>wrote: > 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.kla...@gmail.com >
