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:[EMAIL PROTECTED] Sent: Saturday, November 26, 2005 5:29 PM To: Együd Csaba Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] GRANT question =?iso-8859-2?Q?Egy=FCd_Csaba?= <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
