Re: [Postgres-xc-developers] Patch for bug 3614553

[Ashutosh B. <ash...@en...>]

HI Amit,
Can we move this check deep into heap_update or something? That way we can
cover all the ways partition column can be updated.


On Thu, Jun 20, 2013 at 10:25 AM, Amit Khandekar <
ami...@en...> wrote:

> Currently there is no check if the trigger function has modified the
> partition column for UPDATE. Attached patch does the verification in
> ExecBRUpdateTriggers(). INSERT does not require it, because it is a new row
> being inserted, and if the trigger function modifies the column values, the
> INSERT gets executed on the datanode corresponding to the final
> distribution value of the row.
>
> A user can still make the trigger function immutable and if this trigger
> runs on datanode, it will be able to do partition column updates, but then
> it can be done by any other function by just making it immutable and doing
> partition column updates via an SQL statement; it's the user's
> reponsibility to mark functions immutable carefully.
>
> Added  testcases in xc_triggers.sql.
>
> -Amit
>
>
>
> ------------------------------------------------------------------------------
> This SF.net email is sponsored by Windows:
>
> Build for Windows Store.
>
> http://p.sf.net/sfu/windows-dev2dev
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>


-- 
Best Wishes,
Ashutosh Bapat
EntepriseDB Corporation
The Postgres Database Company