No need to worry about visibility problems. Trying to insert a record from the notify receiver sends the application into a tail spin that ends in a core dump. It won't work. I guess there is nothing to do but write all this crap in C. I can prompt the user easy enough, but I can't get anything back to the server. Back to the drawing board :o/
On Saturday 29 January 2005 02:00 pm, Ragnar Hafstaà saith: > On Sat, 2005-01-29 at 13:21 -0500, Terry Lee Tucker wrote: > > [on prompting user in the middle of a transaction] > > > Thanks for the reply, Tom. I just had an idea about writting the answer > > from the client to a table designed for that purpose. It could have a > > unique key as the pid and a column for storing the answer. When the > > notice receiver returns, I could have the function check for the answer > > in the table. I have successfully created my own notice receiver and it > > works. > > won't there be visibility problems with this ? > > gnari > > > > > ---------------------------(end of broadcast)--------------------------- > TIP 5: Have you checked our extensive FAQ? > > http://www.postgresql.org/docs/faq -- ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
