Re: FW: [GENERAL] GRANT question

2005-11-27 Thread Freemail
rg Subject: Re: FW: [GENERAL] GRANT question On Sun, Nov 27, 2005 at 08:02:37AM +0100, Egyd Csaba (Freemail) wrote: > thak you very much! Now it works well. [...] > moson.gdb=# select current_schemas(true); >current_schemas > - > {pg_catalog,public} > (1

Re: FW: [GENERAL] GRANT question

2005-11-27 Thread Michael Fuhr
On Sun, Nov 27, 2005 at 08:02:37AM +0100, Egyd Csaba (Freemail) wrote: > thak you very much! Now it works well. [...] > moson.gdb=# select current_schemas(true); >current_schemas > - > {pg_catalog,public} > (1 row) > > moson.gdb=# SELECT edenproc_usesysid('probauser'); >

Re: FW: [GENERAL] GRANT question

2005-11-26 Thread Freemail
Regards, -- Csaba Együd -Original Message- From: Michael Fuhr [mailto:[EMAIL PROTECTED] Sent: Saturday, November 26, 2005 10:16 PM To: Együd Csaba (Freemail) Cc: pgsql-general@postgresql.org Subject: Re: FW: [GENERAL] GRANT question On Sat, Nov 26, 2005 at 09:37:00PM +0100, Egyd Csaba (Freemail) w

Re: FW: [GENERAL] GRANT question

2005-11-26 Thread Michael Fuhr
On Sat, Nov 26, 2005 at 09:37:00PM +0100, Egyd Csaba (Freemail) wrote: > moson.gdb=> SELECT oid::regprocedure FROM pg_proc WHERE proname ILIKE > '%eden%'; [...] > public.edenproc_usesysid(text) Hmmm...so the function indeed exists in the public schema. What happens if you call the schema-qualifi

FW: [GENERAL] GRANT question

2005-11-26 Thread Freemail
-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 IL