pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhow to do plpgsql?
4+ messages / 3 participants
[nested] [flat]
* how to do plpgsql?
@ 2001-02-07 00:57 Joseph Shraibman <jks@selectacast.net>
0 siblings, 1 reply; 4+ messages in thread
From: Joseph Shraibman @ 2001-02-07 00:57 UTC (permalink / raw)
To: pgsql-sql
When trying to do some of the examples on
http://www.postgresql.org/docs/postgres/c40914344.htm
I keep getting:
ERROR: Unrecognized language specified in a CREATE FUNCTION:
'plpgsql'. Recognized languages are sql, C, internal and the created
procedural languages.
version is:
PostgreSQL 7.0.3 on i686-pc-linux-gnu, compiled by gcc egcs-2.91.66
--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://www.targabot.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: how to do plpgsql?
@ 2001-02-07 01:04 Josh Berkus <josh@agliodbs.com>
parent: Joseph Shraibman <jks@selectacast.net>
0 siblings, 1 reply; 4+ messages in thread
From: Josh Berkus @ 2001-02-07 01:04 UTC (permalink / raw)
To: pgsql-sql
Joseph,
First you need to install plpgsql on a per database
basis, or you can just install it on template1 and it
will get added to all new databases.
CREATE FUNCTION "plpgsql_call_handler" ( ) RETURNS opaque AS
'/usr/lib/pgsql/plpgsql.so' LANGUAGE 'C';
CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER
"plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
-Josh Berkus
(Instructions courtesy of Jeff at PGSQL Inc.)
--
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: how to do plpgsql?
@ 2001-02-07 01:18 Joseph Shraibman <jks@selectacast.net>
parent: Josh Berkus <josh@agliodbs.com>
0 siblings, 1 reply; 4+ messages in thread
From: Joseph Shraibman @ 2001-02-07 01:18 UTC (permalink / raw)
To: josh@agliodbs.com; +Cc: pgsql-sql
Huh. You'd think this would be prominent in the documentation page at
http://www.postgresql.org/docs/postgres/c4091.htm
Thanks.
Josh Berkus wrote:
>
> Joseph,
>
> First you need to install plpgsql on a per database
> basis, or you can just install it on template1 and it
> will get added to all new databases.
>
> CREATE FUNCTION "plpgsql_call_handler" ( ) RETURNS opaque AS
> '/usr/lib/pgsql/plpgsql.so' LANGUAGE 'C';
>
> CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql' HANDLER
> "plpgsql_call_handler" LANCOMPILER 'PL/pgSQL';
>
> -Josh Berkus
>
> (Instructions courtesy of Jeff at PGSQL Inc.)
> --
> ______AGLIO DATABASE SOLUTIONS___________________________
> Josh Berkus
> Complete information technology josh@agliodbs.com
> and data management solutions (415) 565-7293
> for law firms, small businesses fax 621-2533
> and non-profit organizations. San Francisco
--
Joseph Shraibman
jks@selectacast.net
Increase signal to noise ratio. http://www.targabot.com
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: how to do plpgsql?
@ 2001-02-07 03:53 Christopher Sawtell <csawtell@xtra.co.nz>
parent: Joseph Shraibman <jks@selectacast.net>
0 siblings, 0 replies; 4+ messages in thread
From: Christopher Sawtell @ 2001-02-07 03:53 UTC (permalink / raw)
To: Joseph Shraibman <jks@selectacast.net>; josh@agliodbs.com; +Cc: pgsql-sql
On Wed, 07 Feb 2001 14:18, Joseph Shraibman wrote:
> Huh. You'd think this would be prominent in the documentation page at
> http://www.postgresql.org/docs/postgres/c4091.htm
Thanks from me for that one too.
What about incorporating that particular functionality into the initdb
program. Strikes me that this should be available by default as part of
the installed product.
On the other hand I might be missing something, if so I'd like to be
informed. Thanks.
--
Sincerely etc.,
NAME Christopher Sawtell
CELL PHONE 021 257 4451
ICQ UIN 45863470
EMAIL csawtell @ xtra . co . nz
CNOTES ftp://ftp.funet.fi/pub/languages/C/tutorials/sawtell_C.tar.gz
->> Please refrain from using HTML or WORD attachments in e-mails to me <<-
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2001-02-07 03:53 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-07 00:57 how to do plpgsql? Joseph Shraibman <jks@selectacast.net>
2001-02-07 01:04 ` Josh Berkus <josh@agliodbs.com>
2001-02-07 01:18 ` Joseph Shraibman <jks@selectacast.net>
2001-02-07 03:53 ` Christopher Sawtell <csawtell@xtra.co.nz>
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