pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / 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