Postgres Pro
Downloads
Home   >   mailing lists

Re: BUG #18178: New Restriction on "ON SELECT" rules on tables - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #18178: New Restriction on "ON SELECT" rules on tables
Date
Msg-id 3305563.1699026811@sss.pgh.pa.us
Whole thread Raw
In response to Re: BUG #18178: New Restriction on "ON SELECT" rules on tables  (Laurenz Albe <laurenz.albe@cybertec.at>)
List pgsql-bugs
Tree view 
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #18178: New Restriction on "ON SELECT" rules on tables
Next
From: Robert Leach
Date:
Subject: Re: BUG #18177: certain queries under certain contexts take multiple orders of magnitude longer compared to v10