Re: Deprecating RULES - Mailing list pgsql-hackers

From Josh Berkus
Subject Re: Deprecating RULES
Date
Msg-id 507747F4.8020509@agliodbs.com
Whole thread Raw
In response to Re: Deprecating RULES  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Deprecating RULES  (Simon Riggs <simon@2ndQuadrant.com>)
Re: Deprecating RULES  (Darren Duncan <darren@darrenduncan.net>)
List pgsql-hackers
>> For 9.3, I suggest we create a DDL trigger by default which prevents
>> RULEs and throws an ERROR that explains they are now deprecated.

Well, even if we were considering this, the sequence would need to be:

1. Announce in 9.3 that RULES will be going away RSN.
2. In 9.4, send a warning every time someone loads/edits a user-defined
RULE.
3. In 10.0, get rid of CREATE RULE.

> This is utter nonsense.  We can't deprecate them until we have a
> substitute that is better.  If you want to get rid of rules, build the
> replacement; don't just try to be a pain in the ass to users.

I was thinking that this should start with making a list of all of the
things you can currently do with RULEs and making sure that we have an
equivalent.  When it actually comes time to dump RULEs entirely, we
would also need docs on how to migrate existing RULEs to the new
equivalents (e.g. rewriting a RULE as a view or a trigger).

Wiki page, anyone?

-- 
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com



pgsql-hackers by date:

Previous
From: Josh Berkus
Date:
Subject: Re: [PATCH 8/8] Introduce wal decoding via catalog timetravel
Next
From: Markus Wanner
Date:
Subject: Re: WAL_DEBUG logs spurious data