pg.ddx.io pgsql-sql@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Chris Ruprecht <chrup999@yahoo.com>
To: p-sql <pgsql-sql@postgresql.org>
Subject: First steps in plpgsql - language not recognized?
Date: Tue, 17 Jul 2001 08:48:56 -0500
Message-ID: <007501c10ec7$39ae75a0$5dd26383@corp.compucom.com> (raw)
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
view thread (3+ messages) latest in thread
Message-ID: <007501c10ec7$39ae75a0$5dd26383@corp.compucom.com> Permalink: ../007501c10ec7$39ae75a0$5dd26383@corp.compucom.com/ Also on: postgresql.org/message-id/007501c10ec7$39ae75a0$5dd26383@corp.compucom.com ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients using the --to and --cc options: reply via email To: pgsql-sql@postgresql.org Cc: chrup999@yahoo.com Subject: Re: First steps in plpgsql - language not recognized? In-Reply-To: <007501c10ec7$39ae75a0$5dd26383@corp.compucom.com> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox