Re: INSERT or UPDATE TRIGGER

Поиск
Список
Период
Сортировка
От James B. Byrne
Тема Re: INSERT or UPDATE TRIGGER
Дата
Msg-id 49017.216.185.71.24.1239133921.squirrel@webmail.harte-lyne.ca
обсуждение исходный текст
Ответ на Re: INSERT or UPDATE TRIGGER  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: INSERT or UPDATE TRIGGER  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
On Tue, April 7, 2009 15:09, Tom Lane wrote:

>
> ALTER DATABASE foo SET log_min_messages = whatever;
>
> Note this will only affect subsequently-started sessions.  Also,
> if memory serves, you have to be superuser to set this particular
> variable.

Thanks.  Am I correct to infer from the output this generates that
log_min_messages = debug is primarily for developers of PG itself?
I am poking in the dark here.  What I want to do is to determine if
the trigger is firing and whether the function works as intended.
At the moment I am not seeing anything show up in the secondary
table so I have done something wrong.  Is there some way of getting
PG to tell me what it is doing?

--
***          E-Mail is NOT a SECURE channel          ***
James B. Byrne                mailto:ByrneJB@Harte-Lyne.ca
Harte & Lyne Limited          http://www.harte-lyne.ca
9 Brockley Drive              vox: +1 905 561 1241
Hamilton, Ontario             fax: +1 905 561 0757
Canada  L8E 3C3


В списке pgsql-general по дате отправления:

Предыдущее
От: "Kevin Grittner"
Дата:
Сообщение: Re: tsearch2 dictionary for statute cites
Следующее
От: Cha Yang
Дата:
Сообщение: tables filled to 1 Gig each