| From: | Michael Fuhr <mike(at)fuhr(dot)org> |
|---|---|
| To: | Együd Csaba <csegyud(at)vnet(dot)hu> |
| Cc: | "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: GRANT question |
| Date: | 2005-11-26 17:28:10 |
| Message-ID: | 20051126172810.GA2801@winnie.fuhr.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Sidney-Woollett | 2005-11-26 17:41:45 | Re: Resend: Question about PostgreSQL, pgpool, and Postfix |
| Previous Message | Tom Lane | 2005-11-26 17:23:08 | Re: GRANT question |