Re: Trigger is not working for Inserts from the application

On 09/10/2016 02:02 PM, Kiran wrote:
> Hi Tom,
>
> I have checked and the trigger is not disabled.
>
> and \drds results
> Role=blank
> database = mydatabase
> settings = default_text_search_config=pg_catalog.swedish
>
> Any other tips or suggestions please.

Did you see this post?:

https://www.postgresql.org/message-id/10840.1473539270%40sss.pgh.pa.us

>
> regards
> Kiran
>
>
>
> On Sat, Sep 10, 2016 at 9:26 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us
> <mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us>> wrote:
>
> Kiran <bangalore(dot)kiran(at)gmail(dot)com <mailto: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
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com