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 <t...@sss.pgh.pa.us
<mailto:t...@sss.pgh.pa.us>> wrote:

    Kiran <bangalore.ki...@gmail.com <mailto:bangalore.ki...@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




--
Adrian Klaver
adrian.kla...@aklaver.com


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to