pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedlanguage "plpgsql" does not exist
13+ messages / 11 participants
[nested] [flat]
* language "plpgsql" does not exist
@ 2003-05-23 06:48 Bruce Young <hbrucey@yahoo.com>
0 siblings, 7 replies; 13+ messages in thread
From: Bruce Young @ 2003-05-23 06:48 UTC (permalink / raw)
To: pgsql-sql
i am trying to create functions only to get the above error in return.
what do i need to do to get PL/PGSQL functions working?
example:
CREATE FUNCTION logfunc1(text) RETURNS timestamp AS '
DECLARE
logtxt ALIAS FOR $1;
BEGIN
INSERT INTO logtable VALUES (logtxt, ''now'');
RETURN ''now'';
END;
' LANGUAGE plpgsql;
# ERROR: language "plpgsql" does not exist
any help appreciated
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: language "plpgsql" does not exist
@ 2003-05-23 09:43 Devrim GUNDUZ <devrim@gunduz.org>
parent: Bruce Young <hbrucey@yahoo.com>
6 siblings, 0 replies; 13+ messages in thread
From: Devrim GUNDUZ @ 2003-05-23 09:43 UTC (permalink / raw)
To: Bruce Young <hbrucey@yahoo.com>; +Cc: pgsql-sql
HÝ,
On Thu, 22 May 2003, Bruce Young wrote:
> # ERROR: language "plpgsql" does not exist
Use createlang for installing plpgsql to that database.
usage: createlang plpgsql dbname
Remember that createlang may require additional options like username,
port, etc. Detailed usage is written in man page.
Regards,
--
Devrim GUNDUZ
devrim@gunduz.org devrim.gunduz@linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: language "plpgsql" does not exist
@ 2003-05-23 09:45 David Witham <davidw@unidial.com.au>
0 siblings, 0 replies; 13+ messages in thread
From: David Witham @ 2003-05-23 09:45 UTC (permalink / raw)
To: Bruce Young <hbrucey@yahoo.com>; pgsql-sql
HI Bruce,
See the createlang shell script in the reference manual under the Client Applications section. You need to "create" a language in the target database before you can use it to program with against that database.
Regards,
David Witham
Telephony Platforms Architect
Unidial
-----Original Message-----
From: Bruce Young [mailto:hbrucey@yahoo.com]
Sent: Friday, 23 May 2003 16:49
To: pgsql-sql@postgresql.org
Subject: [SQL] language "plpgsql" does not exist
i am trying to create functions only to get the above error in return.
what do i need to do to get PL/PGSQL functions working?
example:
CREATE FUNCTION logfunc1(text) RETURNS timestamp AS '
DECLARE
logtxt ALIAS FOR $1;
BEGIN
INSERT INTO logtable VALUES (logtxt, ''now'');
RETURN ''now'';
END;
' LANGUAGE plpgsql;
# ERROR: language "plpgsql" does not exist
any help appreciated
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: language "plpgsql" does not exist
@ 2003-05-23 10:26 Richard Huxton <dev@archonet.com>
parent: Bruce Young <hbrucey@yahoo.com>
6 siblings, 0 replies; 13+ messages in thread
From: Richard Huxton @ 2003-05-23 10:26 UTC (permalink / raw)
To: Bruce Young <hbrucey@yahoo.com>; pgsql-sql
On Friday 23 May 2003 7:48 am, Bruce Young wrote:
> i am trying to create functions only to get the above error in return.
> what do i need to do to get PL/PGSQL functions working?
> example:
>
> CREATE FUNCTION logfunc1(text) RETURNS timestamp AS '
> DECLARE
> logtxt ALIAS FOR $1;
> BEGIN
> INSERT INTO logtable VALUES (logtxt, ''now'');
> RETURN ''now'';
> END;
> ' LANGUAGE plpgsql;
>
> # ERROR: language "plpgsql" does not exist
You need to do a "CREATE LANGUAGE" or use the createlang command-line tool to
enable it in your database:
createlang plpgsql mydatabase
--
Richard Huxton
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: language "plpgsql" does not exist
@ 2003-05-23 11:10 Rod Taylor <rbt@rbt.ca>
parent: Bruce Young <hbrucey@yahoo.com>
6 siblings, 0 replies; 13+ messages in thread
From: Rod Taylor @ 2003-05-23 11:10 UTC (permalink / raw)
To: Bruce Young <hbrucey@yahoo.com>; +Cc: pgsql-sql
> # ERROR: language "plpgsql" does not exist
You need to create it before you may use it.
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=xplang-install.html
--
Rod Taylor <rbt@rbt.ca>
PGP Key: http://www.rbt.ca/rbtpub.asc
Attachments:
signature.asc (application/pgp-signature, 186B) download
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: language "plpgsql" does not exist
@ 2003-05-23 11:18 Oliver Elphick <olly@lfix.co.uk>
parent: Bruce Young <hbrucey@yahoo.com>
6 siblings, 0 replies; 13+ messages in thread
From: Oliver Elphick @ 2003-05-23 11:18 UTC (permalink / raw)
To: Bruce Young <hbrucey@yahoo.com>; +Cc: pgsql-sql
On Fri, 2003-05-23 at 07:48, Bruce Young wrote:
> i am trying to create functions only to get the above error in return.
> what do i need to do to get PL/PGSQL functions working?
> example:
...
> # ERROR: language "plpgsql" does not exist
Use the createlang script to create the language in that database.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"But where shall wisdom be found? And where is the
place of understanding? It cannot be gotten for gold,
neither shall silver be weighed for the price thereof.
Whence then cometh wisdom? and where is the place of
understanding? ...Behold the fear of the Lord, that is
wisdom; and to depart from evil is understanding."
Job 12,15,20,28
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: language "plpgsql" does not exist
@ 2003-05-23 11:28 Christoph Haller <ch@rodos.fzk.de>
0 siblings, 0 replies; 13+ messages in thread
From: Christoph Haller @ 2003-05-23 11:28 UTC (permalink / raw)
To: pgsql-sql; +Cc: hbrucey@yahoo.com
>
> i am trying to create functions only to get the above error in return.
> what do i need to do to get PL/PGSQL functions working?
> example:
>
> CREATE FUNCTION logfunc1(text) RETURNS timestamp AS '
> DECLARE
> logtxt ALIAS FOR $1;
> BEGIN
> INSERT INTO logtable VALUES (logtxt, ''now'');
> RETURN ''now'';
> END;
> ' LANGUAGE plpgsql;
>
> # ERROR: language "plpgsql" does not exist
>
RTFM and refer to the SQL Command CREATE LANGUAGE.
Regards, Christoph
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: language "plpgsql" does not exist
@ 2003-05-23 11:32 Victor Yegorov <viktors.jegorovs@nordlb.lv>
parent: Bruce Young <hbrucey@yahoo.com>
6 siblings, 1 reply; 13+ messages in thread
From: Victor Yegorov @ 2003-05-23 11:32 UTC (permalink / raw)
To: Bruce Young <hbrucey@yahoo.com>; +Cc: pgsql-sql
* Bruce Young <hbrucey@yahoo.com> [23.05.2003 14:29]:
> i am trying to create functions only to get the above error in return.
> what do i need to do to get PL/PGSQL functions working?
> example:
>
> CREATE FUNCTION logfunc1(text) RETURNS timestamp AS '
> DECLARE
> logtxt ALIAS FOR $1;
> BEGIN
> INSERT INTO logtable VALUES (logtxt, ''now'');
> RETURN ''now'';
> END;
> ' LANGUAGE plpgsql;
>
> # ERROR: language "plpgsql" does not exist
issue the following command on console (comand interpreter):
$ createlang plpgsql <dbname>
--
Victor Yegorov
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: language "plpgsql" does not exist
@ 2003-05-23 12:27 A.Bhuvaneswaran <bhuvan@symonds.net>
parent: Bruce Young <hbrucey@yahoo.com>
6 siblings, 0 replies; 13+ messages in thread
From: A.Bhuvaneswaran @ 2003-05-23 12:27 UTC (permalink / raw)
To: Bruce Young <hbrucey@yahoo.com>; +Cc: pgsql-sql
> i am trying to create functions only to get the above error in return.
> what do i need to do to get PL/PGSQL functions working?
> example:
>
> CREATE FUNCTION logfunc1(text) RETURNS timestamp AS '
> DECLARE
> logtxt ALIAS FOR $1;
> BEGIN
> INSERT INTO logtable VALUES (logtxt, ''now'');
> RETURN ''now'';
> END;
> ' LANGUAGE plpgsql;
>
> # ERROR: language "plpgsql" does not exist
The problem is, you have not installed the language 'plpgsql'. It can be
done using createlang command.
regards,
bhuvaneswaran
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: language "plpgsql" does not exist
@ 2003-05-23 13:40 Bruce Young <hbrucey@yahoo.com>
parent: Victor Yegorov <viktors.jegorovs@nordlb.lv>
0 siblings, 2 replies; 13+ messages in thread
From: Bruce Young @ 2003-05-23 13:40 UTC (permalink / raw)
To: pgsql-sql
Whoa! thanks a lot guys. didnt RTFM enough.
i now got it working from the following command:
$ createlang plpgsql <dbname>
Question is: why did it prompt me to enter my password so many times? 4 to be
exact.
i only have one user besides postgres.
thanks again.
- bruce
__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: language "plpgsql" does not exist
@ 2003-05-23 15:43 Achilleus Mantzios <achill@matrix.gatewaynet.com>
parent: Bruce Young <hbrucey@yahoo.com>
6 siblings, 0 replies; 13+ messages in thread
From: Achilleus Mantzios @ 2003-05-23 15:43 UTC (permalink / raw)
To: Bruce Young <hbrucey@yahoo.com>; +Cc: pgsql-sql
On Thu, 22 May 2003, Bruce Young wrote:
> i am trying to create functions only to get the above error in return.
> what do i need to do to get PL/PGSQL functions working?
> example:
>
> CREATE FUNCTION logfunc1(text) RETURNS timestamp AS '
> DECLARE
> logtxt ALIAS FOR $1;
> BEGIN
> INSERT INTO logtable VALUES (logtxt, ''now'');
> RETURN ''now'';
> END;
> ' LANGUAGE plpgsql;
>
> # ERROR: language "plpgsql" does not exist
Do
CREATE FUNCTION plpgsql_call_handler () RETURNS language_handler
AS '/usr/local/pgsql/lib/plpgsql.so', 'plpgsql_call_handler'
LANGUAGE c;
CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler;
>
>
> any help appreciated
>
>
> __________________________________
> Do you Yahoo!?
> The New Yahoo! Search - Faster. Easier. Bingo.
> http://search.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
>
--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: language "plpgsql" does not exist
@ 2003-05-24 00:43 PeterKorman <calvin-pgsql-ml@eigenvision.com>
parent: Bruce Young <hbrucey@yahoo.com>
1 sibling, 0 replies; 13+ messages in thread
From: PeterKorman @ 2003-05-24 00:43 UTC (permalink / raw)
To: pgsql-sql; +Cc: Bruce Young <hbrucey@yahoo.com>
On Fri, May 23, 2003 at 06:40:04AM -0700, Bruce Young wrote:
> Whoa! thanks a lot guys. didnt RTFM enough.
> i now got it working from the following command:
>
> $ createlang plpgsql <dbname>
>
> Question is: why did it prompt me to enter my password so many times? 4 to be
> exact.
> i only have one user besides postgres.
>
> thanks again.
>
I'm 3 days into postgresql so dont chisel this answer into stone.
I just went through a hunt for this. If you want the plpgsql language to
show up in all your databases then connect to template1
and do the work within the psql client. I don't see any way to use
createlang on template1. But that will save you doing it on
all your databases.
There must be some overhead on this onaccounta it is not part
of template1 to begin with. Odd.
Apparently there are a multitude of possible languages you
can install. PL/Perl, PL/TCL ..., Etc.
Cheers,
JPK
^ permalink raw reply [nested|flat] 13+ messages in thread
* Re: language "plpgsql" does not exist
@ 2003-05-24 04:44 A.Bhuvaneswaran <bhuvan@symonds.net>
parent: Bruce Young <hbrucey@yahoo.com>
1 sibling, 0 replies; 13+ messages in thread
From: A.Bhuvaneswaran @ 2003-05-24 04:44 UTC (permalink / raw)
To: Bruce Young <hbrucey@yahoo.com>; +Cc: pgsql-sql
> Question is: why did it prompt me to enter my password so many times? 4 to be
> exact.
> i only have one user besides postgres.
Run your command with -e option and would answer your query -:)
regards,
bhuvaneswaran
^ permalink raw reply [nested|flat] 13+ messages in thread
end of thread, other threads:[~2003-05-24 04:44 UTC | newest]
Thread overview: 13+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-05-23 06:48 language "plpgsql" does not exist Bruce Young <hbrucey@yahoo.com>
2003-05-23 09:43 ` Devrim GUNDUZ <devrim@gunduz.org>
2003-05-23 10:26 ` Richard Huxton <dev@archonet.com>
2003-05-23 11:10 ` Rod Taylor <rbt@rbt.ca>
2003-05-23 11:18 ` Oliver Elphick <olly@lfix.co.uk>
2003-05-23 11:32 ` Victor Yegorov <viktors.jegorovs@nordlb.lv>
2003-05-23 13:40 ` Bruce Young <hbrucey@yahoo.com>
2003-05-24 00:43 ` PeterKorman <calvin-pgsql-ml@eigenvision.com>
2003-05-24 04:44 ` A.Bhuvaneswaran <bhuvan@symonds.net>
2003-05-23 12:27 ` A.Bhuvaneswaran <bhuvan@symonds.net>
2003-05-23 15:43 ` Achilleus Mantzios <achill@matrix.gatewaynet.com>
2003-05-23 09:45 Re: language "plpgsql" does not exist David Witham <davidw@unidial.com.au>
2003-05-23 11:28 Re: language "plpgsql" does not exist Christoph Haller <ch@rodos.fzk.de>
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