From: | Együd Csaba (Freemail) <csegyud(at)freemail(dot)hu> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | FW: GRANT question |
Date: | 2005-11-26 20:37:00 |
Message-ID: | 0IQK00DFUX7Y5G10@invitel.hu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----Original Message-----
From: Együd Csaba (Freemail) [mailto:csegyud(at)freemail(dot)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(at)postgresql(dot)org
[mailto:pgsql-general-owner(at)postgresql(dot)org] On Behalf Of Michael Fuhr
Sent: Saturday, November 26, 2005 9:23 PM
To: Együd Csaba
Cc: 'Tom Lane'; pgsql-general(at)postgresql(dot)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.
From | Date | Subject | |
---|---|---|---|
Next Message | Michael Fuhr | 2005-11-26 21:15:58 | Re: FW: GRANT question |
Previous Message | Michael Fuhr | 2005-11-26 20:23:03 | Re: GRANT question |