The article at stackoverflow is here <https://stackoverflow.com/questions/57226520/select-does-not-return-values-postgres-11-4>
On Thu, 1 Aug 2019 at 17:28, Tony Shelver <tshel...@gmail.com> wrote: > Thanks for the replies: the version is PG11.4. > > As for needing to upgrade: I just want to fix the problem. This was a > working environment until I updated pgAdmin4. > > The fix suggested on Stackoverflow was to move to psycopg2 2.8, but it > doesn't seem to be possible. > > If there is another fix that anyone is aware of, I would love to know. > > I tried to uninstall pgAdmin4, then install psycopg 2.8 via pip, then > reinstall pgadmoin4 again using the Synatpic / Ubunto package manager, but > it just installs pscopg2.7 over the top. > > On Thu, 1 Aug 2019 at 16:50, Adrian Klaver <adrian.kla...@aklaver.com> > wrote: > >> On 8/1/19 7:39 AM, Tony Shelver wrote: >> > I am getting an 'able oid' when querying any tables using the Query >> tool. >> > When using the view / edit data option, everything works fine. >> >> Should have asked in previous post: >> >> What Postgres version(s)? >> >> > >> > I came across this >> > <<< >> > >> > The problem is due to python3-psycopg2. The latest pgadmin4 version >> > requires psycopg2-2.8. But if you're on Debian/Ubuntu stable, apt >> > installed v2.7. So you need to update it with pip : >> > >> > |sudo pip3 install -U psycopg2 >> >>>> >> > | >> > >> > |The problem is that the upgrade to psycopg 2.8 doesn't work, as it's >> > installed as part of the dtsutils package along with pgadmin4. >> > >> > | >> > >> > |Any ideas? >> > | >> > >> >> >> -- >> Adrian Klaver >> adrian.kla...@aklaver.com >> >
