Horton

Re: BUG #18178: New Restriction on "ON SELECT" rules on tables

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Laurenz Albe <laurenz.albe@cybertec.at>
Cc: Joshua Uyehara <joshua.uyehara@gmail.com>, pgsql-bugs@lists.postgresql.org
Date: 2023-11-03T15:53:31Z
Lists: pgsql-bugs 
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> But I wonder if it would not be better to completely remove ON SELECT from the CREATE RULE
> command.  Attached is a patch that does that.

I don't think this is a great idea.  There are perhaps still pg_dump
scripts out there that use CREATE OR REPLACE RULE "_RETURN" to adjust
view definitions.

			regards, tom lane

Commits

  1. Doc: update CREATE RULE ref page's hoary discussion of views.

  2. Remove logic for converting a table to a view.