I am developing an Information Management System. I am using PgAccess(0.98.5) as
front end. The backend is PostgreSQL-6.5.2 and OS is Red Hat Linux 6.1, on
Intel P-II 350 MHz connected with LAN. I have installed them using RPM of
Linux. I have learned some of the Tcl and Tk for programming.
Message to Front End :
I need to show confirmation message to front end, eg. "Record with name = name inserted." after the record is inserted. How can I do it?
I am using PgAccess as Front End. I had written some triggers using plpgsql and pltcl. Now, after inserting a record in table, I want to use an AFTER INSERT trigger to send message to front end as "Record is inserted with Name=New.name." or similar. But except Error messages (with RAISE EXCEPTION or elog ERROR ), no message comes to front end. But if EXCEPTION or ERROR is used, the operation is aborted. If I use elog NOTICE then it also comes as an ERROR message to the front end.
If I work on PgSQL monitor (psql) , I can get NOTICE message that confirms the operation and does not go to ABORT state. But how to get message I like to front end (PgAccess) from AFTER INSERT OR UPDATE Triggers?
Is there any better way ? Is there any way ?
Sincerely yours,
Jigishu Bhatt