From: | Boxuan Zhai <bxzhai2010(at)gmail(dot)com> |
---|---|
To: | Heikki Linnakangas <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | gSoC add MERGE command new patch -- merge_v104 |
Date: | 2010-08-19 14:01:35 |
Message-ID: | AANLkTinkaT=ewn8zFF805GxcAezo2T55SqVAiR0R+UiB@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
Attachment | Content-Type | Size |
---|---|---|
merge_v104.tar | application/x-tar | 100.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2010-08-19 14:20:26 | Re: proposal: tuplestore, tuplesort aggregate functions |
Previous Message | Tom Lane | 2010-08-19 13:47:17 | Re: Re: [COMMITTERS] pgsql: Coerce 'unknown' type parameters to the right type in the |