Re: [BUGS] BUG #1142: Problem with update permissions for view

2004-04-30 Thread Arturs Zoldners
Hi! I submited this bug from web interface 27 Apr 2004, but the details were lost. The original message was: >From PostgreSQL 7.4.2 Documentation (34.4. Rules and Privileges): "...user only needs the required privileges for the tables/views that he names explicitly in his queries..." However, i

[BUGS] BUG #1145: silent REVOKE failures

2004-04-30 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1145 Logged by: Fabien Coelho Email address: [EMAIL PROTECTED] PostgreSQL version: 7.5 Dev Operating system: linux debian Description:silent REVOKE failures Details: REVOKE fails silently. It may be a fe

Re: [BUGS] BUG #1142: Problem with update permissions for view

2004-04-30 Thread Tom Lane
Arturs Zoldners <[EMAIL PROTECTED]> writes: > -- The following rule prevents user x to update public_data: > CREATE RULE log_public AS ON UPDATE TO private_data WHERE (new.a <> > old.a) DO INSERT INTO private_log (old_val, new_val) VALUES (old.a, > new.a); This is a known problem. It's fixed for

Re: [BUGS] BUG #1145: silent REVOKE failures

2004-04-30 Thread Tom Lane
"PostgreSQL Bugs List" <[EMAIL PROTECTED]> writes: > The REVOKE failure should be reported. What failure? This looks perfectly fine to me. regards, tom lane ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands