relation does not exist!?
От | Søren Poulsen |
---|---|
Тема | relation does not exist!? |
Дата | |
Msg-id | BAY16-F12F70E4F4D3F588D24BD00A3DD0@phx.gbl обсуждение исходный текст |
Ответы |
Re: relation does not exist!?
|
Список | 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 http://messenger.msn.dk/
В списке pgsql-novice по дате отправления: