pgAdmin Error when trying to run a simple SELECT
От | Brad Smith |
---|---|
Тема | pgAdmin Error when trying to run a simple SELECT |
Дата | |
Msg-id | A51777EE23640141A17640B11E6637FA036926@rdaex01.rdac.com.au обсуждение исходный текст |
Ответы |
Re: pgAdmin Error when trying to run a simple SELECT
|
Список | pgadmin-support |
<div class="Section1"><p class="MsoNormal"><font face="Times New Roman" size="3"><span lang="EN-US" style="font-size:12.0pt">HelloCananyone help with an error I’m suddenly getting in PgAdmin II.</span></font><p class="MsoNormal"><fontface="Times New Roman" size="3"><span lang="EN-US" style="font-size:12.0pt"> </span></font><p class="MsoNormal"><fontface="Times New Roman" size="3"><span lang="EN-US" style="font-size:12.0pt">My problem is this: WheneverI try to run an SQL statement like:</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><spanlang="EN-US" style="font-size:12.0pt">SELECT * from refUSERS;</span></font><p class="MsoNormal"><font face="TimesNew Roman" size="3"><span lang="EN-US" style="font-size:12.0pt">I get an error:</span></font><p class="MsoNormal"><fontface="Times New Roman" size="3"><span lang="EN-US" style="font-size:12.0pt">ERROR: Relation "refusers"does not exist.</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span lang="EN-US" style="font-size:12.0pt"> </span></font><pclass="MsoNormal"><font face="Times New Roman" size="3"><span lang="EN-US" style="font-size:12.0pt">I'vetried other simple SELECT statements but get the same message.</span></font><p class="MsoNormal"><fontface="Times New Roman" size="3"><span lang="EN-US" style="font-size:12.0pt"> </span></font><p class="MsoNormal"><fontface="Times New Roman" size="3"><span lang="EN-US" style="font-size:12.0pt">I can't for the life ofme understand what's changed.</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span lang="EN-US"style="font-size:12.0pt"> </span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><span lang="EN-US"style="font-size:12.0pt">I can use other databases using the same login credentials and login procedures andthe error does not occur when using them; it only seems to occur with this particular database. I can ‘see’ the databasefine in the Menu Tree. I can drill down to the tables and I can see the table data by clicking on the Sunglassesicon – I just can’t seem to run a basic query.</span></font><p class="MsoNormal"><font face="Times New Roman" size="3"><spanlang="EN-US" style="font-size:12.0pt">Can any one help/suggest anything at all? Do I need to prefix the tablename with something? (although I never had to before)</span></font><p class="MsoNormal"><font face="Times New Roman"size="3"><span lang="EN-US" style="font-size:12.0pt"> </span></font><p class="MsoNormal"><font face="Times New Roman"size="3"><span lang="EN-US" style="font-size:12.0pt">Brad.</span></font></div>
В списке pgadmin-support по дате отправления: