Skip to main content

Posts

Showing posts from April, 2017

Postgresql 9.6 and Pgadmin3 trouble

Yesterday, I updated my PostgreSQL to the latest version 9.6 from version 9.5. The upgrade process went successfully, unfortunately pgadmin choked a little bit dealing with PostgreSQL 9.6, everytime we want to define primary key an error is thrown: ERROR: column "amgettuple" does not exist LINE 1: ...am WHERE EXISTS (SELECT 1 FROM pg_proc WHERE oid=amgettuple... we can ignore this error and the primary key creation will succeed, however it is annoying. My pgadmin was the latest version: pgadmin3 v 1.22.2 Visiting  https://pgadmin.org/download/source.php  reveals that this version is the final version and won't be supported anymore. We are encouraged to use pgadmin4 instead. I then downloaded and installed pgadmin4, installation was a pain in ass but I succeeded got it installed. However, pgadmin4 was terribly very slow. It also got a problem with the function debugger. After function parameters entry, the debugger is showed, unfortunately it only shows