[GENERAL] type "xxxxxxx" does not exist

Поиск
Список
Период
Сортировка
От Micky Hulse
Тема [GENERAL] type "xxxxxxx" does not exist
Дата
Msg-id CAKzdcNnYDS9yBSk_SAHkR9em=9g38uTd1W0-54xmq7vx_rUtww@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] type "xxxxxxx" does not exist
Re: [GENERAL] type "xxxxxxx" does not exist
Re: [GENERAL] type "xxxxxxx" does not exist
Список pgsql-general
Hello,

I hope this is the right list for me to ask questions about psql.
Please let me know if I am in the wrong place. :)

I am far from an advanced user of PostgreSQL, so please bear with me ...

I am working with an inherited database/codebase. I am trying to call
this function via psql:

# SELECT * FROM functionName('xxxxxxx', 'xxxxxxx', 'xxxxxxx');

What I get back is this:

ERROR:  type "xxx_xxx_xxxxx" does not exist
LINE 1:  DECLARE results xxx_xxx_xxxxx;
                         ^
QUERY:   DECLARE results xxx_xxx_xxxxx;
.....
.....


When listing the functions, I see that functionName() does exist in
the database.

The type also exists (I think):

# select exists (select 1 from pg_type where typname = 'xxx_xxx_xxxxx');
 exists
--------
 t
(1 row)

Note that the role that owns the 'type' is not the same user that is
calling the "functionName()" from the psql prompt. When I try to
switch roles, using:

sudo -i -u username
psql -U otherusername -d database

… I get:

psql: FATAL:  Peer authentication failed for user "otherusername"

Do I need to create a Linux user to login as "otherusername" so I can
test calling the functionName() with xxx_xxx_xxxxx type?

Lastly, the type was declared in the SQL dump like this:

CREATE TYPE xxx_xxx_xxxxx AS (
....

);
ALTER TYPE xxx_xxx_xxxxx OWNER TO otherusername;


I know that's a lot of info ... More than anything, I'm just wondering
if someone can give me tips on where to focus my attention in terms of
trouble shooting?

Thanks so much!


В списке pgsql-general по дате отправления:

Предыдущее
От: Eric Hill
Дата:
Сообщение: Re: [GENERAL] storing large files in database - performance
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: [GENERAL] type "xxxxxxx" does not exist