Postgres Pro
Downloads
Home   >   mailing lists

First steps in plpgsql - language not recognized? - Mailing list pgsql-sql

From Chris Ruprecht
Subject First steps in plpgsql - language not recognized?
Date
Msg-id 007501c10ec7$39ae75a0$5dd26383@corp.compucom.com
Whole thread Raw
Responses RE: First steps in plpgsql - language not recognized?  ("Robby Slaughter" <webmaster@robbyslaughter.com>)
Re: First steps in plpgsql - language not recognized?  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
Tree view 
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@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

pgsql-sql by date:

Previous
From: Tod McQuillin
Date:
Subject: Re: Select distinct and order by.
Next
From: mrink@avaya.com (Matt Rinkenberger)
Date:
Subject: using custom column names in a group by clause