PL/pgSQL instalLation problem ??
PL/pgSQL instalLation problem ??
От:
GP <pagomen@csd.uoc.gr>
Дата:
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/plpgsql.so 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 ? Thanks in advance George
Re: PL/pgSQL instalLation problem ??
От:
Robert Treat <xzilla@users.sourceforge.net>
Дата:
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/plpgsql.so
> 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