From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: joshua.uyehara@gmail.com
Subject: BUG #18178: New Restriction on "ON SELECT" rules on tables
Date: Wed, 01 Nov 2023 23:25:48 +0000
Message-ID: <18178-05534d7064044d2d@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18178
Logged by: Joshua Uyehara
Email address: joshua.uyehara@gmail.com
PostgreSQL version: 16.0
Operating system: Windows Server 2022
Description:
Hello,
Apologies if this is not the right place to report this, but it is either a
'bug' in the documentation, or (I'm hoping) a breaking change that could be
reverted.
The documentation for rules specifically states that "ON SELECT" rules can
be created on tables (and I have functionality/use cases that rely on that)
behavior, but pg16 breaks that.
In investigating the issue I did find what is likely the related release
note for 16 "Remove the ability to create views manually with ON SELECT
rules (Tom Lane)", but couldn't find any related discussion of the
rationale, suggested workarounds, or whether anyone else has yet run into
the same class of issues (possible given the recency of the release).
The issue is, basically, that there are broad classes of database
abstraction middleware that are configured via database introspection at
runtime and do not understand or implement the concept of updateable views
and foreign tables. The easiest workaround for that limitation in postgres
has always been to create a local table stand-in with all operations
rerouted to the foreign table via rules.
If I need to report this somewhere else, or send to one of the mailing
lists, please let me know.
Regards,
Josh
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, joshua.uyehara@gmail.com
Subject: Re: BUG #18178: New Restriction on "ON SELECT" rules on tables
In-Reply-To: <18178-05534d7064044d2d@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox