Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE
Дата
Msg-id 370b84e1-c6eb-4f43-f90d-10f1a7a4d332@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE  (Vik Fearing <vik@2ndquadrant.fr>)
Ответы Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE  (Vik Fearing <vik@2ndquadrant.fr>)
Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE  (Peter van Hardenberg <pvh@pvh.ca>)
Список pgsql-hackers
Дерево обсуждения 
On 7/26/16 6:14 PM, Vik Fearing wrote:
> As mentioned elsewhere in the thread, you can just do WHERE true to get
> around it, so why on Earth have it PGC_SUSET?

I'm not sure whether it's supposed to guard against typos and possibly
buggy SQL string concatenation in application code.  So it would help
against accidental mistakes, whereas putting a WHERE TRUE in there would
be an intentional override.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

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

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: Proposal: revert behavior of IS NULL on row types
Следующее
От: Vik Fearing
Дата:
Сообщение: Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE