Re: Special role for subscriptions
| От | Evgeniy Efimkin |
|---|---|
| Тема | Re: Special role for subscriptions |
| Дата | |
| Msg-id | 2244061541664697@iva5-815ce03d682b.qloud-c.yandex.net обсуждение исходный текст |
| Ответ на | Re: Special role for subscriptions (Stephen Frost <sfrost@snowman.net>) |
| Список | pgsql-hackers |
Hi! I think we can add FOR TABLES clause for create/refresh subscription, for example: CREATE SUBSCRIPTION my_sub CONNECTION... PUBLICATION my_pub [WITH ...] [ FOR TABLES t1, t2 | ALL TABLES ]. ALL TABLES is avalibale only for superuser.FOR TABLES t1, t2 is available to owner of tables and superuser. 07.11.2018, 00:52, "Stephen Frost" <sfrost@snowman.net>: > Greetings, > > * Evgeniy Efimkin (efimkin@yandex-team.ru) wrote: >> As a first step I suggest we allow CREATE SUBSCRIPTION for table owner only. > > That's a nice idea but seems like we would want to have a way to filter > what tables a subscription follows then..? Just failing if the > publication publishes tables that we don't have access to or are not the > owner of seems like a poor solution.. > > Thanks! > > Stephen -------- Ефимкин Евгений
В списке pgsql-hackers по дате отправления: