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
