Re: [HACKERS] Triggers and logical replication (10devel)

2017-04-21 Thread Egor Rogov
On 21.04.2017 16:29, Merlin Moncure wrote: On Fri, Apr 21, 2017 at 5:08 AM, Egor Rogov wrote: Hello, It seams that tiggers don't fire on subscriber's tables during logical replication. Is it a bug? Reading the documentation (which is TBH a bit hard to follow) it appears that it i

[HACKERS] Triggers and logical replication (10devel)

2017-04-21 Thread Egor Rogov
1 postgres@subscriber=# SELECT * FROM log; tg_table_name | tg_when | tg_op | tg_level | tg_str ---+-++---+ t | BEFORE | INSERT | STATEMENT | t | BEFORE | INSERT | ROW | (100) t | AFTER | INSERT | ROW

Re: [HACKERS] REVOKE [ADMIN OPTION FOR] ROLE

2015-07-28 Thread Egor Rogov
On 27.07.2015 22:09, Stephen Frost wrote: * Egor Rogov (e.ro...@postgrespro.ru) wrote: On Thu, Jul 23, 2015 at 8:30 AM, Egor Rogov wrote: So, the question: is it a documentation bug (as it seems to me), code bug, or I missed something? Your analysis looks right to me, but I don't

Re: [HACKERS] REVOKE [ADMIN OPTION FOR] ROLE

2015-07-27 Thread Egor Rogov
On Thu, Jul 23, 2015 at 8:30 AM, Egor Rogov wrote: So, the question: is it a documentation bug (as it seems to me), code bug, or I missed something? Your analysis looks right to me, but I don't know whether the code or the documentation should be changed. This claim was added by Tom La

[HACKERS] Revoke [admin option for] role

2015-07-23 Thread Egor Rogov
Hi, I found an inconsistency between documentation and real behavior of REVOKE [ADMIN OPTION FOR] ROLE. As per documentation (http://www.postgresql.org/docs/current/static/sql-revoke.html): -- If GRANT OPTION FOR is specified, only the grant option for the privilege is revoked, not the priv

[HACKERS] REVOKE [ADMIN OPTION FOR] ROLE

2015-07-23 Thread Egor Rogov
ooked into the code too (backend/commands/user.c, GrantRole(GrantRoleStmt *stmt) function) and didn't find any processing of stmt->behavior. So, the question: is it a documentation bug (as it seems to me), code bug, or I missed something? Thanks, Egor Rogov Postgres