Re: gSoC add MERGE command new patch -- merge_v104

Hi,

I finished the MERGE on inheritance tables. Now comes the merge_v201

The test example can be found at
https://wiki.postgresql.org/wiki/MergeTestExamples#MERGE_on_inheritance

Thanks

On Thu, Aug 19, 2010 at 10:01 PM, Boxuan Zhai <bxzhai2010(at)gmail(dot)com> wrote:

> Hi,
>
> Here comes the new patch for MERGE command. It has the following features:
>
> 1. It is based on Heikki's merge_v102-cleanedup.patch. So, it is
> (hopefully) clean -- no meaningless white spaces and no overlong clause.
>
> 2. The "replaced" mark in MERGE query and plan structures are removed. In
> rewriter, the actions replaced by INSTEAD rules will be changed into DO
> NOTHING actions.
>
> 3. _outDeleteStmt() is removed from code.
>
> 4. EXPLAIN MERGE is improved much. You can see the new examples at
> https://wiki.postgresql.org/wiki/MergeTestExamples#Explain_Merge
>
> 5. The subplan/sublinks are supported in merge actions now. Try the
> examples at
> https://wiki.postgresql.org/wiki/MergeTestExamples#Subplan.2Fsublinks_in_action
>
> 6. Updated merge.sql and merge.out for regress
>
> 7. The inheritance is still NOT supported yet.
>
> Thanks
>
> Regards
>
> Yours Boxuan
>