Re: On partitioning

Tom Lane wrote:
> Greg Stark <stark@mit.edu> writes:
> > And I think there are still unanswered questions about indexes.
> 
> 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.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services