Re: Trigger is not working for Inserts from the application

Kiran <bangalore.kiran@gmail.com> writes:
> But I do not know how to check whether the application is subject to
> different ALTER USER .... SET parameters.

psql's \drds ("display role/database SETs") would help.

BTW, have you checked that the trigger is not disabled, and that there
isn't another trigger undoing its work?  (psql's \d command on the table
should show these things.)

            regards, tom lane