| From: | "Marco Tulio" <anjo(dot)doce(dot)marilia(at)bol(dot)com(dot)br> |
|---|---|
| To: | Pam_Wampler(at)taylorwhite(dot)com |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: How to include plpgsql in table pg_language |
| Date: | 2002-02-15 20:33:33 |
| Message-ID: | GRLD3X$IslhMfs9UQ1M0YNgoNHF0e2dvFPAC3jFMI9FojHf1xdBy@bol.com.br |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Marco Tulio | 2002-02-15 20:44:14 | Re: hanging psql session while granting... |
| Previous Message | Srinivasa Rao Chava | 2002-02-15 20:08:13 | problem with postgresql 7.2 recovery |