Re: Prompt User From a pgplsql Function

Поиск
Список
Период
Сортировка
От Terry Lee Tucker
Тема Re: Prompt User From a pgplsql Function
Дата
Msg-id 200501291408.53924.terry@esc1.com
обсуждение исходный текст
Ответ на Re: Prompt User From a pgplsql Function  (Ragnar Hafstað <gnari@simnet.is>)
Список pgsql-general
Well, I haven't tried it yet, but I don't believe it will. It will be the same
connection in the same transaction. In other triggers, I've done something
similiar by inserting a record into a special table called "override" and
have other triggers that fire in the same transaction look for a record in
that table in order to make a decision about what course of action to take.
All the other triggers are able to see the record. I don't see this as being
any different. After I try it, I'll let you know.

Thanks for the input...

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

В списке pgsql-general по дате отправления:

Предыдущее
От: Mike Rylander
Дата:
Сообщение: Re: Splitting queries across servers
Следующее
От: "Max"
Дата:
Сообщение: Re: Splitting queries across servers