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
>
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 |