-----Original Message-----
From: Együd Csaba (Freemail) [mailto:[EMAIL PROTECTED]
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: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Michael Fuhr
Sent: Saturday, November 26, 2005 9:23 PM
To: Együd Csaba
Cc: 'Tom Lane'; [email protected]
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.
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
