Re: Prompt User From a pgplsql Function

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

--