Re: GRANT question

Hi Tom,
thank yor answer.

>Read the error message: this is not a lack-of-permissions problem.
You are right, I just meant that perhaps it needs some other settings, e.g.
set search_path or similar ... Sorry for that...

Regarding the search_path it is the same in both cases:

# show search_path;
search_path
--------------
$user,public
(1 row)

What else could cause this problem?

-- csaba

-----Original Message-----
From: Tom Lane [mailto:tgl(at)sss(dot)pgh(dot)pa(dot)us]
Sent: Saturday, November 26, 2005 5:29 PM
To: Együd Csaba
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] GRANT question

=?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud(at)vnet(dot)hu> writes:
> # select edenproc_usesysid('probauser');
> ERROR: function edenproc_usesysid(text) does not exist
^^^^^^^^^^^^^^

I'd wonder whether the two users have the same schema search path...

regards, tom lane

--
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.