Bruce Momjian <bruce@momjian.us> writes:
> The new pg_tablespace_location() function added in PG 9.2 to remove the
> director location from pg_tablespace returns an odd error for '0', which
> is InvalidOID:
Well, it's the same "odd error" you'd get for any other bogus OID.
The way the function is coded, it has no need to look into pg_tablespace
as such, which is why you don't get something like "no such tablespace".
We could add such a lookup purely for error detection purposes, but I'm
not real sure I see the point.
> Is this OK? It handles NULL just fine:
That's a consequence of the function being marked strict; it has nothing
much to do with anything.
regards, tom lane