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

From CS DBA
Subject Re: Partitioning and ORM tools
Date
Msg-id 56F1ACAF.3080908@consistentstate.com
Whole thread Raw
In response to Re: Partitioning and ORM tools  ("Joshua D. Drake" <jd@commandprompt.com>)
Responses Re: Partitioning and ORM tools  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general

On 03/22/2016 02:23 PM, Joshua D. Drake wrote:
> 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.
>
>
Yes.. that's exactly the issue.




pgsql-general by date:

Previous
From: Melvin Davidson
Date:
Subject: Re: Partitioning and ORM tools
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Partitioning and ORM tools