Re: "Type does not exist" error when returning array of type in non-public schema

I solved the problem with:

CREATE FUNCTION myfunc ... RETURNS Token[] ... SET search_path to rdb;

I still don't know why it happens in the first place, though.

On Thu, Feb 6, 2025 at 12:14 PM Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:

> "David G. Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com> writes:
> > On Thu, Feb 6, 2025 at 9:47 AM Chris Cleveland <
> ccleveland(at)dieselpoint(dot)com>
> > wrote:
> >> RETURN "rdb.Token"[], RETURN "rdb.Token[]" all fail.
>
> > Expecting these two to work suggests you need to re-read the section on
> how
> > quoting identifiers works.
>
> I'm wondering if it needs to be "Token". Mixed-case SQL identifiers
> are usually more of a pain than they're worth, frankly.
>
> regards, tom lane
>

--
Chris Cleveland
312-339-2677 mobile