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

relation does not exist!?

From: Søren Poulsen <wmsopou(at)hotmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: relation does not exist!?
Date: 2005-07-10 13:12:49
Message-ID: BAY16-F12F70E4F4D3F588D24BD00A3DD0@phx.gbl (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
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?

Få alle de nye og sjove ikoner med MSN Messenger


pgsql-novice by date

Next:From: John DeSoiDate: 2005-07-10 14:27:05
Subject: Re: relation does not exist!?
Previous:From: Bruno Wolff IIIDate: 2005-07-09 23:06:23
Subject: Re: integer and ''

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