pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
PL/pgSQL instalLation problem ??
2+ messages / 2 participants
[nested] [flat]

* PL/pgSQL instalLation problem ??
@ 2004-02-18 15:21  GP <pagomen@csd.uoc.gr>
  0 siblings, 1 reply; 2+ messages in thread

From: GP @ 2004-02-18 15:21 UTC (permalink / raw)
  To: pgsql-admin; +Cc: 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






^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: PL/pgSQL instalLation problem ??
@ 2004-02-22 02:32  Robert Treat <xzilla@users.sourceforge.net>
  parent: GP <pagomen@csd.uoc.gr>
  0 siblings, 0 replies; 2+ messages in thread

From: Robert Treat @ 2004-02-22 02:32 UTC (permalink / raw)
  To: GP <pagomen@csd.uoc.gr>; 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/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



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2004-02-22 02:32 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-02-18 15:21 PL/pgSQL instalLation problem ?? GP <pagomen@csd.uoc.gr>
2004-02-22 02:32 ` Robert Treat <xzilla@users.sourceforge.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox