| From: | "Rajan Bhide" <rbhide(at)starentnetworks(dot)com> |
|---|---|
| To: | <pgsql-novice(at)postgresql(dot)org> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Subject: | Problem executing user function (on Solaris) |
| Date: | 2004-09-08 11:06:49 |
| Message-ID: | FF851C7EEB75954F9BCFB5CA117AB1EC6743A8@delta.nulinkinc.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Daniel Secomb | 2004-09-08 13:33:51 | I NEED HELP!!! - (ERROR: parser: unterminated quoted string) |
| Previous Message | William Herrera | 2004-09-07 10:44:44 | Installing language plpgsql |