The category of affine schemes is lextensive, but is not infinitary extensive.
The fact that the category of affine schemes is lextensive is well-known. The dual statement for the category of commutative rings comes down to some easily verified claims:
The category of commutative rings is of course finitely cocomplete.
Product projections , are epic, and their pushout is terminal.
The pushout in of two ring maps , is given by the tensor product , with the evident commutative ring structure.
The pushing-out functor along a map , namely , preserves finite products (since finite products are reflected and preserved by the forgetful functor to , where they are biproducts and therefore coproducts that are preserved by tensoring).
However, the category of affine schemes is not infinitary extensive. Again, we consider what infinitary extensivity would mean for the dual category:
Take to be Noetherian. Suppose that a commutative ring over is flat as an -module, and that preserves products. Since the forgetful functor preserves and reflects equalizers, it must be that also preserves equalizers and therefore all limits. We will apply this observation to certain wide pullbacks in to deduce that is finitely generated as an -module.
For any -module , let be the commutative -algebra where the identity lives in the summand and the product of any two elements in the summand is defined to be zero. Then for any collection of -modules , the wide pullback in of the wide cospan consisting of projection maps is just . Given that preserves this wide pullback, it means that the canonical arrow
is an isomorphism, and this forces the functor , now regarding simply as an -module, to preserve the product . So assuming is flat and preserves products, we see that preserves products and therefore limits (again by flatness).
Now is an accessible (in fact, a finitary) functor between locally presentable categories, so that under the assumption that it preserves limits, it must be a right adjoint. Its left adjoint is, as any left adjoint must be, given by a functor of the form . Hence we have
and it follows that . Now the left side of this isomorphism preserves colimits, but can preserve colimits only if is finitely generated and projective, i.e., a direct summand of some finite free -module . Hence
is also a direct summand of , and in particular is finitely generated.
The upshot is that if a commutative algebra over a Noetherian is flat but not finitely generated as an -module, then products of commutative -algebras are not stable under pushing out along the ring map . For the opposite category of affine schemes, it means that coproducts are not stable under pullback.