"David E. Wheeler" <david(at)kineticode(dot)com> writes:
> Is there a straight-foward way to check such a thing
> programmatically, with a query perhaps? Or should I just put aside an
> hour to do an audit?
I was wondering whether you could query pg_proc to look for functions
with the same name and different arguments/results. It's a bit tricky
though because you'd expect s/citext/text/ in at least some positions
(maybe not all)?
regards, tom lane