FW: GRANT question - Mailing list pgsql-general

-----Original Message-----
From: Együd Csaba (Freemail) [mailto:csegyud@freemail.hu]
Sent: Saturday, November 26, 2005 9:36 PM
To: 'Michael Fuhr'
Subject: RE: [GENERAL] GRANT question

OK, here you are.
---------------------------
moson.gdb=> SELECT oid::regprocedure FROM pg_proc WHERE proname ILIKE
'%eden%';
                        oid
----------------------------------------------------
 public.triggerfunc_eden_anamnesis_after_insert()
 public.triggerfunc_eden_anamnesis_before_update()
 public.triggerfunc_eden_cal_att_after_update()
 public.triggerfunc_eden_common_before_update()
 public.triggerfunc_eden_countries_before_delete()
 public.triggerfunc_eden_countries_before_update()
 public.triggerfunc_eden_insurers_before_delete()
 public.triggerfunc_eden_insurers_before_update()
 public.triggerfunc_eden_partners_before_delete()
 public.triggerfunc_eden_partners_before_update()
 public.triggerfunc_eden_patientes_after_insert()
 public.triggerfunc_eden_patientes_before_delete()
 public.triggerfunc_eden_patientes_before_insert()
 public.triggerfunc_eden_patientes_before_update()
 public.triggerfunc_eden_positions_before_delete()
 public.triggerfunc_eden_positions_before_update()
 public.triggerfunc_eden_treatments_before_update()
 public.triggerfunc_eden_user_before_delete()
 public.triggerfunc_eden_user_before_update()
 public.triggerfunc_eden_worksheets_before_insert()
 public.triggerfunc_eden_worksheets_before_update()
 public.triggerfunc_eden_xrays_before_insert()
 public.triggerfunc_eden_xrays_before_update()
 public.edenproc_revoke_grants(integer)
 public.edenproc_admin(integer)
 public.edenproc_admin(text)
 public.edenproc_admin_only(integer)
 public.edenproc_admin_only(text)
 public.edenproc_permission_matrix()
 public.edenproc_revoke_grants(text)
 public.edenproc_set_grants(integer)
 public.edenproc_set_grants(text)
 public.edenproc_set_all_grants()
 public.edenproc_superuser(integer)
 public.edenproc_superuser(text)
 public.edenproc_usename(integer)
 public.edenproc_user_enabled(integer)
 public.edenproc_user_enabled(text)
 public.edenproc_usesysid(text)
(39 rows)

-----Original Message-----
From: pgsql-general-owner@postgresql.org
[mailto:pgsql-general-owner@postgresql.org] On Behalf Of Michael Fuhr
Sent: Saturday, November 26, 2005 9:23 PM
To: Együd Csaba
Cc: 'Tom Lane'; pgsql-general@postgresql.org
Subject: Re: [GENERAL] GRANT question

On Sat, Nov 26, 2005 at 09:10:40PM +0100, Egyd Csaba wrote:
> moson.gdb=> \df eden*
>                    List of functions
>  Schema | Name | Result data type | Argument data types
> --------+------+------------------+---------------------
> (0 rows)

Oops, I forgot that \df uses pg_function_is_visible(), so it won't show
functions that aren't in your search path.  Try this:

SELECT oid::regprocedure FROM pg_proc WHERE proname ILIKE '%eden%';

or

SELECT n.nspname, p.proname, oidvectortypes(p.proargtypes) FROM pg_proc AS p
LEFT OUTER JOIN pg_namespace AS n ON n.oid = p.pronamespace WHERE p.proname
ILIKE '%eden%';

--
Michael Fuhr

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.8/183 - Release Date: 2005.11.25.


--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.362 / Virus Database: 267.13.8/183 - Release Date: 2005.11.25.