Re: "CREATE RULE ... ON SELECT": redundant? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: "CREATE RULE ... ON SELECT": redundant?
Date
Msg-id 3196549.1683202672@sss.pgh.pa.us
Whole thread Raw
In response to Re: "CREATE RULE ... ON SELECT": redundant?  (Andrew Gierth <andrew@tao11.riddles.org.uk>)
List pgsql-hackers
Andrew Gierth <andrew@tao11.riddles.org.uk> writes:
> 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).

9.6.16 or later will use CREATE OR REPLACE VIEW, cf 404cbc562.

> 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.

Since the CREATE OR REPLACE case still works, I don't think removing
it is OK.

            regards, tom lane



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: evtcache: EventTriggerCache vs Event Trigger Cache
Next
From: Daniel Gustafsson
Date:
Subject: Re: evtcache: EventTriggerCache vs Event Trigger Cache