Prompt User From a pgplsql Function

From: Terry Lee Tucker <terry(at)esc1(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Prompt User From a pgplsql Function
Date: 2005-01-29 12:34:01
Message-ID: 200501290734.01262.terry@esc1.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 function, right in the middle of
a transaction. During the rating process, I have a couple of situations where
I need to prompt the user for a value that lies within an acceptable range
defined in the rating matrix. The front end to this application is X-Windows
written in C. All this rating (termed AutoRating) desperately needs to be
accomplished in plpgsql due to the complexity of the record look up and
record inserts. Is there any way to gather input from a user while in the
middle of a transaction from a plpgsql function? I think the answer is no;
but, maybe some you wizards have worked this magic before, or maybe, I've
been working at this way too long and have missed the obvious.

Any input and/or advice would be greatly appreciated.

Thanks...
--

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Terry Lee Tucker 2005-01-29 14:45:29 Re: Prompt User From a pgplsql Function
Previous Message Bruno Wolff III 2005-01-29 11:45:00 Re: MySQL worm attacks Windows servers