Thread: Select, Update, and Insert script generation fails to load
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@pgadmin.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:
- Right click on a table in the object browser
- Select Scripts
- Pick any of the following:
- INSERT Script
- SELECT Script
- UPDATE Script
- A new tab opens with spinning wait wheel
- 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
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
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:
- Right click on a table in the object browser
- Select Scripts
- Pick any of the following:
- INSERT Script
- SELECT Script
- UPDATE Script
- A new tab opens with spinning wait wheel
- 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
- Screenshots are below
- Log file is attached.
- 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:
SELECT Tab Screenshot:
--
Michael Rasmussen
Sr. Data Engineer
Porch
From: Khushboo Vashi <khushboo.vashi@enterprisedb.com>
Date: Monday, January 29, 2018 at 8:38 PM
To: Michael Rasmussen <michaelr@porch.com>
Cc: "pgadmin-support@lists.postgresql.org" <pgadmin-support@lists.postgresql.org>
Subject: Re: Select, Update, and Insert script generation fails to load
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@porch.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
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:
- Right click on a table in the object browser
- Select Scripts
- Pick any of the following:
- INSERT Script
- SELECT Script
- UPDATE Script
- A new tab opens with spinning wait wheel
- 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
- Screenshots are below
- Log file is attached.
- 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:
SELECT Tab Screenshot:
--
Michael Rasmussen
Sr. Data Engineer
Porch
From: Khushboo Vashi <khushboo.vashi@enterprisedb.
com>
Date: Monday, January 29, 2018 at 8:38 PM
To: Michael Rasmussen <michaelr@porch.com>
Cc: "pgadmin-support@lists.postgresql.org" <pgadmin-support@lists. postgresql.org>
Subject: Re: Select, Update, and Insert script generation fails to load
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@porch.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
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:
- Right click on a table in the object browser
- Select Scripts
- Pick any of the following:
- INSERT Script
- SELECT Script
- UPDATE Script
- A new tab opens with spinning wait wheel
- 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