| From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
|---|---|
| To: | Robert Haas <robertmhaas(at)gmail(dot)com> |
| Cc: | Kevin Grittner <kgrittn(at)gmail(dot)com>, Craig Ringer <craig(at)2ndquadrant(dot)com>, Marko Tiikkaja <marko(at)joh(dot)to>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Andrew Gierth <andrew(at)tao11(dot)riddles(dot)org(dot)uk> |
| Subject: | Re: PG10 transition tables, wCTEs and multiple operations on the same table |
| Date: | 2017-06-09 04:00:51 |
| Message-ID: | CAEepm=2ZQ+mujsvWXhOqaNxpc2-0hDev6q7a+XrbOn2=cr7=0A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Wed, Jun 7, 2017 at 5:36 PM, Thomas Munro
<thomas(dot)munro(at)enterprisedb(dot)com> wrote:
> I spent a couple of hours drafting a proof-of-concept to see if my
> hunch was right. It seems to work correctly so far and isn't huge
> (but certainly needs more testing and work):
>
> 6 files changed, 156 insertions(+), 109 deletions(-)
[Adding Andrew Gierth]
Here is a new version of the patch to fix transition tables with
wCTEs, rebased on top of
transition-tuples-from-child-tables-v10.patch[1] which must be applied
first.
This is patch 2 of a stack of 3 patches addressing currently known
problems with transition tables.
--
Thomas Munro
http://www.enterprisedb.com
| Attachment | Content-Type | Size |
|---|---|---|
| transition-tuples-from-wctes-v2.patch | application/octet-stream | 23.3 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Munro | 2017-06-09 04:10:15 | Transition tables vs ON CONFLICT |
| Previous Message | Thomas Munro | 2017-06-09 03:56:33 | Re: transition table behavior with inheritance appears broken (was: Declarative partitioning - another take) |