| From: | Doug McNaught <doug(at)wireboard(dot)com> |
|---|---|
| To: | "Muhammad Rusydi" <rusydi(at)cbn(dot)net(dot)id> |
| Cc: | "John Clark L(dot) Naldoza" <njclark(at)ntsp(dot)nec(dot)co(dot)jp>, "postgres general" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: how can i get plpgsql in function? |
| Date: | 2001-05-05 04:50:40 |
| Message-ID: | m3bsp8flgf.fsf@belphigor.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Muhammad Rusydi" <rusydi(at)cbn(dot)net(dot)id> writes:
> > CREATE PROCEDURAL LANGUAGE 'PL/PGSQL' or something..;-)
> >
> but there's an error when i do this one
> parse error near ";" it says
> would you or anyone here help me again?
Easiest way to do this is to use the 'createlang' shell script that
ships with Postgres:
$ createlang -d <dbname> plpgsql
If you do it to the 'template1' database, all other DBs created after
that will have PL/PGSQL available.
-Doug
--
The rain man gave me two cures; he said jump right in,
The first was Texas medicine--the second was just railroad gin,
And like a fool I mixed them, and it strangled up my mind,
Now people just get uglier, and I got no sense of time... --Dylan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Muhammad Rusydi | 2001-05-05 06:49:31 | how can i change my table/column constraint |
| Previous Message | Neil Conway | 2001-05-05 04:40:21 | Re: Re: VACUUM is hanging |