Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group