Problem executing user function (on Solaris)

Поиск
Список
Период
Сортировка
От Rajan Bhide
Тема Problem executing user function (on Solaris)
Дата
Msg-id FF851C7EEB75954F9BCFB5CA117AB1EC6743A8@delta.nulinkinc.com
обсуждение исходный текст
Ответы Re: Problem executing user function (on Solaris)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-novice
Hi,

I am using plpgsql to write user function and type.
I am facing problem while executing the function.

psql=# select * from GSS_FUNC_REQ_CDR_COUNT();
ERROR:  parser: parse error at or near "("

psql=# SELECT  GSS_FUNC_REQ_CDR_COUNT();
NOTICE:  plpgsql: ERROR during compile of gss_func_req_cdr_count near
line 0
ERROR:  fmgr_info: function 0: cache lookup failed

psql=# \df  GSS_FUNC_REQ_CDR_COUNT
 List of functions
 Result data type |          Name          | Argument data types
------------------+------------------------+---------------------
 gss_counter_type | gss_func_req_cdr_count |

I am using PostgreSQL 7.4.3 on Solaris 5.8

BUT,If I try the same stuff on my Linux box(Debian 2.4.4-pre3+,i686),
things are working fine.
psql=# select * from GSS_FUNC_REQ_CDR_COUNT();
 store_drt | acked_drt | store_cdr | acked_cdr
-----------+-----------+-----------+-----------
       400 |        12 |       400 |        12

Can anybody suggest, How to solve this problem?

Thanks,
Rajan Bhide

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

Предыдущее
От: Oliver Fromme
Дата:
Сообщение: Re: pgAccess via ssh?
Следующее
От: "Daniel Secomb"
Дата:
Сообщение: I NEED HELP!!! - (ERROR: parser: unterminated quoted string)