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@xxxxxxxxxxxxx> wrote:
Kiran <bangalore.kiran@xxxxxxxxx> 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