From: | "Robby Slaughter" <webmaster(at)robbyslaughter(dot)com> |
---|---|
To: | "Chris Ruprecht" <chrup999(at)yahoo(dot)com>, "p-sql" <pgsql-sql(at)postgresql(dot)org> |
Subject: | RE: First steps in plpgsql - language not recognized? |
Date: | 2001-07-17 15:02:56 |
Message-ID: | EPEHLKLEHAHLONFOKNHNOEOODCAA.webmaster@robbyslaughter.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Chris,
sounds like you haven't called 'createlang plpgsql database-name' at the
comand prompt. Try executing this and see if it works.
-Robby
-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org]On Behalf Of Chris Ruprecht
Sent: Tuesday, July 17, 2001 8:49 AM
To: p-sql
Subject: [SQL] First steps in plpgsql - language not recognized?
Hi all,
I have tried (and failed) my first steps in Pl/PgSQL.
This must be real simple (like a 'create language' or something) but I don't
(yet) know how to do this and maybe someone has a quick answer for me here.
I get this (I'm sure it's a clear case of RT(F)M, but there are so many Ms
to R, I don't know where to begin):
[postgres(at)chill-025 postgres]$ psql -f x.sql phones
psql:x.sql:1: ERROR: RemoveFunction: function 'testfunc(int4)' does not
exist
psql:x.sql:9: ERROR: Unrecognized language specified in a CREATE FUNCTION:
'plpgsql'.
Recognized languages are sql, C, internal, and created procedural
languages.
The first error is ok - the error in line 9 is what I'm worried about.
The code is what's in the tutorial, no biggy ;).
Best regards and thanks for the help,
Chris
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
From | Date | Subject | |
---|---|---|---|
Next Message | Josh Berkus | 2001-07-17 15:18:12 | Re: How Postgresql Compares For Some Query Types |
Previous Message | Bhuvan A | 2001-07-17 14:05:53 | CAST(ipaddress as text) -- HOW? |