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@xxxxxxxxxxxxx <mailto:tgl@xxxxxxxxxxxxx>> wrote: Kiran <bangalore.kiran@xxxxxxxxx <mailto: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
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
