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
|
