Re: On partitioning - Mailing list pgsql-hackers

From Tom Lane
Subject Re: On partitioning
Date
Msg-id 21834.1409332516@sss.pgh.pa.us
Whole thread Raw
In response to Re: On partitioning  (Alvaro Herrera <alvherre@2ndquadrant.com>)
Responses Re: On partitioning
Re: On partitioning
Re: On partitioning
List pgsql-hackers
Alvaro Herrera <alvherre@2ndquadrant.com> writes:
> Tom Lane wrote:
>> One other interesting thought that occurs to me: are we going to support
>> UPDATEs that cause a row to belong to a different partition?  If so, how
>> are we going to handle the update chain links?

> Bah, I didn't mention it?  My current thinking is that it would be
> disallowed; if you have chosen your partitioning key well enough it
> shouldn't be necessary.  As a workaround you can always DELETE/INSERT.
> Maybe we can allow it later, but for a first cut this seems more than
> good enough.

Hm.  I certainly agree that it's a case that could be disallowed for a
first cut, but it'd be nice to have some clue about how we might allow it
eventually.
        regards, tom lane



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: On partitioning
Next
From: Andres Freund
Date:
Subject: Re: On partitioning