pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Oleg Lebedev <olebedev@waterford.org>
To: Dmitry Morozovsky <marck@rinet.ru>
To: Postgres SQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: [ADMIN] update in rule
Date: Thu, 18 Oct 2001 14:40:00 -0600
Message-ID: <3BCF3E20.C010E402@waterford.org> (raw)
References: <20011018213918.W92267-100000@woozle.rinet.ru>

You can use the following to install plpgsql:

CREATE FUNCTION plpgsql_call_handler () RETURNS OPAQUE AS
'/usr/local/pgsql/lib/plpgsql.so' LANGUAGE 'C';

CREATE TRUSTED PROCEDURAL LANGUAGE 'plpgsql'
        HANDLER plpgsql_call_handler
        LANCOMPILER 'PL/pgSQL';

I assume that you have default installation of postgres, otherwise change the
path in the second line.

good luck

Oleg

Dmitry Morozovsky wrote:

> On Wed, 17 Oct 2001, Stephan Szabo wrote:
>
> SS> Use a trigger instead, something like
> SS>
> SS> create function adresses_trigger() returns opaque as '
> SS> begin
> SS>  NEW.date_maj := now();
> SS>  return NEW;
> SS> end;' language 'plpgsql';
>
> hmm. it seems defaul pgsql installation does not contains definition for
> plpgsql language:
>
> test=# select * from pg_language ;
>  lanname  | lanispl | lanpltrusted | lanplcallfoid | lancompiler
> ----------+---------+--------------+---------------+-------------
>  internal | f       | f            |             0 | n/a
>  C        | f       | f            |             0 | /bin/cc
>  sql      | f       | f            |             0 | postgres
> (3 rows)
>
> however, plpgsql.so is in pgsql lib directory (though it is *NOT* visible
> by ldconfig -r)
>
> My installation is 7.1.3 under FreeBSD 4-stable. Is it somehow my fault or
> does it need to manually do something like
>
> create function plpgsql_handler() ...
> create language 'plpgsql' ...
>
> ? Please give me advise how exactly should these statements look?
>
> Sincerely,
> D.Marck                                   [DM5020, DM268-RIPE, DM3-RIPN]
> ------------------------------------------------------------------------
> *** Dmitry Morozovsky --- D.Marck --- Wild Woozle --- marck@rinet.ru ***
> ------------------------------------------------------------------------
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org




view thread (8+ messages)  latest in thread

Message-ID: <3BCF3E20.C010E402@waterford.org>
Permalink:  ../3BCF3E20.C010E402@waterford.org/
Also on:    postgresql.org/message-id/3BCF3E20.C010E402@waterford.org

 · 

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: olebedev@waterford.org, marck@rinet.ru
  Subject: Re: [ADMIN] update in rule
  In-Reply-To: <3BCF3E20.C010E402@waterford.org>

* 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