Re: plpgsql.warn_shadow

Поиск
Список
Период
Сортировка
От Florian Pflug
Тема Re: plpgsql.warn_shadow
Дата
Msg-id 4A6E8741-F62E-4636-8366-291D8BE50CBC@phlo.org
обсуждение исходный текст
Ответ на Re: plpgsql.warn_shadow  (Marko Tiikkaja <marko@joh.to>)
Ответы Re: plpgsql.warn_shadow  (Marko Tiikkaja <marko@joh.to>)
Список pgsql-hackers
On Jan15, 2014, at 13:32 , Marko Tiikkaja <marko@joh.to> wrote:
> On 1/15/14 1:23 PM, Florian Pflug wrote:
>> The fact that it's named plpgsql.warnings already clearly documents that this only affects plpgsql. But whether a
particularwarning is emitted during compilation or during execution it largely irrelevant, I think. For example, if we
calledthis compiler_warning, we'd couldn't add a warning which triggers when SELECT .. INTO ingores excessive rows. 
>
> There is the fact that something being a "compiler warning" gives you an idea on its effects on performance.  But
maybethat would be better described in the documentation (perhaps even more accurately). 
>
> I like the idea of warning about SELECT .. INTO, though, but that one could have a non-negligible performance penalty
duringexecution. 

I'm not overly concerned about that. I image people would usually enable warnings during development, not production.

best regards,
Florian Pflug




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

Предыдущее
От: Ashutosh Bapat
Дата:
Сообщение: Re: identify table oid for an AggState during plan tree initialization
Следующее
От: Marko Tiikkaja
Дата:
Сообщение: Re: plpgsql.warn_shadow