Re: pg_tablespace_location() error message

Bruce Momjian <bruce(at)momjian(dot)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