$\newcommand{\O}{\mathcal{O}}\newcommand{\T}{\mathcal{T}}\newcommand{\op}{^{\sf{op}}}\newcommand{\set}{\sf{Set}}\newcommand{\ps}{\sf{Psh}_{\T}}$Let $\T$ be a topological space and $\O(\T)$ the poset category (ordered by $\subseteq$) of the open sets of $\T$. We define a (geometric) presheaf to be any functor $\O(\T)\op\to\set$, so let $\ps$ be the functor category of presheaves, $\ps=[\O(\T)\op,\set]$. Note that beyond this, I have no knowledge of algebraic geometry. To a student of algebraic geometry I'm sure this exercise is quite easy (but it is curious it was left in Leinster's book, which does not cover the subject).
I have been baffled by the following exercise for a while - Source of exercise, Leinster's Basic Category Theory, the first section of the "Adjoints" chapter:
Define $\Delta:\set\to\ps$ to be the "diagonal functor", where for any set $A$, $\Delta A$ is the constant presheaf which maps all inputs to $A$ and arrows to the identity arrow on $A$. $\Delta$'s action on functions $f:A\to B$ is to map them to the obvious constant natural transformations given by the components $\Delta f_U:=f$ for each open set $U$ of $\T$.
Exhibit a chain of adjoint functors $\Lambda\dashv\Pi\dashv\Delta\dashv\Gamma\dashv\nabla$.
So far in the course, he has not taught us about the other ways of thinking about adjunctions (units/counits and initial/terminal morphisms), only the definition via "equivalence of arrows" has been covered. I tried this exercise after having read ahead and learning about adjoint functors from other sources, so I was able to figure out $\Pi$ and $\Gamma$ by examining terminal/initial morphisms. The answer is that $\Gamma$ maps a presheaf $F$ to the set $F(\T)$, and maps natural transformations $\alpha:F\to G$ to the component function $\alpha_\T$. Dually $\Pi$ maps a presheaf $F$ to the set $F(\emptyset)$, and maps natural transformations $\alpha$ to $\alpha_\emptyset$.
I was able to find these functors since $\Delta$ has the nice property that, in the search for a terminal morphism $\varepsilon_F:\Delta\Gamma F\to F$, we just need to find arrows that complete the wedge $F(U)\leftarrow\Gamma F\rightarrow F(U')$ whenever $U'\subseteq U$ since $\Delta$ collapses a presheaf into one object. This made the problem significantly easier!
However, even thinking of what kind of presheaf $\nabla X$ might be is proving too much for me. I've toyed with $\nabla X(U):=\{\text{functions $U\to X$}\}$ (or the other way round) but this leaves it impossible to choose a terminal morphism $\varepsilon:\Gamma\nabla X\to X$ in a natural way. Beyond sets of functions, I have no idea how to construct a presheaf from a set (I have seen no examples). What's worse is that, when $U'\subseteq U$, I need to find arrows $\nabla_{U,U'}$ that entail the uniqueness criterion of the terminal morphism. What do I mean by that? Well, for any presheaf $F$ and any function $f:F(\T)\to X$, there needs to be a unique natural transformation $\alpha:F\to\nabla X$ such that $\varepsilon_X\circ\alpha_\T=f$. So, $\alpha$ needs to be uniquely specified by $\alpha_\T$. Of course every $U\in\O(\T)$ is a subset of $\T$ itself, so we need $\alpha_U$ to be uniquely specified by the naturality criterion $\alpha_UF_{\T,U}=\nabla_{\T,U}\alpha_\T$ (uniqueness up to $F$). So, this $\nabla_{\T,U}$ arrow needs to be somewhat special.
Does anyone have any ideas? The nature of this exercise is that $\nabla X$ is going to be quite an "obvious" construction, but I can't see it.
It is worth noting that I heard from a fairly reliable source that the left and right adjoints to $\Pi,\Gamma$ respectively do not exist for every topological space $\T$. They did not say anymore sadly, but that's left me even more confused since my construction cannot be too general. I'd appreciate any useful hints or full answers - I am totally stuck.
Let $\nabla$ be the functor which associates to a set $A$ the following presheaf: $\nabla(A)(X) = A$, and $\nabla(A)(U)$ is a singleton for all proper open subsets $U$, with the restriction maps being the only ones possible. Then we have the desired adjunction: $$\mathsf{Hom}_{\sf{Set}}(F(X),A)\simeq\mathsf{Hom}_{\sf{Psh}}(F,\nabla(A)). $$ Indeed, the map from right to left is given by taking the induced map on global sections. But since a singleton is a final object in the category of sets, the map on global sections will uniquely determine a map of presheaves.
Maybe your reliable source was talking about the category of sheaves? The global sections functor on the category of sheaves is almost always left but not right exact, so it can't be a left adjoint.