pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedPL/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