Обсуждение: How to include plpgsql in table pg_language
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 Fri, 15 Feb 2002, Pam Wampler wrote: > 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? Use the createlang script to add the language to the database. createlang plpgsql database
> 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
that worked ! thanks -----Original Message----- From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com] Sent: Friday, February 15, 2002 12:01 PM To: Pam Wampler Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] How to include plpgsql in table pg_language On Fri, 15 Feb 2002, Pam Wampler wrote: > 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? Use the createlang script to add the language to the database. createlang plpgsql database
> that worked ! thanks > > -----Original Message----- > From: Stephan Szabo [mailto:sszabo@megazone23.bigpanda.com] > Sent: Friday, February 15, 2002 12:01 PM > To: Pam Wampler > Cc: pgsql-admin@postgresql.org > Subject: Re: [ADMIN] How to include plpgsql in table pg_language > > > > On Fri, 15 Feb 2002, Pam Wampler wrote: > Goods documentations are in: www.postgresql.org/idocs And the excelent book of Bruce Momjian : http://www.postgresql.org/docs/aw_pgsql_book/index.html I sugest you studie too the SPI interface, and make "C" programs to control your DataBase. 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