Received: from mail1.waterford.org (mail1.waterford.org [205.124.117.6]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9IKL5P36085 for ; Thu, 18 Oct 2001 16:21:05 -0400 (EDT) (envelope-from olebedev@waterford.org) Received: from waterford.org ([205.124.138.93]) by mail1.waterford.org (Netscape Messaging Server 3.56) with ESMTP id 409; Thu, 18 Oct 2001 14:11:12 -0600 Message-ID: <3BCF3E20.C010E402@waterford.org> Date: Thu, 18 Oct 2001 14:40:00 -0600 From: Oleg Lebedev X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; U) X-Accept-Language: en MIME-Version: 1.0 To: Dmitry Morozovsky , Postgres SQL Mailing List Subject: Re: [ADMIN] update in rule References: <20011018213918.W92267-100000@woozle.rinet.ru> Content-Type: text/plain; charset=koi8-r Content-Transfer-Encoding: 7bit X-Archive-Number: 200110/261 X-Sequence-Number: 5215 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