Re: Prompt User From a pgplsql Function - Mailing list pgsql-general

From Ragnar Hafstað
Subject Re: Prompt User From a pgplsql Function
Date
Msg-id 1107025254.27081.10.camel@localhost.localdomain
Whole thread Raw
In response to Re: Prompt User From a pgplsql Function  (Terry Lee Tucker <terry@esc1.com>)
Responses Re: Prompt User From a pgplsql Function  (Terry Lee Tucker <terry@esc1.com>)
Re: Prompt User From a pgplsql Function  (Terry Lee Tucker <terry@esc1.com>)
List pgsql-general
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




pgsql-general by date:

Previous
From: "Andrey V. Semyonov"
Date:
Subject: Re: Allowing update of column only from trigger
Next
From: Mike Rylander
Date:
Subject: Re: Splitting queries across servers