I am using Stretch, and have installed PostgreSQL 9.6 (9.6.2-2) and pgAdmin3
(1.22.2-1) from the Stretch repo.
But it seems that pgAdmin3 doesn't work with PostgreSQL 9.6. I get errors when
trying to add a primary key, both when creating a table and when trying to add
it later:
An error has occurred:
09:04:41 AM: Error: ERROR: column "amgettuple" does not exist
LINE 1: ..._am WHERE EXISTS (SELECT 1 FROM pg_proc WHERE oid=amgettuple...
^
It's the same error described by someone else in this post:
http://stackoverflow.com/q/40904102/994153
where the solution was to switch from pgAdmin III to pgAdmin version 4.
So it seems important to update this key PostgreSQL tool to the version that
supports the latest version of PostgreSQL that is also in Stretch.
