Обсуждение: create language does not work... Or am I wrong?

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
------------------------------------------------------------------

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,
>
> 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)
>

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:

> 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)
>
>

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