[Postgres-xc-developers] 回复： Fwd: [ postgres-xc-Bugs-3107683 ] UPDATE on partition column

[mei le <lem...@ya...>]

Dears,
 
This patch forbids users to update partition column of a table.
 
Your suggestions will be appreciated.

                                     Regards,
                                        Benny
 
                                                             
--- 10年11月12日，周五, Mason Sharp <mas...@en...> 写道：


发件人: Mason Sharp <mas...@en...>
主题: Fwd: [ postgres-xc-Bugs-3107683 ] UPDATE on partition column
收件人: "Postgres-XC Developers" <pos...@li...>, "mei le" <lem...@ya...>
日期: 2010年11月12日,周五,上午10:34


Benny,

I thought this might be one you might be interested in working on, too, if you have time.

You could validate the update statement in pgxc_planner() if it is on a partitioned table.

Thanks,

Mason

-------- Original Message -------- 



Subject: 
[ postgres-xc-Bugs-3107683 ] UPDATE on partition column

Date: 
Fri, 12 Nov 2010 02:29:56 +0000

From: 
SourceForge.net <no...@so...>

To: 
no...@so...

Bugs item #3107683, was opened at 2010-11-11 21:29
Message generated for change (Tracker Item Submitted) made by mason_s
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1310232&aid=3107683&group_id=311227

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Database Server
Group: None
Status: Open
Resolution: None
Priority: 6
Private: No
Submitted By: mason_s (mason_s)
Assigned to: Nobody/Anonymous (nobody)
Summary: UPDATE on partition column

Initial Comment:
Until we support moving tuples from one node to another when the partition column of a table is updated, we should at least block this from happening. At the moment you can update it, and bad things can start happening as a result.

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=1310232&aid=3107683&group_id=311227