From: | "Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | installing pl/pgsql |
Date: | 2002-01-17 17:22:01 |
Message-ID: | 73309C2FDD95D11192E60008C7B1D5BB0452DD5A@snt452.corp.bcbsm.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Howdy:
I'm running Postgres 7.1.3 on Mandrake Linux 8.0, kernel
version 2.4.16.
I'm reading through a bit of documentation regarding pl/pgsql
and I don't see too much about it. As for installing it, the
documentation says, 'by default, it's there', but how can I
tell?
I thought I'd try this as an example:
[snip]
CREATE FUNCTION a_function () RETURNS int4 AS '
DECLARE
an_integer int4;
BEGIN
an_integer := 10 * 10;
return an_integer;
END;
' LANGUAGE 'plpgsql';
[/snip]
But I get an error saying something about no such language,
use C, sql, etc ...
Now, having said all of that ...
I would like to install it, but I'm not sure what the ramifications
are. (Should I stop and restart Postgres? How does this effect
the existing database / table? Should I install anything else
before / after this? Is it as straightforward as
http://www.postgressql.info/x5371.htm
makes it out to be?)
Any suggestions or pointers would be appreciated
TIA
-X
From | Date | Subject | |
---|---|---|---|
Next Message | M.L.Bowman | 2002-01-17 18:59:18 | |
Previous Message | Steve Boyle (Roselink) | 2002-01-17 16:59:26 | Re: how to limit postgresql process and memory time |