create language does not work... Or am I wrong?

You have to go to the bin directory usually /usr/local/pgsql/bin

Then you run the createlang command.

Do not run it from the psql interface

Darren

Darren Ferguson
Software Engineer
Openband

On Fri, 18 Jan 2002, Devrim GUNDUZ wrote:

Hi Devrim,

You need to run this from the unix prompt as the "postgres" user :

$ createlang plpgsql template1
$

Regards and best wishes,

Justin Clift

Devrim GUNDUZ wrote:

Hi,

I am using PostgreSQL v7.1.3 on RedHat. I have used rpm to install PG.

I am trying to use the following command:

template1=# createlang plpgsql template1;
ERROR: parser: parse error at or near "createlang"

I think I have missed something while installing PG... What is it?

Regards, and best wishes,

--

Devrim G�ND�Z

devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net

Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

Hi Justin and to all who replied,

I think all went ok. Here is the output:

[devrim@oper devrim]$ createlang plpgsql operdb2 -p 5450 -U postgres;
Password:
Password:
Password:
Password:
[devrim@oper devrim]$

thanks again...

--

Devrim G�ND�Z

devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net

Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------

On Sat, 19 Jan 2002, Justin Clift wrote: