>>>>> "B" == Bruce Momjian <pgman@candle.pha.pa.us> writes:

B> What function languages do triggers support?  C, plpgsql, pltcl, SQL?

 You can add plruby.

 Ruby is the interpreted scripting language for quick and easy
object-oriented programming. It has many features to process text files and
to do system management tasks (as in Perl). It is simple, straight-forward,
extensible, and portable.

 http://www.ruby-lang.org/en/

 plruby can be found at 

  http://www.ruby-lang.org/en/raa-list.rhtml?name=PL%2FRuby


Guy Decoux

Thu, 18 May 2000 06:25:08 +0200 (MET DST)
ts <decoux@moulon.inra.fr>
Re: Trigger function languages
ts wrote:
> 
> >>>>> "B" == Bruce Momjian <pgman@candle.pha.pa.us> writes:
> 
> B> What function languages do triggers support?  C, plpgsql, pltcl, SQL?
> 
>  You can add plruby.

How safe is plruby ?

Does it allow access to file system and other possibly unsafe resources ?

------------
Hannu

Thu, 18 May 2000 09:58:12 +0300
Hannu Krosing <hannu@tm.ee>
Re: Trigger function languages
>>>>> "H" == Hannu Krosing <hannu@tm.ee> writes:

H> How safe is plruby ?

 I'll say that ruby is more safe than perl.

 Ruby define 4 security levels :

/* safe-level:
   0 - strings from streams/environment/ARGV are tainted (default)
   1 - no dangerous operation by tainted string
   2 - process/file operations prohibited
   3 - all genetated strings are tainted
   4 - no global (non-tainted) variable modification/no direct output
*/

 You have a more complete description at :

  http://blade.nagaokaut.ac.jp/cgi-bin/scat.rb/ruby/ruby-talk/2689


 plruby, by default, is compiled with $SAFE >= 4

Guy Decoux


Thu, 18 May 2000 09:44:11 +0200 (MET DST)
ts <decoux@moulon.inra.fr>
Re: Trigger function languages