> Just curious, but why don't the copy command fall under the same
> grant/revoke restrictions in the first place? It sounds to me like we are
> backing off of the problem instead of addressing it...
grant/revoke works for copy.
>
> The problem being that it appears that 'copy' overrides/ignores
> the rewrite rules, which kind of invalidates having them, doesn't it?
> What would it take to have copy follow them as select does?
Hard, because COPY does not do joins and does not go through the
optimizer and executor. It dumps single tables. Tough to yank that
through rewrite.
--
Bruce Momjian
maillist@candle.pha.pa.us