PL/pgSQL instalLation problem ??

[GP]

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




---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

[Robert Treat]

Post by GP
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.
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

[Gorshkov]

I know that there are problems with the postmaster under windows, but does
anybody know/can they tell me if the libpq interface is reliable under
windows 2k?


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend