pgAdmin 4 commit: Update dialogue error styling to match alerts

[Dave Page]

Update dialogue error styling to match alerts

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=d56f1d847c946f43bebbfbdefb929870f0050694
Author: Joao Pedro De Almeida Pereira 

Modified Files
--
web/pgadmin/browser/templates/browser/js/node.js | 12 ++-
web/pgadmin/dashboard/static/css/dashboard.css   |  6 ++
web/pgadmin/static/css/bootstrap.overrides.css   | 25 ++-
web/pgadmin/static/scss/_alert.scss  | 93 +++-
web/pgadmin/static/scss/_backform.overrides.scss | 21 ++
web/pgadmin/static/scss/_othercolors.scss| 19 +++--
web/pgadmin/static/scss/pgadmin.scss |  5 +-
7 files changed, 150 insertions(+), 31 deletions(-)

Re: [pgadmin-hackers][patch] Update the error alerts style in dialog

[Dave Page]

Thanks, applied.

On Fri, Jul 7, 2017 at 9:53 PM, Joao De Almeida Pereira <
jdealmeidapere...@pivotal.io> wrote:

> Hi Hackers,
>
> We updated the style of the error alerts in the dialogs window to match
> the style guide. Below is a screenshot of how it looks:
>
> [image: Inline image 1]
>
>
> Thanks
> Shruti & Joao
>



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

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

pgAdmin 4 commit: Fix history view in IE11.

[Dave Page]

Fix history view in IE11.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=c02ac2ac66ff27f6994b1d36edc2a2f99a67a161
Author: Sarah McAlear 

Modified Files
--
web/package.json | 1 +
web/yarn.lock| 6 +++---
2 files changed, 4 insertions(+), 3 deletions(-)

Re: [pgadmin4][patch] fix history panel on ie11

[Dave Page]

Thanks, applied.

On Sat, Jul 8, 2017 at 12:03 AM, Sarah McAlear  wrote:

> Hi Hackers!
>
> This patch fixes the layout issues on IE11. There is a known issue on
> react-split-pane that requires a previous version of bowser in order to
> render correctly on IE11. We had to downgrade the version of bowser to
> 1.6.1 until the relevant pull request to react-split-pane has been accepted.
>
> Thanks!
> Sarah & Rob
>
>
>


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

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

pgAdmin 4 commit: Use the correct font for alerts on IE.

[Dave Page]

Use the correct font for alerts on IE.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=907c5fe1984ead9d1df1c7d0dbe458f9ab607488
Author: Murtuza Zabuawala 

Modified Files
--
web/pgadmin/static/scss/_alert.scss | 2 ++
1 file changed, 2 insertions(+)

Build failed in Jenkins: pgadmin4-master-python35 #226

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Update dialogue error styling to match alerts

[Dave Page] Fix history view in IE11.

[Dave Page] Use the correct font for alerts on IE.

--
[...truncated 313.86 KB...]
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Create partitions of existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing list 
partitioned table)
SynonymAddTestCase (Default Node URL)
ResourceGroupsAddTestCase (Add resource groups)
SynonymPutTestCase (Fetch synonym Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsDeleteTestCase (Delete resource groups)
PackageGetTestCase (Fetch Package Node URL)
PackageAddTestCase (Fetch Package Node URL)
ResourceGroupsPutTestCase (Put resource groups)
SynonymGetTestCase (Fetch synonym Node URL)
ResourceGroupsGetTestCase (Get resource groups)

EDB Postgres AS 9.3:

165 tests passed
0 tests failed
6 tests skipped:
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
ResourceGroupsDeleteTestCase (Delete resource groups)
ResourceGroupsGetTestCase (Get resource groups)
ResourceGroupsPutTestCase (Put resource groups)
TableUpdateTestCase (Create partitions of existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing list 
partitioned table)
ResourceGroupsAddTestCase (Add resource groups)

PostgreSQL 9.2:

149 tests passed
0 tests failed
22 tests skipped:
PackagePutTestCase (Fetch Package Node URL)
EventTriggerPutTestCase (Fetch Event Trigger Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
ResourceGroupsGetTestCase (Get resource groups)
ViewsGetTestCase (Get materialized view under schema node)
ResourceGroupsPutTestCase (Put resource groups)
ViewsUpdateTestCase (Update materialized view under schema node)
SynonymPutTestCase (Fetch synonym Node URL)
EventTriggerAddTestCase (Fetch Event Trigger Node URL)
PackageGetTestCase (Fetch Package Node URL)
PackageAddTestCase (Fetch Package Node URL)
EventTriggerDeleteTestCase (Fetch Event Trigger Node URL)
SynonymAddTestCase (Default Node URL)
ViewsDeleteTestCase (Delete materialized view under schema node)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
ViewsAddTestCase (Add materialized view under schema node)
TableUpdateTestCase (Create partitions of existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing list 
partitioned table)
ResourceGroupsAddTestCase (Add resource groups)
EventTriggerGetTestCase (Fetch Event Trigger Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsD

pgAdmin 4 commit: Fix history font on IE.

[Dave Page]

Fix history font on IE.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=2dfa6223574d6a16bc5144462a1e440df80649d4

Modified Files
--
web/pgadmin/static/scss/_typography.scss | 8 
1 file changed, 4 insertions(+), 4 deletions(-)

Jenkins build is back to normal : pgadmin4-master-python35 #227

[pgAdmin 4 Jenkins]

See 

pgAdmin 4 commit: Update Mingw build for changes in QtWebKit

[Dave Page]

Update Mingw build for changes in QtWebKit

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=55b1e7b186f2eeb3047ef5d093cb3df30e4baf92

Modified Files
--
Make-MinGW.bat | 25 +
1 file changed, 17 insertions(+), 8 deletions(-)

pgagent build issue on SLES 12

[Devrim Gündüz]

Hi,

I'm trying to RPMify pgagent on SLES 12, but getting an error. Here is the
command I'm using (like I did for RHEL)

cmake -D CMAKE_INSTALL_PREFIX:PATH=/usr -D 
PG_CONFIG_PATH:FILEPATH=/usr/pgsql-9.6/bin/pg_config -D STATIC_BUILD:BOOL=OFF  

Error is:

CMake Error at cmake/FindWX.cmake:271 (MESSAGE):
  The selected wxWidgets configuration (version: 2.8, debug: no, static: no,
  unicode: yes, modules: base) is not available.
Call Stack (most recent call first):
  CMakeLists.txt:95 (FIND_PACKAGE)

and here is the CMakeOutput.log:

https://www.gunduz.org/temp/pgagent-CMakeOutput.log

Any hints how can I debug this?

Regards,
-- 
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

Re: pgagent build issue on SLES 12

[Dave Page]

On Mon, Jul 10, 2017 at 12:59 PM, Devrim Gündüz  wrote:

>
> Hi,
>
> I'm trying to RPMify pgagent on SLES 12, but getting an error. Here is the
> command I'm using (like I did for RHEL)
>
> cmake -D CMAKE_INSTALL_PREFIX:PATH=/usr -D 
> PG_CONFIG_PATH:FILEPATH=/usr/pgsql-9.6/bin/pg_config
> -D STATIC_BUILD:BOOL=OFF
>
> Error is:
>
> CMake Error at cmake/FindWX.cmake:271 (MESSAGE):
>   The selected wxWidgets configuration (version: 2.8, debug: no, static:
> no,
>   unicode: yes, modules: base) is not available.
> Call Stack (most recent call first):
>   CMakeLists.txt:95 (FIND_PACKAGE)
>
> and here is the CMakeOutput.log:
>
> https://www.gunduz.org/temp/pgagent-CMakeOutput.log
>
> Any hints how can I debug this?
>

What wxWidgets configs are available on that machine?

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

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

pgAdmin 4 commit: Refresh nodes correctly when there is a single child

[Dave Page]

Refresh nodes correctly when there is a single child that is updated. Fixes 
#2532

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=ecd95141f3c89aa19e6723799c6cfe41db066d22
Author: Khushboo Vashi 

Modified Files
--
.../browser/templates/browser/js/browser.js| 56 ++
1 file changed, 36 insertions(+), 20 deletions(-)

Re: [pgAdmin4][Patch]: Fixed #2532 - Left side tree: The node disappears on update if there is only one child exist for that category.

[Dave Page]

Thanks, patch applied.

On Mon, Jul 10, 2017 at 7:07 AM, Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:

> Hi,
>
> Please find the attached patch to fix the RM #2532 : Left side tree: The
> node disappears on update if there is only one child exist for that
> category.
>
>
> Thanks,
> Khushboo
>



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

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

Re: pgagent build issue on SLES 12

[Ashesh Vashi]

You can find the logs/temporary files in the CMakeFiles directory.

On Jul 10, 2017 17:48, "Dave Page"  wrote:

>
>
> On Mon, Jul 10, 2017 at 12:59 PM, Devrim Gündüz  wrote:
>
>>
>> Hi,
>>
>> I'm trying to RPMify pgagent on SLES 12, but getting an error. Here is the
>> command I'm using (like I did for RHEL)
>>
>> cmake -D CMAKE_INSTALL_PREFIX:PATH=/usr -D 
>> PG_CONFIG_PATH:FILEPATH=/usr/pgsql-9.6/bin/pg_config
>> -D STATIC_BUILD:BOOL=OFF
>>
>> Error is:
>>
>> CMake Error at cmake/FindWX.cmake:271 (MESSAGE):
>>   The selected wxWidgets configuration (version: 2.8, debug: no, static:
>> no,
>>   unicode: yes, modules: base) is not available.
>> Call Stack (most recent call first):
>>   CMakeLists.txt:95 (FIND_PACKAGE)
>>
>> and here is the CMakeOutput.log:
>>
>> https://www.gunduz.org/temp/pgagent-CMakeOutput.log
>>
>> Any hints how can I debug this?
>>
>
> What wxWidgets configs are available on that machine?
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

[pgAdmin4][Patch]: Fixed #2545 Partitioned table should be created using 'OF TYPE'

[Akshay Joshi]

Hi All

Attached is the patch file to fix the RM #2545, where user will be able to
create partitioned table using 'OF TYPE' feature of table dialog.

-- 
*Akshay Joshi*
*Principal Software Engineer *



*Phone: +91 20-3058-9517Mobile: +91 976-788-8246*


RM_2545.patch
Description: Binary data

pgAdmin 4 commit: Fix IE11 alert layout again.

[Dave Page]

Fix IE11 alert layout again.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=33e56272ca2430a2a85184951568ad324796bf94
Author: Surinder Kumar 

Modified Files
--
web/pgadmin/static/scss/_alertify.overrides.scss | 4 
1 file changed, 4 insertions(+)

Re: pgagent build issue on SLES 12

[Devrim Gündüz]

Hi Dave,

On Mon, 2017-07-10 at 13:18 +0100, Dave Page wrote:
> What wxWidgets configs are available on that machine?

wxWidgets-3_2-devel-3.1.0

is installed. I also have a few packages that start with libwx_gtk2 and
libwx_gtk3, but not sure they are related.

Regards,

-- 
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

Re: pgagent build issue on SLES 12

[Dave Page]

On Mon, Jul 10, 2017 at 1:59 PM, Devrim Gündüz  wrote:

>
> Hi Dave,
>
> On Mon, 2017-07-10 at 13:18 +0100, Dave Page wrote:
> > What wxWidgets configs are available on that machine?
>
> wxWidgets-3_2-devel-3.1.0
>

I have no idea if pgAgent will work with wxWidgets 3. Are there wx 2.8
packages available?

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

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

Re: pgagent build issue on SLES 12

[Devrim Gündüz]

Hi Ashesh,

On Mon, 2017-07-10 at 17:56 +0530, Ashesh Vashi wrote:
> You can find the logs/temporary files in the CMakeFiles directory.

I have sent the log file with the previous email:

https://www.gunduz.org/temp/pgagent-CMakeOutput.log

Regards,
-- 
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

pgAdmin 4 commit: Handle un-mounted drives correctly on Windows. Fixes

[Dave Page]

Handle un-mounted drives correctly on Windows. Fixes #1999

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=6d3d2cd458aa74c677559a3c3b3c2fb44da4aa6f
Author: Murtuza Zabuawala 

Modified Files
--
web/pgadmin/misc/file_manager/__init__.py | 32 ++-
1 file changed, 31 insertions(+), 1 deletion(-)

Re: [pgAdmin4][Patch] To fix "there is no disk..." warning in Windows

[Dave Page]

Thanks, applied.

On Mon, Jul 10, 2017 at 1:26 PM, Murtuza Zabuawala <
murtuza.zabuaw...@enterprisedb.com> wrote:

> Hi,
>
> PFA patch to fix the issue in Windows where Windows throws warning "there
> is no disk..." if user do not have a removable disk in the removable disk
> drive while opening File Manager.
> RM#1999
>
> I was able to reproduce issue by following steps on Windows:
> 1. Open Query tool, type 'SELECT 1;'
> 2. Save the file to your removable drive.
> 3. Eject that removable drive.
> 4. Now click Open button in Query tool, you will get error.
>
> --
> Regards,
> Murtuza Zabuawala
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>



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

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

[pgAdmin4][Patch]: Fixed RM #1165 - Too many request to update dashboard graphs when server is disconnected.

[Khushboo Vashi]

Hi,

Please find the attached patch to fix the RM #1165 - Too many request to
update dashboard graphs when server is disconnected.

Thanks,
Khushboo
diff --git a/web/pgadmin/dashboard/templates/dashboard/js/dashboard.js b/web/pgadmin/dashboard/templates/dashboard/js/dashboard.js
index 34a1ab7..e858faa 100644
--- a/web/pgadmin/dashboard/templates/dashboard/js/dashboard.js
+++ b/web/pgadmin/dashboard/templates/dashboard/js/dashboard.js
@@ -89,28 +89,35 @@ function(r, $, pgAdmin, _, Backbone, gettext) {
 );
 
 if (div) {
-// Avoid unnecessary reloads
-if (url != $(dashboardPanel).data('dashboard_url')) {
-// Clear out everything so any existing timers die off
+if (itemData.connected || _.isUndefined(itemData.connected)) {
+// Avoid unnecessary reloads
+if (url != $(dashboardPanel).data('dashboard_url')) {
+// Clear out everything so any existing timers die off
+$(div).empty();
+
+$.ajax({
+url: url,
+type: "GET",
+dataType: "html",
+success: function (data) {
+$(div).html(data);
+},
+error: function (xhr, status) {
+$(div).html(
+'' + gettext('An error occurred whilst loading the dashboard.') + ''
+);
+}
+});
+}
+}
+else {
 $(div).empty();
-
-$.ajax({
-url: url,
-type: "GET",
-dataType: "html",
-success: function (data) {
-$(div).html(data);
-},
-error: function (xhr, status) {
-$(div).html(
-'' + gettext('An error occurred whilst loading the dashboard.') + ''
-);
-}
-});
-
-// Cache the current IDs for next time
-$(dashboardPanel).data('dashboard_url', url);
+$(div).html(
+'' + gettext('Please connect to the selected server to view the dashboard.') + ''
+);
 }
+// Cache the current IDs for next time
+$(dashboardPanel).data('dashboard_url', url);
 }
 }
 }

pgAdmin 4 commit: Handle partitioned tables created "OF TYPE". Fixes #2

[Dave Page]

Handle partitioned tables created "OF TYPE". Fixes #2545

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=ed3cb7df417b3e0b4a1dc3da8d4224a09727412e
Author: Akshay Joshi 

Modified Files
--
.../servers/databases/schemas/tables/__init__.py   | 11 +-
.../schemas/tables/static/js/partition.utils.js| 18 +-
.../databases/schemas/tables/static/js/table.js| 39 +-
.../templates/table/sql/10_plus/properties.sql |  3 +-
.../templates/table/sql/9.1_plus/properties.sql|  3 +-
.../tables/templates/table/sql/default/create.sql  |  3 +-
6 files changed, 56 insertions(+), 21 deletions(-)

Re: [pgAdmin4][Patch]: Fixed #2545 Partitioned table should be created using 'OF TYPE'

[Dave Page]

Thanks, applied.

On Mon, Jul 10, 2017 at 1:30 PM, Akshay Joshi  wrote:

> Hi All
>
> Attached is the patch file to fix the RM #2545, where user will be able to
> create partitioned table using 'OF TYPE' feature of table dialog.
>
> --
> *Akshay Joshi*
> *Principal Software Engineer *
>
>
>
> *Phone: +91 20-3058-9517 <+91%2020%203058%209517>Mobile: +91 976-788-8246
> <+91%2097678%2088246>*
>



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

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

Re: [pgAdmin4][Patch]: Fixed RM #1165 - Too many request to update dashboard graphs when server is disconnected.

[Dave Page]

Hi

On Mon, Jul 10, 2017 at 2:14 PM, Khushboo Vashi <
khushboo.va...@enterprisedb.com> wrote:

> Hi,
>
> Please find the attached patch to fix the RM #1165 - Too many request to
> update dashboard graphs when server is disconnected.
>

If I disconnect the server, it doesn't stop trying to get data until I
refresh the browser by clicking on another node that causes it to reload.

If I then click back on the server node, it doesn't redraw the dashboard
and start displaying new data upon reconnect. I have to change nodes again
before it will respond to the re-connection.

Thanks.

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

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

Build failed in Jenkins: pgadmin4-master-python33 #229

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Fix IE11 alert layout again.

[Dave Page] Handle un-mounted drives correctly on Windows. Fixes #1999

[Dave Page] Handle partitioned tables created "OF TYPE". Fixes #2545

--
[...truncated 317.31 KB...]
Create partitions of existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Detach partition from existing range 
partitioned table)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsGetTestCase (Get resource groups)
ResourceGroupsAddTestCase (Add resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)

EDB Postgres AS 9.2:

156 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
14 tests skipped:
EventTriggerPutTestCase (Fetch Event Trigger Node URL)
ResourceGroupsPutTestCase (Put resource groups)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Detach partition from existing range 
partitioned table)
ResourceGroupsDeleteTestCase (Delete resource groups)
EventTriggerAddTestCase (Fetch Event Trigger Node URL)
ViewsAddTestCase (Add materialized view under schema node)
EventTriggerDeleteTestCase (Fetch Event Trigger Node URL)
EventTriggerGetTestCase (Fetch Event Trigger Node URL)
ViewsGetTestCase (Get materialized view under schema node)
ViewsUpdateTestCase (Update materialized view under schema node)
ResourceGroupsGetTestCase (Get resource groups)
ViewsDeleteTestCase (Delete materialized view under schema node)
ResourceGroupsAddTestCase (Add resource groups)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)

EDB Postgres AS 9.5:

168 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
2 tests skipped:
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Detach partition from existing range 
partitioned table)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)

EDB Postgres AS 9.4:

168 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
2 tests skipped:
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Detach partition from existing range 
partitioned table)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)

EDB Postgres AS 9.6:

168 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable s

Build failed in Jenkins: pgadmin4-master-python34 #220

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Fix IE11 alert layout again.

[Dave Page] Handle un-mounted drives correctly on Windows. Fixes #1999

[Dave Page] Handle partitioned tables created "OF TYPE". Fixes #2545

--
[...truncated 317.35 KB...]
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing range 
partitioned table)

EDB Postgres AS 9.6:

168 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
2 tests skipped:
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
TableUpdateTestCase (Create partitions of existing list 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing range 
partitioned table)

PostgreSQL 9.6:

157 tests passed
0 tests failed
14 tests skipped:
SynonymPutTestCase (Fetch synonym Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
PackageDeleteTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)
ResourceGroupsDeleteTestCase (Delete resource groups)
TableUpdateTestCase (Create partitions of existing list 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing range 
partitioned table)
ResourceGroupsAddTestCase (Add resource groups)
ResourceGroupsGetTestCase (Get resource groups)
ResourceGroupsPutTestCase (Put resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
PackagePutTestCase (Fetch Package Node URL)
PackageAddTestCase (Fetch Package Node URL)
SynonymAddTestCase (Default Node URL)

EDB Postgres AS 9.4:

168 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
2 tests skipped:
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
TableUpdateTestCase (Create partitions of existing list 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing range 
partitioned table)

PostgreSQL 9.5:

157 tests passed
0 tests failed
14 tests skipped:
SynonymPutTestCase (Fetch synonym Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
PackageDeleteTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)
ResourceGroupsDeleteTestCase (Delete resource groups)
TableUpdateTestCase (Create partitions of existing l

Build failed in Jenkins: pgadmin4-master-python27 #234

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Handle un-mounted drives correctly on Windows. Fixes #1999

[Dave Page] Handle partitioned tables created "OF TYPE". Fixes #2545

--
[...truncated 317.78 KB...]
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.5:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.4:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.3:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,

Build failed in Jenkins: pgadmin4-master-python36 #226

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Handle un-mounted drives correctly on Windows. Fixes #1999

[Dave Page] Handle partitioned tables created "OF TYPE". Fixes #2545

--
[...truncated 317.26 KB...]
PackageAddTestCase (Fetch Package Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
SynonymAddTestCase (Default Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
SynonymPutTestCase (Fetch synonym Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
TableUpdateTestCase (Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
ViewsAddTestCase (Add materialized view under schema node)
ViewsDeleteTestCase (Delete materialized view under schema node)
ViewsGetTestCase (Get materialized view under schema node)
ViewsUpdateTestCase (Update materialized view under schema node)
ResourceGroupsAddTestCase (Add resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsGetTestCase (Get resource groups)

PostgreSQL 9.3:

157 tests passed
0 tests failed
14 tests skipped:
PackageAddTestCase (Fetch Package Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
SynonymAddTestCase (Default Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
SynonymPutTestCase (Fetch synonym Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
TableUpdateTestCase (Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
ResourceGroupsAddTestCase (Add resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsGetTestCase (Get resource groups)

PostgreSQL 9.4:

157 tests passed
0 tests failed
14 tests skipped:
PackageAddTestCase (Fetch Package Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
SynonymAddTestCase (Default Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
SynonymPutTestCase (Fetch synonym Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
TableUpdateTestCase (Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
p

Build failed in Jenkins: pgadmin4-master-python35 #230

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Handle partitioned tables created "OF TYPE". Fixes #2545

--
[...truncated 317.20 KB...]
Create Range partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
PackageDeleteTestCase (Fetch Package Node URL)
ResourceGroupsAddTestCase (Add resource groups)
TableUpdateTestCase (Attach partition to existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Create partitions of existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
SynonymGetTestCase (Fetch synonym Node URL)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
PackageGetTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)

PostgreSQL 9.5:

157 tests passed
0 tests failed
14 tests skipped:
PackageAddTestCase (Fetch Package Node URL)
ResourceGroupsGetTestCase (Get resource groups)
SynonymAddTestCase (Default Node URL)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
PackageDeleteTestCase (Fetch Package Node URL)
ResourceGroupsAddTestCase (Add resource groups)
TableUpdateTestCase (Attach partition to existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Create partitions of existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
SynonymGetTestCase (Fetch synonym Node URL)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
PackageGetTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)

EDB Postgres AS 9.2:

156 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
14 tests skipped:
EventTriggerPutTestCase (Fetch Event Trigger Node URL)
ViewsAddTestCase (Add materialized view under schema node)
ResourceGroupsGetTestCase (Get resource groups)
ViewsUpdateTestCase (Update materialized view under schema node)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsAddTestCase (Add resource groups)
TableUpdateTestCase (Attach partition to existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Create partitions of existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
ResourceGroupsDeleteTestCase (Delete resource groups)
ViewsGetTestCase (Get materialized view under schema node)
EventTriggerGetTestCase (Fetch Event Trigger Node URL)
EventTriggerAddTestCase (Fetch Event Trigger Node URL)
EventTriggerDeleteTestCase (Fetch Event Trigger Node URL)
ViewsDeleteTestCase (Delete materialized view under schema node)

PostgreSQL 9.6:

157 tests passed
0 tests failed
14 tests skipped:
PackageAdd

pgAdmin 4 commit: Release notes for 1.6.

[Dave Page]

Release notes for 1.6.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=4bfb31b03b3c6f1337f5ef317c69569fdf940d6c
Author: Karen Blatchley 

Modified Files
--
docs/en_US/release_notes.rst |   1 +
docs/en_US/release_notes_1_6.rst | 102 +++
2 files changed, 103 insertions(+)

Build failed in Jenkins: pgadmin4-master-python26 #352

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Handle partitioned tables created "OF TYPE". Fixes #2545

--
[...truncated 321.98 KB...]
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.5:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.4:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.3:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,

pgAdmin 4 commit: Bump version numbers prior to release.

[Dave Page]

Bump version numbers prior to release.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=ea5dfe23a078080d98d8a549ff48efbdbc677974

Modified Files
--
runtime/Info.plist   | 4 ++--
runtime/pgAdmin4.pro | 2 +-
web/config.py| 4 ++--
3 files changed, 5 insertions(+), 5 deletions(-)

Build failed in Jenkins: pgadmin4-master-python33 #230

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Release notes for 1.6.

--
[...truncated 317.19 KB...]
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing list 
partitioned table)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)

EDB Postgres AS 9.4:

168 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
2 tests skipped:
TableUpdateTestCase (Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing list 
partitioned table)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)

EDB Postgres AS 9.5:

168 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
2 tests skipped:
TableUpdateTestCase (Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing list 
partitioned table)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)

EDB Postgres AS 9.2:

156 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
14 tests skipped:
EventTriggerAddTestCase (Fetch Event Trigger Node URL)
ViewsGetTestCase (Get materialized view under schema node)
EventTriggerPutTestCase (Fetch Event Trigger Node URL)
ViewsAddTestCase (Add materialized view under schema node)
ResourceGroupsPutTestCase (Put resource groups)
EventTriggerDeleteTestCase (Fetch Event Trigger Node URL)
TableUpdateTestCase (Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing list 
partitioned table)
ResourceGroupsAddTestCase (Add resource groups)
ViewsUpdateTestCase (Update materialized view under schema node)
ResourceGroupsGetTestCase (Get resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
EventTriggerGetTestCase (Fetch Event Trigger Node URL)
ViewsDeleteTestCase (Delete materialized view under schema node)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)

EDB Postgres AS 9.3:

164 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
6 tests skipped:
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsAddTestCase (Add resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
TableUpdateTestCase (Create partitions of existing list 
partitioned table,
Detach partition

Build failed in Jenkins: pgadmin4-master-python36 #227

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Release notes for 1.6.

[Dave Page] Bump version numbers prior to release.

--
[...truncated 317.14 KB...]
PackageAddTestCase (Fetch Package Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
SynonymAddTestCase (Default Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
SynonymPutTestCase (Fetch synonym Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
TableUpdateTestCase (Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
ViewsAddTestCase (Add materialized view under schema node)
ViewsDeleteTestCase (Delete materialized view under schema node)
ViewsGetTestCase (Get materialized view under schema node)
ViewsUpdateTestCase (Update materialized view under schema node)
ResourceGroupsAddTestCase (Add resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsGetTestCase (Get resource groups)

PostgreSQL 9.3:

157 tests passed
0 tests failed
14 tests skipped:
PackageAddTestCase (Fetch Package Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
SynonymAddTestCase (Default Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
SynonymPutTestCase (Fetch synonym Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
TableUpdateTestCase (Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
ResourceGroupsAddTestCase (Add resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsGetTestCase (Get resource groups)

PostgreSQL 9.4:

157 tests passed
0 tests failed
14 tests skipped:
PackageAddTestCase (Fetch Package Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
SynonymAddTestCase (Default Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
SynonymPutTestCase (Fetch synonym Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
TableUpdateTestCase (Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
ResourceGroupsAddTes

Build failed in Jenkins: pgadmin4-master-python34 #221

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Release notes for 1.6.

[Dave Page] Bump version numbers prior to release.

--
[...truncated 317.17 KB...]
Detach partition from existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing list 
partitioned table)
ResourceGroupsAddTestCase (Add resource groups)
EventTriggerPutTestCase (Fetch Event Trigger Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
ViewsUpdateTestCase (Update materialized view under schema node)
PackageGetTestCase (Fetch Package Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
SynonymPutTestCase (Fetch synonym Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
EventTriggerAddTestCase (Fetch Event Trigger Node URL)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)
ResourceGroupsGetTestCase (Get resource groups)
SynonymAddTestCase (Default Node URL)
ViewsGetTestCase (Get materialized view under schema node)
ViewsAddTestCase (Add materialized view under schema node)
ViewsDeleteTestCase (Delete materialized view under schema node)
EventTriggerDeleteTestCase (Fetch Event Trigger Node URL)
EventTriggerGetTestCase (Fetch Event Trigger Node URL)
ResourceGroupsPutTestCase (Put resource groups)

PostgreSQL 9.3:

157 tests passed
0 tests failed
14 tests skipped:
PackageDeleteTestCase (Fetch Package Node URL)
ResourceGroupsDeleteTestCase (Delete resource groups)
TableUpdateTestCase (Attach partition to existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing list 
partitioned table)
PackageGetTestCase (Fetch Package Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
ResourceGroupsAddTestCase (Add resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsGetTestCase (Get resource groups)
SynonymAddTestCase (Default Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)

PostgreSQL 9.4:

157 tests passed
0 tests failed
14 tests skipped:
PackageDeleteTestCase (Fetch Package Node URL)
ResourceGroupsDeleteTestCase (Delete resource groups)
TableUpdateTestCase (Attach partition to existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing list 
partitioned table)
PackageGetTestCase (Fetch Package Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
ResourceGroupsAddTestCase (Add resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsGetTestCase (Get resource groups)
SynonymAddTestCase (Default Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
TableAddTestCase (Create List partitioned table with 2 
partitions,
   

Re: pgAdmin 4 commit: Release notes for 1.6.

[Harshal Dhumal]

Hi Dave,

Below corrections required in release notes.

Feature #2137:
1) Redmine link is pointing to issue 2437 it should be 2137
2) Feature title should On-demand loading for the query tool result and
not Fixed Row selection issue and row past issue.


Fearture# 2191:
1) Redmine link is pointing to issue 2491 it should be 2191


I have listed incorrect feature entries below for reference.
+| `Feature #2137 `_ -
Fixed Row selection issue and row past issue
+| `Feature #2191 `_ - Add support for the hostaddr connection parameter. This helps us play 
>nicely with Kerberos/SSPI and friends









-- 
*Harshal Dhumal*
*Sr. Software Engineer*

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

On Mon, Jul 10, 2017 at 7:22 PM, Dave Page  wrote:

> Release notes for 1.6.
>
> Branch
> --
> master
>
> Details
> ---
> https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=
> 4bfb31b03b3c6f1337f5ef317c69569fdf940d6c
> Author: Karen Blatchley 
>
> Modified Files
> --
> docs/en_US/release_notes.rst |   1 +
> docs/en_US/release_notes_1_6.rst | 102 ++
> +
> 2 files changed, 103 insertions(+)
>
>

pgAdmin 4 commit: Couple of typos in the release notes.

[Dave Page]

Couple of typos in the release notes.

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=7aa7ea0fe2eede85cbb95c3fe69bdbe6496b5cd8
Author: Harshal Dhumal 

Modified Files
--
docs/en_US/release_notes_1_6.rst | 4 ++--
1 file changed, 2 insertions(+), 2 deletions(-)

Build failed in Jenkins: pgadmin4-master-python27 #235

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Release notes for 1.6.

[Dave Page] Bump version numbers prior to release.

--
[...truncated 317.73 KB...]
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.5:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.4:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.3:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned t

[pgAdmin4][Patch]: Fixed #2550 declarative partitioning - drop/delete and drop cascade is not working for partition table

[Akshay Joshi]

Hi All

Attached is the patch file to fix the RM #2550, where user will not be able
to drop/drop cascade partitions. Apart from that RM this patch contains
following fix:

   - Update the SQL query to fix the jenkins build.
   - Use AlertifyWrapper in Partition.js
   - Fix the icon while 'truncate table' and 'reset statistics'.


-- 
*Akshay Joshi*
*Principal Software Engineer *



*Phone: +91 20-3058-9517Mobile: +91 976-788-8246*


RM_2550.patch
Description: Binary data

Build failed in Jenkins: pgadmin4-master-python26 #353

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Release notes for 1.6.

[Dave Page] Bump version numbers prior to release.

[Dave Page] Couple of typos in the release notes.

--
[...truncated 320.88 KB...]
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.5:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.4:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.3:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
   

Re: pgagent build issue on SLES 12

[Devrim Gündüz]

Hi,

On Mon, 2017-07-10 at 14:01 +0100, Dave Page wrote:

> I have no idea if pgAgent will work with wxWidgets 3. Are there wx 2.8
> packages available?

Ah, that fixed it (the package names in SLES are different than Red Hat, it
took me a while to find the right package)

That said, reminder for the new pgagent version that compiles against 10.

Thanks!

Regards,
-- 
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Danışmanı/Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part

Build failed in Jenkins: pgadmin4-master-python35 #231

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Release notes for 1.6.

[Dave Page] Bump version numbers prior to release.

--
[...truncated 317.23 KB...]
Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Attach partition to existing list 
partitioned table)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
PackageDeleteTestCase (Fetch Package Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
PackagePutTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)
ResourceGroupsAddTestCase (Add resource groups)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsGetTestCase (Get resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
ResourceGroupsPutTestCase (Put resource groups)
SynonymGetTestCase (Fetch synonym Node URL)

EDB Postgres AS 9.2:

156 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
14 tests skipped:
ResourceGroupsDeleteTestCase (Delete resource groups)
TableUpdateTestCase (Attach partition to existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Attach partition to existing list 
partitioned table)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
ViewsAddTestCase (Add materialized view under schema node)
ViewsDeleteTestCase (Delete materialized view under schema node)
EventTriggerDeleteTestCase (Fetch Event Trigger Node URL)
ResourceGroupsAddTestCase (Add resource groups)
ResourceGroupsGetTestCase (Get resource groups)
EventTriggerAddTestCase (Fetch Event Trigger Node URL)
EventTriggerPutTestCase (Fetch Event Trigger Node URL)
ViewsGetTestCase (Get materialized view under schema node)
EventTriggerGetTestCase (Fetch Event Trigger Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ViewsUpdateTestCase (Update materialized view under schema node)

EDB Postgres AS 9.5:

168 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
2 tests skipped:
TableUpdateTestCase (Attach partition to existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Attach partition to existing list 
partitioned table)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)

EDB Postgres AS 9.3:

164 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
6 tests skipped:
ResourceGroupsDeleteTestCase (Delete resource groups)
TableUpdateTestCase (Attach partition to existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
A

Build failed in Jenkins: pgadmin4-master-python27 #236

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Couple of typos in the release notes.

--
[...truncated 317.73 KB...]
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.5:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.4:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing range 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackagePutTestCase (Fetch Package Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
SynonymAddTestCase (Default Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)

PostgreSQL 9.3:

157 tests passed
0 tests failed
14 tests skipped:
SynonymGetTestCase (Fetch synonym Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
   

Re: pgAdmin 4 commit: Release notes for 1.6.

[Dave Page]

Thanks, fixed.

On Mon, Jul 10, 2017 at 3:14 PM, Harshal Dhumal <
harshal.dhu...@enterprisedb.com> wrote:

> Hi Dave,
>
> Below corrections required in release notes.
>
> Feature #2137:
> 1) Redmine link is pointing to issue 2437 it should be 2137
> 2) Feature title should On-demand loading for the query tool result and
> not Fixed Row selection issue and row past issue.
>
>
> Fearture# 2191:
> 1) Redmine link is pointing to issue 2491 it should be 2191
>
>
> I have listed incorrect feature entries below for reference.
> +| `Feature #2137 `_ -
> Fixed Row selection issue and row past issue
> +| `Feature #2191  >`_ - Add support for the hostaddr connection parameter.
>  This helps us play nicely with Kerberos/SSPI and friends
>
>
>
>
>
>
>
>
>
> --
> *Harshal Dhumal*
> *Sr. Software Engineer*
>
> EnterpriseDB India: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
> On Mon, Jul 10, 2017 at 7:22 PM, Dave Page  wrote:
>
>> Release notes for 1.6.
>>
>> Branch
>> --
>> master
>>
>> Details
>> ---
>> https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdif
>> f;h=4bfb31b03b3c6f1337f5ef317c69569fdf940d6c
>> Author: Karen Blatchley 
>>
>> Modified Files
>> --
>> docs/en_US/release_notes.rst |   1 +
>> docs/en_US/release_notes_1_6.rst | 102 ++
>> +
>> 2 files changed, 103 insertions(+)
>>
>>
>


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

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

Build failed in Jenkins: pgadmin4-master-python33 #231

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Bump version numbers prior to release.

[Dave Page] Couple of typos in the release notes.

--
[...truncated 317.34 KB...]
Create partitions of existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Detach partition from existing range 
partitioned table)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)

EDB Postgres AS 9.5:

168 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
2 tests skipped:
TableUpdateTestCase (Create partitions of existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing list 
partitioned table,
Create partitions of existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Detach partition from existing range 
partitioned table)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)

EDB Postgres AS 9.4:

168 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
2 tests skipped:
TableUpdateTestCase (Create partitions of existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing list 
partitioned table,
Create partitions of existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Detach partition from existing range 
partitioned table)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)

EDB Postgres AS 9.3:

164 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
6 tests skipped:
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsGetTestCase (Get resource groups)
ResourceGroupsAddTestCase (Add resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
TableUpdateTestCase (Create partitions of existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Detach partition from existing list 
partitioned table,
Create partitions of existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Detach partition from existing range 
partitioned table)
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)

EDB Postgres AS 9.2:

156 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
14 tests skipped:
ResourceGroupsPutTestCase (Put resource groups)
EventTriggerPutTestCase (Fetch Event Trigger Node URL)
ViewsGetTestCase (Get materialized view under schema node)
ResourceGroupsDeleteTestCase (Delete resource groups)
ResourceGroupsAddTestCase (Add resource groups)
ViewsAddTestCase (Add materialized view under schema node)
EventTriggerAddTestCase (Fetch Event Trigger Node URL)
ResourceGroupsGetTestCase (Get resource groups)
EventTriggerDeleteTestCase (Fetch Event Trigger Node URL)
ViewsUpdateTestCase (Update materialized view under schema node)
ViewsDeleteTestCase (Delete materialized view under schema node)
EventTriggerGetTestCase (Fetch Event Trigger Node URL)
   

Build failed in Jenkins: pgadmin4-master-python36 #228

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Couple of typos in the release notes.

--
[...truncated 317.21 KB...]
PackageAddTestCase (Fetch Package Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
SynonymAddTestCase (Default Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
SynonymPutTestCase (Fetch synonym Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
TableUpdateTestCase (Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
ViewsAddTestCase (Add materialized view under schema node)
ViewsDeleteTestCase (Delete materialized view under schema node)
ViewsGetTestCase (Get materialized view under schema node)
ViewsUpdateTestCase (Update materialized view under schema node)
ResourceGroupsAddTestCase (Add resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsGetTestCase (Get resource groups)

PostgreSQL 9.3:

157 tests passed
0 tests failed
14 tests skipped:
PackageAddTestCase (Fetch Package Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
SynonymAddTestCase (Default Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
SynonymPutTestCase (Fetch synonym Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
TableUpdateTestCase (Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
ResourceGroupsAddTestCase (Add resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)
ResourceGroupsPutTestCase (Put resource groups)
ResourceGroupsGetTestCase (Get resource groups)

PostgreSQL 9.4:

157 tests passed
0 tests failed
14 tests skipped:
PackageAddTestCase (Fetch Package Node URL)
PackageDeleteTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
SynonymAddTestCase (Default Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
SynonymPutTestCase (Fetch synonym Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)
TableUpdateTestCase (Create partitions of existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table)
ResourceGroupsAddTestCase (Add resource groups)
 

pgAdmin 4 commit: Fix drop/drop cascade for partitioned tables. Fixes #

[Dave Page]

Fix drop/drop cascade for partitioned tables. Fixes #2550

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=f06c3578f6cbfdb3cd6a8ad40038bb0d9cc878fc
Author: Akshay Joshi 

Modified Files
--
.../servers/databases/schemas/tables/__init__.py   | 26 +-
.../schemas/tables/partitions/__init__.py  | 41 ++
.../tables/partitions/static/js/partition.js   | 31 ++--
.../databases/schemas/tables/static/js/table.js|  8 +++--
.../templates/table/sql/10_plus/properties.sql |  2 +-
.../templates/table/sql/9.1_plus/properties.sql|  2 +-
.../servers/databases/schemas/tables/utils.py  | 39 
7 files changed, 108 insertions(+), 41 deletions(-)

Build failed in Jenkins: pgadmin4-master-python34 #222

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Couple of typos in the release notes.

--
[...truncated 317.25 KB...]
ResourceGroupsAddTestCase (Add resource groups)
ViewsUpdateTestCase (Update materialized view under schema node)
ViewsDeleteTestCase (Delete materialized view under schema node)
ViewsGetTestCase (Get materialized view under schema node)
EventTriggerAddTestCase (Fetch Event Trigger Node URL)
ResourceGroupsPutTestCase (Put resource groups)
TableUpdateTestCase (Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Detach partition from existing range 
partitioned table)
EventTriggerGetTestCase (Fetch Event Trigger Node URL)
EventTriggerDeleteTestCase (Fetch Event Trigger Node URL)
EventTriggerPutTestCase (Fetch Event Trigger Node URL)
ResourceGroupsGetTestCase (Get resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)

PostgreSQL 9.4:

157 tests passed
0 tests failed
14 tests skipped:
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackageDeleteTestCase (Fetch Package Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
ResourceGroupsDeleteTestCase (Delete resource groups)
PackageAddTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
SynonymAddTestCase (Default Node URL)
PackageGetTestCase (Fetch Package Node URL)
ResourceGroupsPutTestCase (Put resource groups)
TableUpdateTestCase (Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Detach partition from existing range 
partitioned table)
ResourceGroupsGetTestCase (Get resource groups)
SynonymPutTestCase (Fetch synonym Node URL)

EDB Postgres AS 9.4:

168 tests passed
1 test failed:
TestTablesPropertiesSql (This scenario tests that all 
applicable sql template versions can fetch some ddl)
2 tests skipped:
TableAddTestCase (Create List partitioned table with 2 
partitions,
Create Range partitioned table with 2 
partitions)
TableUpdateTestCase (Attach partition to existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Create partitions of existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Detach partition from existing list 
partitioned table,
Detach partition from existing range 
partitioned table)

PostgreSQL 10:

159 tests passed
0 tests failed
12 tests skipped:
SynonymDeleteTestCase (Fetch synonym Node URL)
ResourceGroupsAddTestCase (Add resource groups)
PackageDeleteTestCase (Fetch Package Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
PackageAddTestCase (Fetch Package Node URL)
PackagePutTestCase (Fetch Package Node URL)
SynonymAddTestCase (Default Node URL)
PackageGetTestCase (Fetch Package Node URL)
ResourceGroupsPutTestCase (Put resource groups)
SynonymPutTestCase (Fetch synonym Node URL)
ResourceGroupsGetTestCase (Get resource groups)
ResourceGroupsDeleteTestCase (Delete resource groups)

EDB Postgres AS 9.6:

168 

Object > delete/drop and properties menu icons misaligned

[Surinder Kumar]

Hi

Object > delete/drop & properties icons are now misaligned.

This is regression of commit d56f1d847c946f43bebbfbdefb929870f0050694


I found the lack of information why these changes were necessary, i have
attached a patch which fixes it but it might affect at other place for
which the changes were made originally.

Let me know if an RM is required to track.

Please find attached patch.

Thanks,
Surinder


fix_object_menu_icons.patch
Description: Binary data

Build failed in Jenkins: pgadmin4-master-python35 #232

[pgAdmin 4 Jenkins]

See 


Changes:

[Dave Page] Couple of typos in the release notes.

--
[...truncated 317.24 KB...]
ResourceGroupsDeleteTestCase (Delete resource groups)
PackagePutTestCase (Fetch Package Node URL)
ResourceGroupsPutTestCase (Put resource groups)
SynonymPutTestCase (Fetch synonym Node URL)
PackageAddTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table)
PackageDeleteTestCase (Fetch Package Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)

PostgreSQL 9.4:

157 tests passed
0 tests failed
14 tests skipped:
PackageGetTestCase (Fetch Package Node URL)
ResourceGroupsGetTestCase (Get resource groups)
ResourceGroupsAddTestCase (Add resource groups)
SynonymAddTestCase (Default Node URL)
ResourceGroupsDeleteTestCase (Delete resource groups)
PackagePutTestCase (Fetch Package Node URL)
ResourceGroupsPutTestCase (Put resource groups)
SynonymPutTestCase (Fetch synonym Node URL)
PackageAddTestCase (Fetch Package Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table)
PackageDeleteTestCase (Fetch Package Node URL)
SynonymGetTestCase (Fetch synonym Node URL)
SynonymDeleteTestCase (Fetch synonym Node URL)
TableAddTestCase (Create Range partitioned table with 2 
partitions,
Create List partitioned table with 2 
partitions)

PostgreSQL 9.2:

149 tests passed
0 tests failed
22 tests skipped:
EventTriggerDeleteTestCase (Fetch Event Trigger Node URL)
EventTriggerAddTestCase (Fetch Event Trigger Node URL)
TableUpdateTestCase (Detach partition from existing list 
partitioned table,
Create partitions of existing range 
partitioned table,
Attach partition to existing list 
partitioned table,
Attach partition to existing range 
partitioned table,
Create partitions of existing list 
partitioned table,
Detach partition from existing range 
partitioned table)
SynonymGetTestCase (Fetch synonym Node URL)
ViewsGetTestCase (Get materialized view under schema node)
ResourceGroupsPutTestCase (Put resource groups)
PackageAddTestCase (Fetch Package Node URL)
ResourceGroupsDeleteTestCase (Delete resource groups)
ViewsAddTestCase (Add materialized view under schema node)
SynonymDeleteTestCase (Fetch synonym Node URL)
PackagePutTestCase (Fetch Package Node URL)
PackageGetTestCase (Fetch Package Node URL)
ResourceGroupsGetTestCase (Get resource groups)
ResourceGroupsAddTestCase (Add resource groups)
SynonymAddTestCase (Default Node URL)
ViewsUpdateTestCase (Update materialized view under schema node)
SynonymPutTestCase (Fetch synonym Node URL)
EventTriggerPutTestCase (Fetch Event Trigger Node URL)
ViewsDeleteTestCase (Delete materialized view under schema node)
PackageDeleteTestCase (Fetch Package Node URL)

pgAdmin 4 commit: Ensure the initial password is properly hashed during

[Dave Page]

Ensure the initial password is properly hashed during setup in web mode. Fixes 
#2492

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=b095d1f33a3e8a3e0990c623ef3d21c129d9a802
Author: Ashesh Vashi 

Modified Files
--
docs/en_US/release_notes_1_6.rst |  1 +
web/migrations/versions/f195f9a4923d_.py | 47 
web/migrations/versions/fdc58d9bd449_.py | 46 +++
web/setup.py | 18 
4 files changed, 88 insertions(+), 24 deletions(-)

Jenkins build is back to normal : pgadmin4-master-python36 #229

[pgAdmin 4 Jenkins]

See 

pgAdmin 4 commit: Fix alignment of Object > delete/drop & properties ic

[Dave Page]

Fix alignment of Object > delete/drop & properties icons

Branch
--
master

Details
---
https://git.postgresql.org/gitweb?p=pgadmin4.git;a=commitdiff;h=2bfe640a081cc59a22453c3db847817406cb6651
Author: Surinder Kumar 

Modified Files
--
web/pgadmin/static/css/bootstrap.overrides.css | 8 
1 file changed, 8 deletions(-)

Re: Object > delete/drop and properties menu icons misaligned

[Dave Page]

Thanks, applied.

On Mon, Jul 10, 2017 at 4:01 PM, Surinder Kumar <
surinder.ku...@enterprisedb.com> wrote:

> Hi
>
> Object > delete/drop & properties icons are now misaligned.
>
> This is regression of commit d56f1d847c946f43bebbfbdefb929870f0050694
> 
>
> I found the lack of information why these changes were necessary, i have
> attached a patch which fixes it but it might affect at other place for
> which the changes were made originally.
>
> Let me know if an RM is required to track.
>
> Please find attached patch.
>
> Thanks,
> Surinder
>



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

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

Jenkins build is back to normal : pgadmin4-master-python33 #232

[pgAdmin 4 Jenkins]

See 

Jenkins build is back to normal : pgadmin4-master-python34 #223

[pgAdmin 4 Jenkins]

See 

Jenkins build is back to normal : pgadmin4-master-python27 #237

[pgAdmin 4 Jenkins]

See 

Re: [pgAdmin4][Patch]: Fixed #2550 declarative partitioning - drop/delete and drop cascade is not working for partition table

[Dave Page]

Thanks, applied.

On Mon, Jul 10, 2017 at 3:28 PM, Akshay Joshi  wrote:

> Hi All
>
> Attached is the patch file to fix the RM #2550, where user will not be
> able to drop/drop cascade partitions. Apart from that RM this patch
> contains following fix:
>
>- Update the SQL query to fix the jenkins build.
>- Use AlertifyWrapper in Partition.js
>- Fix the icon while 'truncate table' and 'reset statistics'.
>
>
> --
> *Akshay Joshi*
> *Principal Software Engineer *
>
>
>
> *Phone: +91 20-3058-9517 <+91%2020%203058%209517>Mobile: +91 976-788-8246
> <+91%2097678%2088246>*
>



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

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

Jenkins build is back to normal : pgadmin4-master-python35 #233

[pgAdmin 4 Jenkins]

See 

Jenkins build is back to normal : pgadmin4-master-python26 #354

[pgAdmin 4 Jenkins]

See 

[pgadmin-hackers][pgaweb][patch] Website patch to add SCSS

[Joao De Almeida Pereira]

Hi Hackers,

In this email you will be able to find the first patches to start the
migration of the Styleguide from http://pgadmin4-styleguide.cfapps.io/ to
the pgadmin.org webpage.

The first patch adds a Readme to the project and also the yarn.lock file
The second patch:
- Adds SCSS processor to Django
- Scripts to yarn to compile the SCSS and run the application
- Add startapp.sh script to start the application
- Changes the current pgaweb.css file to SCSS
- Update README with new instructions


Thanks
Joao


01-add-readme.patch
Description: Binary data


02-add-scss.patch
Description: Binary data

Re: Windows testing required: Updated runtime

[Jeff Janes]

On Thu, Jul 6, 2017 at 7:59 AM, Dave Page  wrote:

> All,
>
> I've put an interim build of pgAdmin 4 at https://developer.pgadmin.
> org/~dpage/pgadmin4-1.5-x86.exe for Windows users. This build uses a work
> in progress patch to replace the slow Qt components with ActiveQt + the
> Microsoft web browser control to significantly improve performance.
>
> The version also includes close to 100 other bug fixes and changes, most
> noticeably performance improvements in the Query Tool that make it
> significantly faster than pgAdmin 3 with large result sets, and the ability
> to open the Query Tool and Debugger in new tabs that can be dragged onto
> different windows and therefore displays.
>

It starts quite a bit faster than it used to.  It used to be close to a
minute, now it is 15 seconds from cold and 10 if it were recently running
and then started again.

I haven't really played with the features, so don't have anything to report
there.

Cheers,

Jeff

Re: Windows testing required: Updated runtime

[Eric Hirst]

FYI, this new version appears to resolve the following issue for me.
Thanks for your work on this.
-Eric

Bug #2255: Latency issues make tool unusable in remote desktop


On Mon, Jul 10, 2017 at 12:00 PM, Jeff Janes  wrote:

>
> On Thu, Jul 6, 2017 at 7:59 AM, Dave Page  wrote:
>
>> All,
>>
>> I've put an interim build of pgAdmin 4 at https://developer.pgadmin.o
>> rg/~dpage/pgadmin4-1.5-x86.exe for Windows users. This build uses a work
>> in progress patch to replace the slow Qt components with ActiveQt + the
>> Microsoft web browser control to significantly improve performance.
>>
>> The version also includes close to 100 other bug fixes and changes, most
>> noticeably performance improvements in the Query Tool that make it
>> significantly faster than pgAdmin 3 with large result sets, and the ability
>> to open the Query Tool and Debugger in new tabs that can be dragged onto
>> different windows and therefore displays.
>>
>
> It starts quite a bit faster than it used to.  It used to be close to a
> minute, now it is 15 seconds from cold and 10 if it were recently running
> and then started again.
>
> I haven't really played with the features, so don't have anything to
> report there.
>
> Cheers,
>
> Jeff
>

Re: [pgadmin-hackers] [Design update] Style guide for pgAdmin4

[Shirley Wang]

I noticed that the default font, Menlo, was disabled in favor of Monospace.
Was there a specific reason why Monospace was used in favor of Menlo?

I find that Menlo is an easier font to read, especially for uppercase
letters. For web apps, sans-serif fonts are used (fonts without the little
notch, or serifs, at the end of each stroke of a letter) so it's easier to
read on a display. Serif fonts are better for print.


*Menlo:*
[image: Screen Shot 2017-07-10 at 4.38.11 PM.png]

Re: [pgAdmin4][Patch]: Fixed RM #1165 - Too many request to update dashboard graphs when server is disconnected.

[Khushboo Vashi]

Hi,

please find the attached updated patch.

Thanks,
Khushboo

On Mon, Jul 10, 2017 at 6:54 PM, Dave Page  wrote:

> Hi
>
> On Mon, Jul 10, 2017 at 2:14 PM, Khushboo Vashi <
> khushboo.va...@enterprisedb.com> wrote:
>
>> Hi,
>>
>> Please find the attached patch to fix the RM #1165 - Too many request to
>> update dashboard graphs when server is disconnected.
>>
>
> If I disconnect the server, it doesn't stop trying to get data until I
> refresh the browser by clicking on another node that causes it to reload.
>
> Fixed

> If I then click back on the server node, it doesn't redraw the dashboard
> and start displaying new data upon reconnect. I have to change nodes again
> before it will respond to the re-connection.
>
> Fixed

> Thanks.
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
diff --git a/web/pgadmin/dashboard/templates/dashboard/js/dashboard.js b/web/pgadmin/dashboard/templates/dashboard/js/dashboard.js
index 34a1ab7..1bbe5a4 100644
--- a/web/pgadmin/dashboard/templates/dashboard/js/dashboard.js
+++ b/web/pgadmin/dashboard/templates/dashboard/js/dashboard.js
@@ -22,10 +22,14 @@ function(r, $, pgAdmin, _, Backbone, gettext) {
 
 // Bind the Dashboard object with the 'object_selected' function
 var selected = this.object_selected.bind(this);
+var disconnected = this.object_disconnected.bind(this);
 
 // Listen for selection of any of object
 pgBrowser.Events.on('pgadmin-browser:tree:selected', selected);
 
+// Listen for server disconnected event
+pgBrowser.Events.on('pgadmin:server:disconnect', disconnected);
+
 // Load the default welcome dashboard
 url = '{{ url_for('dashboard.index') }}';
 
@@ -55,6 +59,11 @@ function(r, $, pgAdmin, _, Backbone, gettext) {
 }
 },
 
+// Handle Server Disconnect
+object_disconnected: function(obj) {
+this.object_selected(obj.item, obj.data, pgBrowser.Nodes[obj.data._type]);
+},
+
 // Handle treeview clicks
 object_selected: function(item, itemData, node) {
 if (itemData && itemData._type && dashboardVisible) {
@@ -89,28 +98,40 @@ function(r, $, pgAdmin, _, Backbone, gettext) {
 );
 
 if (div) {
-// Avoid unnecessary reloads
-if (url != $(dashboardPanel).data('dashboard_url')) {
-// Clear out everything so any existing timers die off
-$(div).empty();
+if (itemData.connected || _.isUndefined(itemData.connected)) {
+// Avoid unnecessary reloads
+if (url != $(dashboardPanel).data('dashboard_url') ||
+   (url == $(dashboardPanel).data('dashboard_url') && $(dashboardPanel).data('server_status') == false )) {
+// Clear out everything so any existing timers die off
+$(div).empty();
+
+$.ajax({
+url: url,
+type: "GET",
+dataType: "html",
+success: function (data) {
+$(div).html(data);
+},
+error: function (xhr, status) {
+$(div).html(
+'' + gettext('An error occurred whilst loading the dashboard.') + ''
+);
+}
+});
+$(dashboardPanel).data('server_status', true);
+}
 
-$.ajax({
-url: url,
-type: "GET",
-dataType: "html",
-success: function (data) {
-$(div).html(data);
-},
-error: function (xhr, status) {
-$(div).html(
-'' + gettext('An error occurred whilst loading the dashboard.') + ''
-);
-}
-});
-
-// Cache the current IDs for next time
-$(dashboardPanel).data('dashboard_url', url);
 }
+else {
+$(div).empty();
+$(div).html(
+