Re: PL argument max size, and doubt

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: PL argument max size, and doubt
Дата
Msg-id 23159.1195800021@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: PL argument max size, and doubt  (Martin Marques <martin@marquesminen.com.ar>)
Ответы Re: PL argument max size, and doubt
Список pgsql-sql
Martin Marques <martin@marquesminen.com.ar> writes:
> Tom Lane escribió:
>> Martin Marques <martin@marquesminen.com.ar> writes:
>>> I have always heard that modification queries should be EXECUTED in PL. 
>>> AFAICR.
>> 
>> Run far away from whatever source gave you that advice...

> Sorry, it was with DDL commands.

That's not much better ;-).  DDL commands don't have plans, so there's
not anything that could be invalidated.  I don't see any reason to use
an EXECUTE unless there's an actual textual change in the command you
need to execute.
        regards, tom lane


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

Предыдущее
От: Martin Marques
Дата:
Сообщение: Re: PL argument max size, and doubt
Следующее
От: "Sabin Coanda"
Дата:
Сообщение: Aleatory exception