Обсуждение: Final pgAdmin III - v1.22.2 Released

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.


--
Dave Page, pgAdmin Project Lead
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

Oops, sorry - that shouldn't have been listed. It wasn't included as
it's a new feature and hasn't had any QA.

On Thu, Nov 10, 2016 at 4:28 PM, Adam Brusselback
<adambrusselback@gmail.com> wrote:
> Regarding: 2016-02-16 DP  1.24.0  Allow multiple SQL editor tabs to be used
> in the query tool [Sergey Busel]
>
> I am not seeing that change in this release.  I see the commit on master,
> but I don't see the changes in the source download for this release tag. Was
> very much looking forward to having that rolled in.



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

On 2016-11-10 16:55, 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.
>
>

Thanks a lot, Dave!

> 2016-02-16 DP  1.22.2  Prevent a crash in some situtions where the
> database connection is lost and needs to be reset.

That one is simply a great relief to have fixed - thanks again :-).

Cheers
-- Jan Holst Jensen

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.
>
>

On Sun, Nov 20, 2016 at 1:49 AM, Jeff Janes <jeff.janes@gmail.com> wrote:
> On Thu, Nov 10, 2016 at 7:55 AM, Dave Page <dpage@pgadmin.org> 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/
>
>
>
> The above download is not listed on the page:
>
> https://www.pgadmin.org/download/windows.php

Oops, I missed all the links :-/. I've pushed a fix now, so they
should show up within an hour.

Thanks.

--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

So long an thanks for all the fish!

How does the final release of pgadmin III v1.22.2 compare to the BigSQL release "pgAdmin3 LTS 1.23.0a" A later version number, released earlier?

https://bigsql.com/components.jsp
https://bigsql.org/pgadmin3/index.jsp

Which one would you recommend as final version?