> The problem here is, that the relkind must change at rule
> creation/drop time. Fortunately rules on SELECT are totally
> restricted to VIEW's since 6.4, and I don't see any reason to
> change this.
I don't see why a real view should still be createable by the old
create table then create rule way. Then the relkind would never
need to change. The only place that would need correction is
pg_dump to dump create view statements.
Imho we should not limit select rules to views by design.
With a different relkind for views this is not necessary anyway.
Andreas