Re: How to include plpgsql in table pg_language - Mailing list pgsql-admin

From Marco Tulio
Subject Re: How to include plpgsql in table pg_language
Date
Msg-id GRLD3X$IslhMfs9UQ1M0YNgoNHF0e2dvFPAC3jFMI9FojHf1xdBy@bol.com.br
Whole thread Raw
In response to How to include plpgsql in table pg_language  (Pam Wampler <Pam_Wampler@taylorwhite.com>)
List pgsql-admin
> I am trying to get a trigger/function to work & I
think I need to use the
> plpgsql to do that --
> but I keep getting errors that the plpgsql is not in
the table pg_language
> --
> What do I need to do to be able to use plpgsql?
>
> I am running 7.1.3
>
> thanks
> Pam
>


on console, as postgres user, type:

createlang --dbname=dbtest --pglib=/usr/local/pgsql/lib
pspgsql

And have fun !


Marco Tulio
Desenvolvimento de sistemas para Internet


__________________________________________________________________________
Quer ter seu próprio endereço na Internet?
Garanta já o seu e ainda ganhe cinco e-mails personalizados.
DomíniosBOL - http://dominios.bol.com.br



pgsql-admin by date:

Previous
From: s.chava@wcom.com (Srinivasa Rao Chava)
Date:
Subject: problem with postgresql 7.2 recovery
Next
From: "Marco Tulio"
Date:
Subject: Re: hanging psql session while granting...