Re: Prompt User From a pgplsql Function

Terry Lee Tucker <terry(at)esc1(dot)com> 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
but it doesn't work inside plpgsql, and probably can't be made to work
without breaking the FE/BE protocol.) Seems messy and insecure,
not to mention it requires the client code to be on the same machine
as the database. I think you'd be better off spending the time to
restructure your functions, instead.

If you were using one of the untrusted languages (plperlu etc) it might
be possible to create a temporary side communication channel to talk to
the client code, but that seems pretty messy as well.

regards, tom lane