Tom Lane wrote: > Greg Stark <st...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers