Re: docs: note ownership requirement for refreshing materializedviews
От
Michael Paquier
Тема
Re: docs: note ownership requirement for refreshing materializedviews
Дата
Msg-id
20180816011534.GK3681@paquier.xyz
Ответ на
Re: docs: note ownership requirement for refreshing materializedviews (Jonathan S. Katz)
Список
Дерево обсуждения
docs: note ownership requirement for refreshing materialized views Dian Fay <dian.m.fay@gmail.com>
Re: docs: note ownership requirement for refreshing materializedviews Michael Paquier <michael@paquier.xyz>
Re: docs: note ownership requirement for refreshing materializedviews Dian Fay <dian.m.fay@gmail.com>
Re: docs: note ownership requirement for refreshing materialized views Tom Lane <tgl@sss.pgh.pa.us>
Re: docs: note ownership requirement for refreshing materializedviews Dian Fay <dian.m.fay@gmail.com>
Re: docs: note ownership requirement for refreshing materializedviews Michael Paquier <michael@paquier.xyz>
Re: docs: note ownership requirement for refreshing materializedviews "Jonathan S. Katz" <jonathan.katz@excoventures.com>
Re: docs: note ownership requirement for refreshing materializedviews Michael Paquier <michael@paquier.xyz>
Re: docs: note ownership requirement for refreshing materializedviews "Jonathan S. Katz" <jonathan.katz@excoventures.com>
Re: docs: note ownership requirement for refreshing materializedviews "Jonathan S. Katz" <jonathan.katz@excoventures.com>
Re: docs: note ownership requirement for refreshing materialized views Dave Cramer <davecramer@gmail.com>
Re: docs: note ownership requirement for refreshing materializedviews Dian Fay <dian.m.fay@gmail.com>
Re: docs: note ownership requirement for refreshing materialized views Tom Lane <tgl@sss.pgh.pa.us>
Re: docs: note ownership requirement for refreshing materializedviews "Jonathan S. Katz" <jonathan.katz@excoventures.com>
Re: docs: note ownership requirement for refreshing materializedviews Michael Paquier <michael@paquier.xyz>
On Wed, Aug 15, 2018 at 09:06:34PM -0400, Jonathan S. Katz wrote: > I played around with this feature a bit and did see this was the case. > Also while playing around I noticed the error message was as such: > > test=> REFRESH MATERIALIZED VIEW blah; > ERROR: must be owner of relation blah > > But it’s not a relation, it’s a materialized view. I attached a patch > that I think should fix this. Kudos to Dave Cramer who was > sitting next to me helping me to locate files and confirm assumptions. A relation may be a materialized view, no? The ACL check happens in RangeVarCallbackOwnsTable by the way (look at ExecRefreshMatView in matview.c). -- Michael
В списке pgsql-hackers по дате отправления
От: Jonathan S. Katz
Дата:
От: Shinoda, Noriyoshi (PN Japan GCS Delivery)
Дата:
Сообщение: Update comment in errcodes.txt correctly