Postgres Pro
Downloads
Home   >   mailing lists

Thread: Missing Functions

Missing Functions

From
"Morris, Roy"
Date:

Hi, I know I am probably doing something retarded but can anyone tell me why I don’t see any functions? Shouldn’t there be a bunch of standard system functions?

 

 

psql (8.4.3)

You are now connected to database "postgres".

postgres=# \df

                       List of functions

 Schema | Name | Result data type | Argument data types | Type

--------+------+------------------+---------------------+------

(0 rows)

 

 

 

Here’s what I have installed

 

[root@spontreportdb rmorris]# rpm -qa |grep postgr

postgresql-8.4.3-1PGDG.rhel5

postgresql-pltcl-8.4.3-1PGDG.rhel5

postgresql-docs-8.4.3-1PGDG.rhel5

postgresql-server-8.4.3-1PGDG.rhel5

postgresql-plperl-8.4.3-1PGDG.rhel5

postgresql-libs-8.4.3-1PGDG.rhel5

postgresql-contrib-8.4.3-1PGDG.rhel5

postgresql-plpython-8.4.3-1PGDG.rhel5

postgresql-devel-8.4.3-1PGDG.rhel5

compat-postgresql-libs-4-1PGDG.rhel5

 

 

Re: Missing Functions

From
Joshua Tolley
Date:
On Mon, Jul 26, 2010 at 11:38:26AM -0400, Morris, Roy wrote:
>    Hi, I know I am probably doing something retarded but can anyone tell me
>    why I don't see any functions? Shouldn't there be a bunch of standard
>    system functions?

As of 8.4, \d requires the S modifier to show system objects. See
http://www.postgresql.org/docs/8.4/static/app-psql.html

--
Joshua Tolley / eggyknap
End Point Corporation
http://www.endpoint.com
Attachment