Re: interesting trigger behaviour in 8.3

Поиск
Список
Период
Сортировка
От Csaba Nagy
Тема Re: interesting trigger behaviour in 8.3
Дата
Msg-id 1217345602.666.108.camel@PCD12478
обсуждение исходный текст
Ответ на interesting trigger behaviour in 8.3  ("Ivan Zolotukhin" <ivan.zolotukhin@gmail.com>)
Список pgsql-general
On Tue, 2008-07-29 at 19:25 +0400, Ivan Zolotukhin wrote:
> Any clues? Can anybody suggest how to debug this? Is it possible to
> get an explain of the query within the trigger?

I bet it's the difference between prepared/not prepared plans. The
trigger prepares the plan without considering the actual parameter
values, on the psql prompt you give the parameter values explicitly in
the sql. Try to use the PREPARE command to prepare the plan on the psql
prompt, and EXPLAIN EXECUTE it to see how it works in the trigger...

Cheers,
Csaba.



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