pgAdmin III 1.22.2
Postgresql 9.6.1
Windows 7
When trying to create a new primary key for a table, get the error:
An error has occurred:
ERROR: column "amgettuple" does not exist
LINE 1: ...am WHERE EXISTS (SELECT 1 FROM pg_proc WHERE oid=amgettuple...
If you continue and try to add a primary key column:
An error has occurred:
ERROR: syntax error at or near "AND"
LINE 1: SELECT opcname FROM pg_opclass WHERE opcmethod= AND NOT opcd...
The primary key cannot be added.
On 11/10/2016 8:55 AM, Dave Page wrote:
> I've just pushed a final wrap-up build of pgAdmin III to the download
> site in source, Windows and Mac OS X formats. You can download it from
> here:
>
> https://www.postgresql.org/ftp/pgadmin3/release/v1.22.2/
>
> This will be the final official release of pgAdmin III, produced as a
> result of a number of requests to wrap up the last few bug fixes that
> didn't make it into previous releases:
>
> 2016-11-10 DP 1.22.2 Enable use with PostgreSQL 9.6.
> 2016-09-20 MHA 1.22.2 Add classid filter to queries on pg_depend
> 2016-06-13 DP 1.22.2 Include the Negator when reverse engineering
> SQL for operators [Julien Rouhaud]
> 2016-03-22 DP 1.22.2 Fix the psql plugin command on OSX to work more
> reliably [Nicola Vitacolonna]
> 2016-02-16 DP 1.24.0 Allow multiple SQL editor tabs to be used in
> the query tool [Sergey Busel]
> 2016-02-16 DP 1.22.2 Prevent a crash in some situtions where the
> database connection is lost and needs to be reset.
> 2016-02-11 DP 1.22.2 Fix display of elapsed query time for queries
> running longer than 1 hour [Иван Полещук]
>
> Many thanks to all those who have been involved with the development,
> testing and other aspects of pgAdmin III over the years.
>
>
