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

PL/pgSQL instalLation problem ??

From: GP <pagomen(at)csd(dot)uoc(dot)gr>
To: pgsql-admin(at)postgresql(dot)org
Cc: GP <pagomen(at)csd(dot)uoc(dot)gr>
Subject: PL/pgSQL instalLation problem ??
Date: 2004-02-18 15:21:15
Message-ID: 403382EB.3040009@csd.uoc.gr (view raw or flat)
Thread:
Lists: pgsql-admin
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




Responses

pgsql-admin by date

Next:From: Warren LittleDate: 2004-02-18 16:57:29
Subject: Re: HELP - need way to restore only blobs
Previous:From: Bethany A.BenzurDate: 2004-02-18 14:10:18
Subject: Re: pg_user does not exist

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