Обсуждение: Triggers operations and log_statement = all not working?

Поиск
Список
Период
Сортировка

Triggers operations and log_statement = all not working?

От
Edson Richter
Дата:
Hi!

I'm debugging few triggers I wrote these days, and I can't see the
triggers statements being logged.
Probably I'm doing something wrong.

I just enabled

log_statement = 'all'

In postgresql.conf, but I can see all statements issued by my
application, but the statements in trigger don't show up.
Is there anything else I need to do to see all trigger statements, or my
triggers are just not being called?

Thanks,


Re: Triggers operations and log_statement = all not working?

От
Edson Richter
Дата:
Em 16/01/2013 13:56, Edson Richter escreveu:
> Hi!
>
> I'm debugging few triggers I wrote these days, and I can't see the
> triggers statements being logged.
> Probably I'm doing something wrong.
>
> I just enabled
>
> log_statement = 'all'
>
> In postgresql.conf, but I can see all statements issued by my
> application, but the statements in trigger don't show up.
> Is there anything else I need to do to see all trigger statements, or
> my triggers are just not being called?
>
> Thanks,
>
>
Don't get bored - I just discovered how to enable plsql debugging in
PgAdmin!

Thanks,

Edson