Received: from woozle.rinet.ru (woozle.rinet.ru [195.54.192.68]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f9IHnVP01035 for ; Thu, 18 Oct 2001 13:49:32 -0400 (EDT) (envelope-from marck@rinet.ru) Received: from localhost (marck@localhost) by woozle.rinet.ru (8.11.6/8.11.6) with ESMTP id f9IHnAf07637; Thu, 18 Oct 2001 21:49:14 +0400 (MSD) (envelope-from marck@rinet.ru) Date: Thu, 18 Oct 2001 21:49:09 +0400 (MSD) From: Dmitry Morozovsky To: Stephan Szabo cc: Nicolas KOWALSKI , Subject: Re: update in rule In-Reply-To: Message-ID: <20011018213918.W92267-100000@woozle.rinet.ru> X-NCC-RegID: ru.rinet MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Archive-Number: 200110/176 X-Sequence-Number: 2420 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 *** ------------------------------------------------------------------------