Re: [GENERAL] C vs plpgsql and child processes

2003-08-18 Thread Jason Godden
Hi Jan/Sean To the list I bow and apologise for wasting your time! I did not appropriately test the function (as is my want!) and passed command line arguments in the executable image path in the execl function. Now I edit my table containing the configuration vars for the trackformat to deco

Re: [GENERAL] C vs plpgsql and child processes

2003-08-18 Thread Jan Wieck
Jason Godden wrote: Hi Sean, Yeah - It is declared VOLATILE. I think there must be something specific with the way PL/PGSQL handles child processes of a called function. The child process actually spawns mpg123 or ogg123 so it has to live beyond the life of the parent. Not sure. What I migh

Re: [GENERAL] C vs plpgsql and child processes

2003-08-18 Thread Jason Godden
Hi Sean, Yeah - It is declared VOLATILE. I think there must be something specific with the way PL/PGSQL handles child processes of a called function. The child process actually spawns mpg123 or ogg123 so it has to live beyond the life of the parent. Not sure. What I might do is rewrite the