From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Amit Langote <amitlangote09(at)gmail(dot)com> |
Cc: | David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>, Etsuro Fujita <fujita(dot)etsuro(at)lab(dot)ntt(dot)co(dot)jp>, Amit Langote <Langote_Amit_f8(at)lab(dot)ntt(dot)co(dot)jp>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>, Robert Haas <robertmhaas(at)gmail(dot)com>, Derek Hans <derek(dot)hans(at)gmail(dot)com> |
Subject: | Re: Update does not move row across foreign partitions in v11 |
Date: | 2019-03-08 15:03:18 |
Message-ID: | 20190308150318.GA8681@alvherre.pgsql |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general pgsql-hackers |
On 2019-Mar-08, Amit Langote wrote:
> On Fri, Mar 8, 2019 at 11:09 PM Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> wrote:
> > I'm not sure about copying the same to ddl.sgml. Why is that needed?
> > Update is not DDL.
>
> Hmm, maybe because there's already a huge block of text describing
> certain limitations of UPDATE row movement under concurrency?
Uh, you're right, there is. That seems misplaced :-( I'm not sure it
even counts as a "limitation"; it seems to belong to the NOTES section
of UPDATE rather than where it is now.
> Actually, I remember commenting *against* having that text in
> ddl.sgml, but it got in there anyway.
We can move it now ...
> > ddl.sgml does say this: "Partitions can also be
> > foreign tables, although they have some limitations that normal tables
> > do not; see CREATE FOREIGN TABLE for more information." which suggests
> > that the limitation might need to be added to create_foreign_table.sgml.
>
> Actually, that "more information" never got added to
> create_foreign_table.sgml. There should've been some text about the
> lack for tuple routing at least in PG 10's docs, but I guess that
> never happened.
Sigh.
Since version 10 is going to be supported for a few years still, maybe
we should add it there.
> Should we start now by listing this UPDATE row movement limitation?
I think we should, yes.
--
Álvaro Herrera https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
From | Date | Subject | |
---|---|---|---|
Next Message | Alban Hertroys | 2019-03-08 15:15:35 | Re: Hot to model data in DB (PostgreSQL) for SNMP-like multiple configurations |
Previous Message | Amit Langote | 2019-03-08 14:43:29 | Re: Update does not move row across foreign partitions in v11 |
From | Date | Subject | |
---|---|---|---|
Next Message | David Fetter | 2019-03-08 15:11:25 | Re: psql show URL with help |
Previous Message | Amit Langote | 2019-03-08 14:43:29 | Re: Update does not move row across foreign partitions in v11 |