Re: Select, Update, and Insert script generation fails to load

From: Michael Rasmussen <michaelr(at)porch(dot)com>
To: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
Cc: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Select, Update, and Insert script generation fails to load
Date: 2018-01-30 19:13:15
Message-ID: E98FF56D-E147-41A7-B637-B24C0528C4E4@porch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

1. Screenshots are below
2. Log file is attached.
3. Steps I took to generate the log and the screenshots:
* I started pgAdmin 4.
* I browsed to the table in question.
* I right clicked Scripts -> CREATE script
* It opened a new tab and generated the DDL.
* I right clicked Scripts -> SELECT script.
* It opened a new tab and failed to display DML.
* I tried resizing the windows or trying to find a pull down for the Data Output tab frame, but the mouse cursor didn’t find anything to grab.

CREATE Tab Screenshot:
[cid:image001(dot)png(at)01D399BB(dot)528A5D50]

SELECT Tab Screenshot:
[cid:image002(dot)png(at)01D399BB(dot)528A5D50]

--
Michael Rasmussen
Sr. Data Engineer
Porch
From: Khushboo Vashi <khushboo(dot)vashi(at)enterprisedb(dot)com>
Date: Monday, January 29, 2018 at 8:38 PM
To: Michael Rasmussen <michaelr(at)porch(dot)com>
Cc: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: Select, Update, and Insert script generation fails to load

Hi,

Please provide below details:

1. Screen-shot for the same
2. pgAdmin logs, please refer https://www.pgadmin.org/faq/#8 to enable logging
3. Is this issue reproducible with some particular scenario?

Thanks,
Khushboo

On Tue, Jan 30, 2018 at 2:39 AM, Michael Rasmussen <michaelr(at)porch(dot)com<mailto:michaelr(at)porch(dot)com>> wrote:
Version
2.1
Copyright
Copyright 2013 - 2018, The pgAdmin Development Team
Python Version
2.7.10 (default, Jul 30 2016, 19:40:32) [GCC 4.2.1 Compatible Apple LLVM 8.0.0 (clang-800.0.34)]
Flask Version
0.11.1
Application Mode
Desktop
Current User
pgadmin4(at)pgadmin(dot)org<mailto:pgadmin4(at)pgadmin(dot)org>

Operating System
macOS High Sierra 10.13.2

PostgreSQL Cluster
PostgreSQL 9.6.5 on x86_64-pc-linux-gnu, compiled by gcc (Debian 4.7.2-5) 4.7.2, 64-bit

What is happening:

1. Right click on a table in the object browser
2. Select Scripts
3. Pick any of the following:

* INSERT Script
* SELECT Script
* UPDATE Script

1. A new tab opens with spinning wait wheel
2. When the spinning wheel clears the text editor is empty

Note: the CREATE and DELETE script properly load

What is expected:
The new tab should populate with the appropriate SQL.

--
Michael Rasmussen
Sr. Data Engineer
Porch

Attachment Content-Type Size
pgadmin4.log application/octet-stream 249.4 KB

In response to

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Chapman Flack 2018-01-30 21:14:20 What pgAdmin version(s) needed these tables/functions?
Previous Message Raymond O'Donnell 2018-01-30 18:31:32 Re: pgAdmin4 from apt.postgresql.org