search

pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.43k stars 638 forks source link

[GreenPlum] When user press Explain Plan and Explain analyze plan an error is displayed (RM #3084) #1652

Closed dpage closed 2 years ago

dpage commented 6 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/3084 Originally created by Joao Pereira at 2018-02-02 22:41:10 UTC.

When the user is connect to a GreenPlum database the Explain and Explain Analyze functionalities are not working

Steps to reproduce:

  1. Connect to a GreenPlum database
  2. Open Query Tool on that server
  3. Write a query
  4. Press in the button next the Thunder and click on Explain or Explain Analyze

Expected behavior: See the execution plan in the Data Output

Actual behavior: Display the following exception:

ERROR:  syntax error at or near "FORMAT"
LINE 1: EXPLAIN (FORMAT JSON, ANALYZE ON, VERBOSE OFF, COSTS OFF, BU...
                 ^
SQL state: 42601
Character: 10
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3084#note-1 Originally created by Dave Page at 2018-04-10 12:36:51 UTC.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 3.0 3.1
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3084#note-2 Originally created by Dave Page at 2018-06-28 09:10:26 UTC.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 3.1 3.2
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3084#note-3 Originally created by Dave Page at 2018-08-08 16:19:20 UTC.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 3.2 3.3
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3084#note-4 Originally created by Dave Page at 2018-09-06 13:02:25 UTC.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 3.3 3.4
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3084#note-5 Originally created by Dave Page at 2018-10-08 09:05:21 UTC.

Redmine ticket header update:

Name Old Value New Value
Fixed Version changed 3.4
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3084#note-6 Originally created by Akshay Joshi at 2018-12-07 10:31:19 UTC.

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Joao Pereira
dpage commented 4 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3084#note-7 Originally created by Dave Page at 2020-04-24 12:35:56 UTC.

Support for Greenplum is being dropped unfortunately. Per https://www.postgresql.org/message-id/CA+OCxowB54V4QDOS_fvAd=Ljh79Ej7cHyfUXLwt70NGRAB2JZg@mail.gmail.com

Redmine ticket header update:

Name Old Value New Value
Status changed New Rejected
dpage commented 2 years ago

Issue closed on Redmine.