| От | Craig Ringer |
|---|---|
| Тема | WIP patch for updatable security barrier views |
| Дата | |
| Msg-id | 528E0770.4090001@2ndquadrant.com обсуждение исходный текст |
| Ответы |
Re: WIP patch for updatable security barrier views
|
| Список | pgsql-hackers |
Hi all I have updatable security barrier views working for INSERT and DELETE, so this might be a good chance to see whether the described approach is acceptable in reality, not just in theory. I've been surprised by how well it worked out. I actually landed up removing a lot of the existing updatable views code; once update knows how to operate on a subquery it becomes unnecessary to duplicate the optimiser's knowledge of how to expand and flatten a view in the rewriter. INSERT and DELETE work. I haven't tested INSERT with defaults on the base rel yet but suspect it'll need the same support as for update. UPDATE isn't yet supported because of the need to inject references to cols in the base rel that aren't selected in the view. expand_targetlist(...) in prep/preptlist.c already does most of this work so I hope to be able to use or adapt that. This patch isn't subject to the replanning and invalidation issues discussed for RLS because updatable s.b. views don't depend on the current user or some special "bypass RLS" right like RLS would. The regression tests die because they try to update an updatable view. This isn't proposed for inclusion as it stands, it's a chance to comment and say "why the heck would you do that". -- Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-hackers по дате отправления:
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера