Peter Eisentraut <pete...@gmx.net> writes: > On Saturday 24 January 2009 02:17:13 Tom Lane wrote: >> 2. You don't want those rules, so you delete them, leaving you with the >> traditional behavior where attempted inserts etc on the view fail.
> This was never meant to be supported. If you don't want updates on the rules > to succeed, don't grant privileges. If we'd had the SQL-spec behavior from day one, it wouldn't be a problem, but you can't just blow off the old behavior like that. It's a potential security hole, since GRANT ALL on a view used to be de facto the same as GRANT SELECT, if you hadn't bothered to create any rules. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers