pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
First steps in plpgsql - language not recognized?
3+ messages / 3 participants
[nested] [flat]

* First steps in plpgsql - language not recognized?
@ 2001-07-17 13:48  Chris Ruprecht <chrup999@yahoo.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Chris Ruprecht @ 2001-07-17 13:48 UTC (permalink / raw)
  To: pgsql-sql

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




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* RE: First steps in plpgsql - language not recognized?
@ 2001-07-17 15:02  Robby Slaughter <webmaster@robbyslaughter.com>
  parent: Chris Ruprecht <chrup999@yahoo.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Robby Slaughter @ 2001-07-17 15:02 UTC (permalink / raw)
  To: Chris Ruprecht <chrup999@yahoo.com>; 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@postgresql.org
[mailto:pgsql-sql-owner@postgresql.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@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@postgresql.org)




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: First steps in plpgsql - language not recognized?
@ 2001-07-17 15:25  Peter Eisentraut <peter_e@gmx.net>
  parent: Chris Ruprecht <chrup999@yahoo.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Peter Eisentraut @ 2001-07-17 15:25 UTC (permalink / raw)
  To: Chris Ruprecht <chrup999@yahoo.com>; +Cc: pgsql-sql

man createlang

-- 
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter




^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2001-07-17 15:25 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-07-17 13:48 First steps in plpgsql - language not recognized? Chris Ruprecht <chrup999@yahoo.com>
2001-07-17 15:02 ` Robby Slaughter <webmaster@robbyslaughter.com>
2001-07-17 15:25 ` Peter Eisentraut <peter_e@gmx.net>

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