Re: Single row INSERT on updatable VIEW on top of partitioned table is run against each inheriting table, giving multiple rows from single insert.

From: Terje Elde <terje(at)elde(dot)net>
To: "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Single row INSERT on updatable VIEW on top of partitioned table is run against each inheriting table, giving multiple rows from single insert.
Date: 2013-07-24 13:11:31
Message-ID: 1297A7EB-DA4B-44A0-A768-84A094EFF230@elde.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Jul 24, 2013, at 2:37 PM, Terje Elde <terje(at)elde(dot)net> wrote:
> Short summary:
> If I run a single INSERT against an updateable VIEW on top of a partitioned table, it's run against all the tables/partitions. I'd expect that with UPDATE and DELETE, but not with INSERT. Result is multiple rows for a single INSERT, one for each table.

Sorry, while I did scan the last month and the open issues-list before sending, I missed that this had already been identified, patch submitted, and applied:

http://www.postgresql.org/message-id/CAEZATCW4EUi-BqjzYyow0nt84jhOwSDxzbhtbFoRrvUi59NCnQ@mail.gmail.com
http://www.postgresql.org/message-id/11683.1372868994@sss.pgh.pa.us

Everything behaves as expected with the patch.

Terje

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message vijayakumar.subas 2013-07-24 14:23:33 BUG #8328: Unable to start postgresql on the Debian machine.
Previous Message Terje Elde 2013-07-24 12:37:21 Single row INSERT on updatable VIEW on top of partitioned table is run against each inheriting table, giving multiple rows from single insert.