Greetings List,
I am working on converting a large set of code from a commercial 4gl known as
Progress to plpgsql. This code defines a rating system for a transportation
logistics package. In the Progress world, one is able to prompt the user for
input during the execution of a trigger or a fun
In reply to my own question, and to pose a possible solution, and to query the
list as to whether anybody thinks I'm on the right track, would the following
excerpt from the documentation be a way of addressing this?
27.9. Notice Processing
Notice and warning messages generated by the server ar
Terry Lee Tucker <[EMAIL PROTECTED]> writes:
> Is there any way to gather input from a user while in the
> middle of a transaction from a plpgsql function?
Hmm ... RAISE NOTICE to send out the prompt, and then COPY from some
pre-agreed file to collect the result? (COPY FROM STDIN would be nicer
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.
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 fo
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 rec
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