Re: "Type does not exist" error when returning array of type in non-public schema
| От | Chris Cleveland |
|---|---|
| Тема | Re: "Type does not exist" error when returning array of type in non-public schema |
| Дата | |
| Msg-id | CABSN6VfBKabhFAYeP5TET+r9D1RRkFEt-UPxV4cbo-VrCyHVug@mail.gmail.com обсуждение исходный текст |
| Ответ на | "Type does not exist" error when returning array of type in non-public schema (Chris Cleveland <ccleveland@dieselpoint.com>) |
| Ответы |
Re: "Type does not exist" error when returning array of type in non-public schema
Re: "Type does not exist" error when returning array of type in non-public schema |
| Список | pgsql-hackers |
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@sss.pgh.pa.us> wrote:
"David G. Johnston" <david.g.johnston@gmail.com> writes:
> On Thu, Feb 6, 2025 at 9:47 AM Chris Cleveland <ccleveland@dieselpoint.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
В списке pgsql-hackers по дате отправления: