[GENERAL] Messages to Front End

[Jigishu P Bhatt]

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