[BUG] View the data in selected object - doenst work as excpected.

Поиск
Список
Период
Сортировка
От Lars Müller-Gilberger
Тема [BUG] View the data in selected object - doenst work as excpected.
Дата
Msg-id 0f8d4749-6879-49a2-8d00-2c949a16d61d@ergovia.de
обсуждение исходный текст
Ответы Re: [BUG] View the data in selected object - doenst work as excpected.  (Dave Page <dpage@pgadmin.org>)
Список pgadmin-support
<div class="WordSection1"><p class="MsoNormal"><span lang="EN-US">Hello pgAdmin mailinglist,</span><p
class="MsoNormal"><spanlang="EN-US"> </span><p class="MsoNormal"><span lang="EN-US">First our test setup: </span><p
class="MsoNormal"><spanlang="EN-US">We are using pgpool2 3.2x as load balancer and connection proxy for a postgresql
9.2xstreaming replication Cluster. Our Application connects to pgpool and pgpool is load balancing, caching etc. the
workload.</span><pclass="MsoNormal"><span lang="EN-US">We are using pgAdminIII 1.16 from our windows 7 workstations to
manuallyconnect to the pgpool proxy to change data, create tables etc. </span><p class="MsoNormal"><span
lang="EN-US">Nowthe Problem:</span><p class="MsoNormal"><span lang="EN-US">If we are selecting a table in pgAdmin and
thenclick on the “view the data in selected object.”  button, the contents of the table are shown properly. Then we
changefor example a bool value in a column and press the save button, the change is shown correctly, too. But if we now
clickon the refresh button the change is gone. It was reset to the original data before the change! Or so it seems…
</span><pclass="MsoNormal"><span lang="EN-US">If I take a look at the db-servers using pgAdmin the change is shown
correctly.Psql shows the correct data on db-servers and on the pgpool-proxy too.  But even if I refresh, reconnect or
restartpgAdmin while it is connected to pgpool-proxy the change is not displayed correctly on it.</span><p
class="MsoNormal"><spanlang="EN-US">First I thought it may be a pgpool problem but then I tried not to click on the
buttonbut right clicking on the table -> “View Data” -> “View top 100 Rows” and I was surprised to see the
correctValues. If I try “View all data” from the same context menu instead it shows me the wrong data again. Same goes
forapplying a filter the Button uses the wrong data but if I try the context menu ->” View Data” -> “View
FilteredRows”  it works properly and uses the right data. </span><p class="MsoNormal"><span lang="EN-US">It’s the same
forseveral machines in our company. This seems to be a Bug in the current version of pgAdmin. If not maybe anyone from
thelist can aid us to get a suitable solution.</span><p class="MsoNormal"><span lang="EN-US"> </span><p
class="MsoNormal">Kindregards,<p class="MsoNormal"> <p class="MsoNormal">Lars Müller-Gilberger<p
class="MsoNormal"><spanstyle="font-size:9.0pt;font-family:"Arial","sans-serif";color:black">Technik</span><p
class="MsoNormal"style="background:white"><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:black"><img
alt="cid:FF9B02A9-56F3-4657-9064-A113D83F0535"height="44" id="Bild_x0020_1" src="cid:image001.png@01CDB776.FEA591E0"
width="90"/><br />ergovia GmbH<br />Knooper Weg 107<br />24116 Kiel</span><p class="MsoNormal"
style="background:white"><spanlang="EN-US" style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222">Tel:
0431/ 98 260 60</span><p class="MsoNormal" style="background:white"><span lang="EN-US"
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222">Fax:0431 / 98 260 666</span><p
class="MsoNormal"style="background:white"><span lang="EN-US"
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222">E-Mail: </span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222"><ahref="mailto:info@ergovia.de"
target="_blank"><spanlang="EN-US" style="color:blue">info@ergovia.de</span></a></span><span lang="EN-US"
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222"><br/></span><b><span lang="EN-US"
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222">KUNDENPORTAL: </span></b><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222"><ahref="https://kundenportal.ergovia.de/"
target="_blank"><spanlang="EN-US" style="color:blue">https://kundenportal.ergovia.de</span></a></span><span
lang="EN-US"style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222"></span><p class="MsoNormal"
style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;background:white"><ahref="http://www.ergovia.de/"
target="_blank"><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif";color:blue;text-decoration:none"><img
alt="marke"border="0" height="81" id="Bild_x0020_2" src="cid:image002.png@01CDB776.FEA591E0" width="583"
/></span></a><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222"></span><p class="MsoNormal"
style="background:white"><spanstyle="font-size:8.0pt;font-family:"Arial","sans-serif";color:#222222">Registergericht:
AGKiel HRB 6727-KI<br />Steuernummer: 19 294 20584</span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222"></span><pclass="MsoNormal"><span
style="font-size:8.5pt;font-family:"Arial","sans-serif";color:#222222">USt-IdNr.:DE221174665</span><span
style="font-size:12.0pt;font-family:"TimesNew Roman","serif";color:black"></span><p class="MsoNormal"><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#222222">Geschäftsführer:<br/>Jens Buchloh<br />Silke
Buschtöns</span><spanstyle="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222"><br /></span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#222222"> </span><span
style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#222222"><br/></span><span
style="font-size:8.0pt;font-family:"Arial","sans-serif";color:#222222">DieseE-Mail und ihre etwaig vorhandenen Anhänge
sindausschließlich für den beabsichtigten Empfänger bestimmt und können vertrauliche Informationen enthalten. Jegliche
vomAbsender nicht ausdrücklich oder durch eindeutiges schlüssiges Verhalten (welches nicht mit der Übersendung der
E-Mailbegründet wird) beabsichtigte Veröffentlichung, Vervielfältigung, Weiterleitung oder anderweitige Verwertung ist
untersagtund kann straf- oder zivilrechtlich verfolgt werden. Falls Sie diese E-Mail irrtümlich erhalten haben, bitten
wirSie um kurze Nachricht per Telefon oder Fax. Bitte löschen Sie die E-Mail und alle eventuell vorhandenen Kopien
unverzüglichvon Ihrem Computer-System und veranlassen Sie die Löschung etwaig vorhandener Backups auf anderen
Datenträgern,wenn Sie nicht der beabsichtigte Empfänger sein sollten.</span><p class="MsoNormal"> </div> 

В списке pgadmin-support по дате отправления:

Предыдущее
От: Sachin Srivastava
Дата:
Сообщение: Re: bug report: All queries incorrectly shown as blocking in server status
Следующее
От: Dave Page
Дата:
Сообщение: Re: [BUG] View the data in selected object - doenst work as excpected.