The long-running work will be a command without data transfer to the server , that needs to continue processing the command after the client close the conection/program .
This function of send a command to the server is for apply correction patchs in the database.
Thanks again,
Thiago
2010/9/8 Craig Ringer
<craig@postnewspapers.com.au>On 8/09/2010 8:01 PM, Thiago Godoi wrote:
Hello guys,
I'm doing a program that will send a command to the database but the
execution of this command spends a lot of time and client probably will
close the java program .
The problem is that I need the command continue running after the client
close the program.
I'd want something running server-side to handle this. LISTEN / NOTIFY can be a good way of waking the server-side helper and telling it that it has work to do.
It might help if you explained in more detail what this long-running work is. Is it critical to data integrity or security? Does it produce a lot of data that must be sent to the server, or is it processing that's done on existing data the server already has? etc.
--
Craig Ringer
Tech-related writing at http://soapyfrogs.blogspot.com/
--
Thiago Godoi
Ec07