pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
how to do plpgsql?
4+ messages / 3 participants
[nested] [flat]

* how to do plpgsql?
@ 2001-02-07 00:57 Joseph Shraibman <jks@selectacast.net>
  2001-02-07 01:04 ` Re: how to do plpgsql? Josh Berkus <josh@agliodbs.com>
  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 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   ` Re: how to do plpgsql? 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 00:57 how to do plpgsql? Joseph Shraibman <jks@selectacast.net>
  2001-02-07 01:04 ` Re: how to do plpgsql? Josh Berkus <josh@agliodbs.com>
@ 2001-02-07 01:18   ` Joseph Shraibman <jks@selectacast.net>
  2001-02-07 03:53     ` Re: how to do plpgsql? Christopher Sawtell <csawtell@xtra.co.nz>
  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 00:57 how to do plpgsql? Joseph Shraibman <jks@selectacast.net>
  2001-02-07 01:04 ` Re: how to do plpgsql? Josh Berkus <josh@agliodbs.com>
  2001-02-07 01:18   ` Re: how to do plpgsql? Joseph Shraibman <jks@selectacast.net>
@ 2001-02-07 03:53     ` Christopher Sawtell <csawtell@xtra.co.nz>
  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