Re: Partitioning and ORM tools - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Partitioning and ORM tools
Date
Msg-id 56F1A9D6.2010502@commandprompt.com
Whole thread Raw
In response to Partitioning and ORM tools  (CS DBA <cs_dba@consistentstate.com>)
Responses Re: Partitioning and ORM tools  (Melvin Davidson <melvin6925@gmail.com>)
Re: Partitioning and ORM tools  (CS DBA <cs_dba@consistentstate.com>)
List pgsql-general
On 03/22/2016 11:40 AM, CS DBA wrote:
> Hi All;
>
> we setup partitioning for a large table but had to back off because the
> return status (i.e: "INSERT 0 1") returns "INSERT 0 0" when inserting
> into the partitioned table which causes the ORM tool to assume the
> insert inserted 0 rows.  Is there a standard / best practices work
> around for this?
>
> Thanks in advance

Are you inserting via trigger from an insert into a parent table? That
would do it.


--
Command Prompt, Inc.                  http://the.postgres.company/
                      +1-503-667-4564
PostgreSQL Centered full stack support, consulting and development.


pgsql-general by date:

Previous
From: CS DBA
Date:
Subject: Re: Partitioning and ORM tools
Next
From: Melvin Davidson
Date:
Subject: Re: Partitioning and ORM tools