Re: Prompt User From a pgplsql Function

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