Re: [GENERAL] Question about stored procedures

2005-10-13 Thread Andrew Sullivan
On Thu, Oct 13, 2005 at 03:00:32PM +0200, Stephane Bortzmeyer wrote: > Note that a common trick, when you want to do X and you cannot do it > directly from PostgreSQL (or are unwilling to force the sysadmin to > install stuff like plWhatever - for instance, I was never able to make > plPython run o

Re: [GENERAL] Question about stored procedures

2005-10-13 Thread Stephane Bortzmeyer
On Thu, Oct 13, 2005 at 04:20:39AM -0700, Josephine E. de Castro <[EMAIL PROTECTED]> wrote a message of 49 lines which said: > Is there no 'trusted' way of doing this? By definition, certainly not. A "trusted" procedure can be installed by an ordinary user so it MUST NOT play outside of the s

Re: [SPAM] Re: [GENERAL] Question about stored procedures

2005-10-13 Thread Patrick FICHE
: [GENERAL] Question about stored procedures Hi Sean!  Thanks for your reply. :)   My knowledge of PL/Perl is limited and confined to knowing that such language exist.    Is there no 'trusted' way of doing this? How about creating a trigger using C? Or should i

Re: [GENERAL] Question about stored procedures

2005-10-13 Thread Josephine E. de Castro
Thanks Andreas!   I will try yours and Sean's suggestions and see where it will take me! :)   I've got some learning to do and I'm really grateful for the replies that I got from this group!   Again, my utmost gratitude!   :) "A. Kretschmer" <[EMAIL PROTECTED]> wrote: PL/pgsql i a trusted language

Re: [GENERAL] Question about stored procedures

2005-10-13 Thread Josephine E. de Castro
Hi Sean!  Thanks for your reply. :)   My knowledge of PL/Perl is limited and confined to knowing that such language exist.    Is there no 'trusted' way of doing this? How about creating a trigger using C? Or should i stick with something like PL/pgSQL and look for its 'untrusted' flavors?   Anywa

Re: [GENERAL] Question about stored procedures

2005-10-13 Thread Sean Davis
On 10/13/05 6:36 AM, "Josephine E. de Castro" <[EMAIL PROTECTED]> wrote: > Hi everyone, > > I just want to know if there is an equivalent method in PostgreSQL that acts > like SQL Server's extended stored procedure. I want to run a stored procedure > that can update a file in the file system..

Re: [GENERAL] Question about stored procedures

2005-10-13 Thread A. Kretschmer
am 13.10.2005, um 3:36:19 -0700 mailte Josephine E. de Castro folgendes: > Hi everyone, > > I just want to know if there is an equivalent method in PostgreSQL > that acts like SQL Server's extended stored procedure. I want to run a > stored procedure that can update a file in the file system.