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

  1. postgres_fdw: Allow partitions specified in LIMIT TO to be imported.

  2. postgres_fdw: Teach IMPORT FOREIGN SCHEMA about partitioning.