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