Re: Missing Schema

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: James Neville <james(dot)neville(at)babcockbrown(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Missing Schema
Date: 2004-01-14 19:22:31
Message-ID: 5021.1074108151@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

James Neville <james(dot)neville(at)babcockbrown(dot)com> writes:
> Only recently, we have noticed the abscence of any schemas.

It's not possible that the database contains *no* schemas. You are
being way too imprecise in describing the problem.

> The product issues queries like:
> SELECT * FROM dbname.public.users;

> Obviously, the JDBC Driver making the SQL query fails on 'public'.

What's obvious about it? And what exactly is the error message?

I suspect you are completely misinterpreting what you are seeing.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Michael Adler 2004-01-14 21:46:18 Re: vacuum slowed by syslogd
Previous Message James Neville 2004-01-14 18:35:05 Re: Resolved - Missing Schema