Re: Prompt User From a pgplsql Function

From: Ragnar Hafstað <gnari(at)simnet(dot)is>
To: Terry Lee Tucker <terry(at)esc1(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Prompt User From a pgplsql Function
Date: 2005-01-29 19:00:54
Message-ID: 1107025254.27081.10.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Rylander 2005-01-29 19:00:58 Re: Splitting queries across servers
Previous Message Andrey V. Semyonov 2005-01-29 18:45:03 Re: Allowing update of column only from trigger