Re: postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition)

From: Bernd Helmle <mailings(at)oopsware(dot)de>
To: Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, Amit Langote <amitlangote09(at)gmail(dot)com>, Stephen Frost <sfrost(at)snowman(dot)net>, Michael Paquier <michael(at)paquier(dot)xyz>
Subject: Re: postgres_fdw: IMPORT FOREIGN SCHEMA ... LIMIT TO (partition)
Date: 2021-03-28 17:39:25
Message-ID: 284a4f9c571fb189a4e8148a31570f288153737d.camel@oopsware.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Euler Taveira 2021-03-28 19:55:59 Re: Add docs stub for recovery.conf
Previous Message Stephen Frost 2021-03-28 17:22:16 Re: Add docs stub for recovery.conf