Thread: [BUG] View the data in selected object - doenst work as excpected.
<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>
Hello pgAdmin mailinglist,
First our test setup:
We are using pgpool2 3.2x as load balancer and connection proxy for a postgresql 9.2x streaming replication Cluster. Our Application connects to pgpool and pgpool is load balancing, caching etc. the workload.
We are using pgAdminIII 1.16 from our windows 7 workstations to manually connect to the pgpool proxy to change data, create tables etc.
Now the Problem:
If we are selecting a table in pgAdmin and then click on the “view the data in selected object.” button, the contents of the table are shown properly. Then we change for example a bool value in a column and press the save button, the change is shown correctly, too. But if we now click on the refresh button the change is gone. It was reset to the original data before the change! Or so it seems…
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 restart pgAdmin while it is connected to pgpool-proxy the change is not displayed correctly on it.
First I thought it may be a pgpool problem but then I tried not to click on the button but right clicking on the table -> “View Data” -> “View top 100 Rows” and I was surprised to see the correct Values. If I try “View all data” from the same context menu instead it shows me the wrong data again. Same goes for applying a filter the Button uses the wrong data but if I try the context menu ->” View Data” -> “View Filtered Rows” it works properly and uses the right data.
It’s the same for several machines in our company. This seems to be a Bug in the current version of pgAdmin. If not maybe anyone from the list can aid us to get a suitable solution.
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company