From: Robby Russell Date: 2005-10-07T07:34:06+09:00 Subject: Re: PL/Ruby segfaults On Fri, 2005-10-07 at 07:26 +0900, Jeremy Henty wrote: > In article <200510060849.j968nkXN028275@moulon.inra.fr>, ts wrote: > >>>>>> "J" == Jeremy Henty writes: > > > >J> I specifically want a FOR EACH STATEMENT trigger . > > > > [snip patch] > > /me dances a little jig - it works! Thanks again for your help. BUT > .... I'd like the trigger to "require" a Ruby library and I get "ERROR: > Insecure operation - require". How do I workaround this? Even > "require"-ing the library while connected to Postgres as the postgres > user doesn't work! Or maybe there's a way to "require" the library at > startup? > > Cheers, > > Jeremy Henty > Wait! That is an insecure operation! You can do this however. http://rubyurl.com/t3S Just be warned that it is *insecure* to some degree... Don't run PostgreSQL as root. ;-) Robby -- /****************************************************** * Robby Russell, Owner.Developer.Geek * PLANET ARGON, Open Source Solutions & Web Hosting * Portland, Oregon | p: 503.351.4730 | f: 815.642.4068 * www.planetargon.com | www.robbyonrails.com * Programming Rails | www.programmingrails.com *******************************************************/