Weird "function does not exist" error.
| От | 邓尧 |
|---|---|
| Тема | Weird "function does not exist" error. |
| Дата | |
| Msg-id | CAOb3iugyRUxinXHX12yaukT0bfbt5Q7B3Cx=wEP8C1o3X6dD+g@mail.gmail.com обсуждение исходный текст |
| Ответы |
Re: Weird "function does not exist" error.
|
| Список | pgsql-general |
Hi,
I ran into a "function .... does not exist" error when invoking a function created by myself. What's weird is that the function works perfectly if I invoke it through the command line tool "psql" but fails if I invoke it through the C API.CREATE OR REPLACE FUNCTION "lo_select_page"(uid_ BIGINT, lottery_type_ INT,
type_ INT, time_start_ BIGINT, time_end_ BIGINT,
page_number_ BIGINT, prize_status_ INT)
RETURNS SETOF REFCURSOR AS $$
...
END $$ LANGUAGE plpgsql;
BEGIN;SELECT lo_select_page(4163481095, 0, 0, 0, 1893477600000, 0, 0);FETCH ALL IN order_list_cursor; FETCH ALL IN page_count_cursor;COMMIT;
В списке pgsql-general по дате отправления: