Hi everyone.

I'm working in Windows with PostgreSQL, and I have created a simple C
function in a DLL, which contains only the line:

           system("C:/windows/notepad.exe")

I have successfully created a function in my db, and linked it to the
DLL function.

However, when I execute, in pgAdminIII and psql (and other clients):

    SELECT <functionname>()

the program freezes!

The "Task Manager" shows that Windows is effectively executing
"notepad.exe" for user "postgres": if I shut down Notepad with "Task
Manager", the client works fine.

It seems that PostgreSQL for Windows locks the interaction with the
user... because launching non-interactive programs works well.

Any ideas?
Thanks
P.86