From: Robert Treat <xzilla@users.sourceforge.net>
To: GP <pagomen@csd.uoc.gr>
To: pgsql-admin@postgresql.org
Subject: Re: PL/pgSQL instalLation problem ??
Date: Sat, 21 Feb 2004 21:32:37 -0500
Message-ID: <200402212132.37759.xzilla@users.sourceforge.net> (raw)
In-Reply-To: <403382EB.3040009@csd.uoc.gr>
References: <403382EB.3040009@csd.uoc.gr>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: xzilla@users.sourceforge.net, pagomen@csd.uoc.gr
Subject: Re: PL/pgSQL instalLation problem ??
In-Reply-To: <200402212132.37759.xzilla@users.sourceforge.net>
References: <403382EB.3040009@csd.uoc.gr> <200402212132.37759.xzilla@users.sourceforge.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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