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

Problem solved.

Thanks.