Skip site navigation (1) Skip section navigation (2)

Re: PL/pgSQL instalLation problem ??

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: GP <pagomen(at)csd(dot)uoc(dot)gr>, pgsql-admin(at)postgresql(dot)org
Subject: Re: PL/pgSQL instalLation problem ??
Date: 2004-02-22 02:32:37
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
On Wednesday 18 February 2004 10:21, GP wrote:
> Hi All,
> I am trying to run the tutorial examples concerning the "Implementation
> of views in PostgreSQL" but I have some problems with the
> PL/pgSQL language installation..
> The corresponding library is located in /usr/local/pgsql/lib/
> and I set the PGLIB enviroment variable to /usr/local/pgsql/lib.
> But when I issue the command for installing the plpsql I get an error:
> template1=# createlang plpsql template1;
> ERROR:  syntax error at or near "createlang" at character 1
> Did I miss something ?

createlang needs to be run from the shell, not from inside the database,

Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

In response to


pgsql-admin by date

Next:From: GorshkovDate: 2004-02-22 21:34:23
Subject: Windows availability/reliability?
Previous:From: Robert TreatDate: 2004-02-22 02:22:28
Subject: Re: Panic involving a LC_COLLATE issue

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group