Search Postgresql Archives

Re: GRANT question

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxxx] 
Sent: Saturday, November 26, 2005 5:29 PM
To: Együd Csaba
Cc: pgsql-general@xxxxxxxxxxxxxx
Subject: Re: [GENERAL] GRANT question

=?iso-8859-2?Q?Egy=FCd_Csaba?= <csegyud@xxxxxxx> 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.
 



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux