[ADMIN] How to view the code of a function

2009-12-11 Thread Venkateswara Rao Bondada
Hi, I'm trying to look at the source code of a function in PostgreSQL. Could anybody please let me know how to view the same? Thanks, Venkat CAUTION - Disclaimer * This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the

Re: [ADMIN] How to view the code of a function

2009-12-11 Thread Thomas Kellerer
Venkateswara Rao Bondada, 11.12.2009 10:58: I’m trying to look at the source code of a function in PostgreSQL. Could anybody please let me know how to view the same? select pg_catalog.pg_get_functiondef(oid) from pg_proc http://www.postgresql.org/docs/current/static/functions-info.html As

Re: [ADMIN] How to view the code of a function

2009-12-11 Thread Sam Jas
(1) select procsrc from pg_proc where proname like 'function_name'; (2) df+ function_name -- Thanks Sam Jas --- On Fri, 11/12/09, Venkateswara Rao Bondada venkateswar...@infosys.com wrote: From: Venkateswara Rao Bondada venkateswar...@infosys.com Subject: [ADMIN] How to view the code of

[ADMIN] AIX 5.3 Out of Memory Error - 64-bit

2009-12-11 Thread Thorne, Francis
Hi All I'm looking for some help with regards a postgres 64-bit install I set up on a IBM AIX machine. I used the following install options whien I installed postgres BINDIR = /usr/local/pgsql837-64/bin DOCDIR = /usr/local/pgsql837-64/doc INCLUDEDIR = /usr/local/pgsql837-64/include

[ADMIN] Looking for Good and Easy-to-use Reporting Tool

2009-12-11 Thread Su, Alan
Can anyone recommend a good, easy to ease and inexpensive reporting tool for accessing and manipulating Postgre database/table? The key features I am looking for with this tool are as follows: * Require less programming effort. I am trying to stay away from having to write sophisticate

Re: [ADMIN] AIX 5.3 Out of Memory Error - 64-bit

2009-12-11 Thread Scott Marlowe
On Fri, Dec 11, 2009 at 6:40 AM, Thorne, Francis thor...@cromwell.co.uk wrote: Hi All I'm looking for some help with regards a postgres 64-bit install I  set up on a IBM AIX machine. I used the following install options whien I installed postgres BINDIR = /usr/local/pgsql837-64/bin

Re: [ADMIN] AIX 5.3 Out of Memory Error - 64-bit

2009-12-11 Thread Brad Nicholson
On Fri, 2009-12-11 at 11:18 -0700, Scott Marlowe wrote: On Fri, Dec 11, 2009 at 6:40 AM, Thorne, Francis thor...@cromwell.co.uk wrote: Hi All I'm looking for some help with regards a postgres 64-bit install I set up on a IBM AIX machine. I used the following install options whien I

Re: [ADMIN] Looking for Good and Easy-to-use Reporting Tool

2009-12-11 Thread Brian Modra
2009/12/11 Su, Alan alan...@daiwausa.com: Can anyone recommend a good, easy to ease and inexpensive reporting tool for accessing and manipulating Postgre database/table? The key features I am looking for with this tool are as follows: Require less programming effort. I am trying to stay