On 2011-12-21, Xiaoning Xu <xixu@bcgsc.ca> wrote:
> Hello,
>
> I have a problem concerning the partition table.
> When I store a record into one of the partition and use "RETURNING table_id" or "RETURNING *",
> I expect the same result when calling fetchall or fetchone function as not using partition.
> However, it simply returns nothing.
If you've got a before insert trigger there that does "return false" that's what
happens.
If you need returning to work, you could look at doing the
partitioning in a after insert trigger, deleteing from th main table
and inserting into the partition.
Else perhaps you can use a rule instead, have the rule run a function
and the function return the id.
--
⚂⚃ 100% natural