Hi Thomas,
Did you create/insert plpgsql language in your database? I guess not...
Check your database with createlang -l YOUR_DATABASE_NAME. This should
show you the languages installed in your database. In case you don't
have it, just use createlang plplgsql YOUR_DATABASE_NAME. This should
work...
Suggestion, if you are gonna use plpgsql a lot developing in
Postgresql, I suggest that you create the language you need in template1
(createlang LANGUAGE template1). By doing that you will automatically
create the language in your new database when issuing a createdb
NEWDATABASE, because createdb uses template1 as a template to create
your new database...
RTM createlang for more info...
On Mon, 13 Oct 2003 10:58:55 -0500
"Thomas LeBlanc" <th*********@hotmail.com> wrote:
I copied an example from the help:
CREATE FUNCTION somefunc() RETURNS integer AS '
DECLARE
quantity integer := 30;
BEGIN
RAISE NOTICE ''Quantity here is %'', quantity; -- Quantity here
is 30 quantity := 50;
--
-- Create a subblock
--
DECLARE
quantity integer := 80;
BEGIN
RAISE NOTICE ''Quantity here is %'', quantity; -- Quantity
here is
80
END;
RAISE NOTICE ''Quantity here is %'', quantity; -- Quantity here
is 50
RETURN quantity;
END;
' LANGUAGE plpgsql
Ran it is a SQL window from pgAdmin and got this error:
ERROR: language "plpgsql" does not exist
Thanks,
Thomas LeBlanc
__________________________________________________ _______________
Share your photos without swamping your Inbox. Get Hotmail Extra
Storage today! http://join.msn.com/?PAGE=features/es
---------------------------(end of
broadcast)--------------------------- TIP 1: subscribe and unsubscribe
commands go to ma*******@postgresql.org
-----------------------------
Cordialmente,
Renê Salomão
re**@ibiz.com.br re**********@interchange.com.br
--------------------------------
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html