Re: How can I list the function.

On Wednesday 31 January 2007 8:46 pm, Harvey, Allan AC wrote:
> I know the function is there.
> What am I doing wrong?
>
> galvdb=#
> galvdb=# \df+ delete_old
> List of functions
> Result data type | Schema | Name | Argument data types | Owner | Language
> | Source code | Description
> ------------------+--------+------+---------------------+-------+----------
>+-------------+------------- (0 rows)
>
> galvdb=# select delete_old();
> delete_old
> ------------
> 482
> (1 row)
>
> galvdb=# select version();
> version
> ---------------------------------------------------------------------------
>---------- PostgreSQL 8.2.0 on i686-pc-linux-gnu, compiled by GCC gcc (GCC)
> 3.3.3 (SuSE Linux) (1 row)
>
> galvdb=#
>
>
> The material contained in this email may be confidential, privileged or
> copyrighted. If you are not the intended recipient, use, disclosure or
> copying of this information is prohibited. If you have received this
> document in error, please advise the sender and delete the document.
> Neither OneSteel nor the sender accept responsibility for any viruses
> contained in this email or any attachments.
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly

My guess is it is a permissions issue. The user you are logged in does not
have the privileges necessary to view the function. By default functions have
EXECUTE privileges granted to the ROLE PUBLIC which would explain you being
able to do select delete_old(). See below for more information.
http://www.postgresql.org/docs/8.2/interactive/sql-grant.html
--
Adrian Klaver
aklaver(at)comcast(dot)net