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 --- [EMAIL PROTECTED] *** ------------------------------------------------------------------------ ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
