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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: Joshua Uyehara <joshua(dot)uyehara(at)gmail(dot)com>, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #18178: New Restriction on "ON SELECT" rules on tables
Date: 2023-11-03 15:53:31
Message-ID: 3305563.1699026811@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Robert Leach 2023-11-03 17:49:43 Re: BUG #18177: certain queries under certain contexts take multiple orders of magnitude longer compared to v10
Previous Message Tom Lane 2023-11-03 15:50:58 Re: BUG #18178: New Restriction on "ON SELECT" rules on tables