In fact, now that I think of it, the patch-as-committed already introduces some serious headaches for pg_dump: it can't know for sure what name will be assigned to constraint indexes (pkey and unique indexes) so it has no good way to emit ALTER TABLE SET TABLESPACE commands for those indexes.
I guess I'll have to make it punt that the name will be what it currently is :(
Otherwise, we need to extend the ADD CONSTRAINT syntax. That would be handy because the you could specify the TABLESPACE at creation time as well.
Chris
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster