Re: "CREATE RULE ... ON SELECT": redundant?

>>>>> "Andrew" == Andrew Gierth <andrew@tao11.riddles.org.uk> writes:

 Andrew> I thought they used CREATE RULE on a table?

 Andrew> In fact here is an example from a pg 9.5 pg_dump output (with
 Andrew> cruft removed):

And checking other versions, 9.6 is the same, it's only with pg 10 that
it switches to creating a dummy view instead of a table (and using
CREATE OR REPLACE VIEW, no mention of rules).

So if the goal was to preserve compatibility with pre-pg10 dumps, that's
already broken; if that's ok, then I don't see any obvious reason not to
also remove or at least deprecate CREATE RULE ... ON SELECT for views.

-- 
Andrew (irc:RhodiumToad)