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

Поиск
Список
Период
Сортировка
От David Fetter
Тема PoC: Make it possible to disallow WHERE-less UPDATE and DELETE
Дата
Msg-id 20160721045746.GA25043@fetter.org
обсуждение исходный текст
Ответы Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE  (Amit Kapila <amit.kapila16@gmail.com>)
Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE  (Jim Mlodgenski <jimmy76@gmail.com>)
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  (Teodor Sigaev <teodor@sigaev.ru>)
Re: PoC: Make it possible to disallow WHERE-less UPDATE and DELETE  (Vik Fearing <vik@2ndquadrant.fr>)
Re: [HACKERS] PoC: Make it possible to disallow WHERE-less UPDATE and DELETE  (Pavel Stehule <pavel.stehule@gmail.com>)
Список pgsql-hackers
Дерево обсуждения 
Folks,

Please find attached a patch which makes it possible to disallow
UPDATEs and DELETEs which lack a WHERE clause.  As this changes query
behavior, I've made the new GUCs PGC_SUSET.

What say?

Thanks to Gurjeet Singh for the idea and Andrew Gierth for the tips
implementing.

Best,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778  AIM: dfetter666  Yahoo!: dfetter
Skype: davidfetter      XMPP: david(dot)fetter(at)gmail(dot)com

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate
Вложения

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: DROP OWNED BY ... CACADE & "could not open relation with OID" error
Следующее
От: Satoshi Nagayasu
Дата:
Сообщение: Re: DROP OWNED BY ... CACADE & "could not open relation with OID" error