Re: Trigger is not working for Inserts from the application

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kiran <bangalore(dot)kiran(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Trigger is not working for Inserts from the application
Date: 2016-09-10 19:26:03
Message-ID: 8710.1473535563@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Kiran <bangalore(dot)kiran(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Kiran 2016-09-10 20:15:22 Re: Trigger is not working for Inserts from the application
Previous Message Adrian Klaver 2016-09-10 19:08:36 Re: Trigger is not working for Inserts from the application