[GENERAL] Question about stored procedures

2005-10-13 Thread Josephine E. de Castro
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.. I dont know whether I can do this using PL/pgSQL or do i need to use another method.

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.. I

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.. I dont

Re: [GENERAL] Question about stored procedures

2005-10-13 Thread Josephine E. de Castro
HiSean! 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? Anyway, my

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 with

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

2005-10-13 Thread Patrick FICHE
: [GENERAL] Question about stored procedures HiSean! 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

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

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 on