Re: Trigger is not working for Inserts from the application

From: Kiran <bangalore(dot)kiran(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 21:02:56
Message-ID: CAJfd1U7znGB8tCMqDH+DZug8i_EK6KaPHb22wc6KE28pipn7Xw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

regards
Kiran

On Sat, Sep 10, 2016 at 9:26 PM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> 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 Adrian Klaver 2016-09-10 21:05:23 Re: Trigger is not working for Inserts from the application
Previous Message Tom Lane 2016-09-10 20:27:50 Re: Trigger is not working for Inserts from the application