Re: relation does not exist!?

On Jul 10, 2005, at 9:12 AM, Søren Poulsen wrote:

> Just installed postgresql today - I keep getting the error
> "relation ... does not exist"
> when I try some simple selects. This is the scenario:
>
> Created a user X and a schema by the same name X using pgAdmin (pg
> 8.0.3) , and set
> the user as owner of the schema.
> Then I created a table Y under schema X, and set user X as owner of
> the table. Then
> I put some rows in the table.
> As postgres user when I try "select * from Y" I get the error
> "relation Y does not exist".
> I have tried "select * from X.Y", same error. The I tried logging
> in as X and executing the
> select, but still get the same error. I have also tried the same
> select from a Java program
> using JDBC and get the same error. What am I doing wrong?

Perhaps you created the table (or schema) with the name quoted. By
default, PostgreSQL folds names to lower case. So to "select * from
Y" there has to be a table named with a lowercase 'y'. If the table
name is really a capital 'Y' you need:

select * from "Y"
or
select * from "X"."Y"
depending on the name of the schema.

Click on the table in pgAdmin and look at the SQL definition to see
if the names are quoted.

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL