X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5CDB6D1B1C8 for ; Fri, 9 Jul 2004 18:13:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 01784-07 for ; Fri, 9 Jul 2004 21:13:03 +0000 (GMT) Received: from web21402.mail.yahoo.com (web21402.mail.yahoo.com [216.136.232.72]) by svr1.postgresql.org (Postfix) with SMTP id 384B6D1B1B9 for ; Fri, 9 Jul 2004 18:12:57 -0300 (ADT) Message-ID: <20040709211259.15378.qmail@web21402.mail.yahoo.com> Received: from [12.32.94.66] by web21402.mail.yahoo.com via HTTP; Fri, 09 Jul 2004 14:12:59 PDT Date: Fri, 9 Jul 2004 14:12:59 -0700 (PDT) From: "Marie G. Tuite" Subject: Re: seeing tables across databases To: Jodi Kanter , Postgres Admin List In-Reply-To: <40EEF51B.7030705@virginia.edu> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200407/123 X-Sequence-Number: 14191 --- Jodi Kanter wrote: > I am working with a colleague who is using postgres > to create a number > of databases. On his system when he views his tables > (\d) he can see > tables from other databases - not all of them but > some. He cannot access > them as the user he is signed in as because he does > not have privileges, > but he can see them. When he dropped that database > and then recreated it > (without making tables) he could then only see those > few tables from the > other database. > I had him run a revoke all on public first but that > did not correct it. > Strangly enough he cannot see many of the other > tables from other > databases. > I have several databases on my system and do not > have this problem. Is > there some setting that I am not aware of that could > explain this > situation? thoughts? > Thanks > Jodi Kanter The tables visible before adding new tables -- presumably these are the tables present in the template being used to create the database? __________________________________ Do you Yahoo!? Yahoo! Mail Address AutoComplete - You start. We finish. http://promotions.yahoo.com/new_mail