On Sat, Nov 26, 2005 at 06:13:21PM +0100, Egyd Csaba wrote:
> Regarding the search_path it is the same in both cases:
>
> # show search_path;
> search_path
> --------------
> $user,public
> (1 row)
For different users, the above represents *different* search paths
because $user is expanded to the user name if a schema exists with
that name.
What does "\df edenproc_usesysid" show in psql? If it shows nothing
then try wildcarding the name, like "\df *eden*". If it still
shows nothing, are you sure you're connecting to the same database?
What does "SELECT current_database();" show for each user?
--
Michael Fuhr