Re: postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition)
Bernd Helmle <mailings@oopsware.de>
From: Bernd Helmle <mailings@oopsware.de>
To: Matthias van de Meent <boekewurm+postgres@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>, Amit Langote
<amitlangote09@gmail.com>, Stephen Frost <sfrost@snowman.net>, Michael
Paquier <michael@paquier.xyz>
Date: 2021-03-28T17:39:25Z
Lists: pgsql-hackers
Am Mittwoch, dem 24.03.2021 um 17:32 +0100 schrieb Bernd Helmle: > > Yes, but it should be noted that the main reason that was mentioned > > as > > a reason to exclude partitions is to not cause table catalog bloat, > > and I argue that this argument is not as solid in the case of the > > explicitly named tables of the LIMIT TO clause. Except if SQL > > standard > > prescribes otherwise, I think allowing partitions in LIMIT TO > > clauses > > is an improvement overall. > > Don't get me wrong, i find this useful, too. Especially because it's > a > very minor change in the code. And i don't see negative aspects here > currently, either (which doesn't mean there aren't some). Since there are currently no obvious objections i've marked this "Read for Committer". -- Thanks, Bernd
Commits
-
postgres_fdw: Allow partitions specified in LIMIT TO to be imported.
- a3740c48eb2f 14.0 landed
-
postgres_fdw: Teach IMPORT FOREIGN SCHEMA about partitioning.
- f49bcd4ef3e9 10.0 cited