Search Postgresql Archives

Re: Trigger is not working for Inserts from the application

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux