On Fri, 2005-10-07 at 07:26 +0900, Jeremy Henty wrote:
> In article <200510060849.j968nkXN028275 / moulon.inra.fr>, ts wrote:
> >>>>>> "J" == Jeremy Henty <jeremy / chaos.org.uk> 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
*******************************************************/