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 637 forks source link

[Web based] Index node is missing from the tree view of the table node (RM #3180) #1711

Closed dpage closed 2 years ago

dpage commented 6 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/3180 Originally created by Fahar Abbas at 2018-03-06 06:14:58 UTC.

Platform: Ubuntu 16.04 Linux 64(Python 3.5) MAC 10.12 (Python 3.6)

Commit ID:

commit 427314cfdfeb96c3a7835eab5a4d638903bc6dc3

Steps:

  1. Launch pgAdmin4
  2. Launch query tool window
  3. execute following sql

CREATE TABLE films(title char(20)); CREATE UNIQUE INDEX title_idx ON films (title);

  1. table and index in created successfully
  2. Click on table node and see index option
  3. index node is missing from the tree view

Expected Result:

Index node should available on from the tree view of the table node

dpage commented 6 years ago

Attachment migrated from Redmine: https://redmine.postgresql.org/attachments/download/2866 Originally created by Fahar Abbas at 2018-03-06 06:14:47 UTC.

https://pgadmin-archive.postgresql.org/redmine/3180/2866-Screen_Shot_2018-03-05_at_10.13.36_PM.png

dpage commented 6 years ago

Attachment migrated from Redmine: https://redmine.postgresql.org/attachments/download/2867 Originally created by Murtuza Zabuawala at 2018-03-06 09:40:32 UTC.

https://pgadmin-archive.postgresql.org/redmine/3180/2867-Screen_Shot_2018-03-06_at_3.08.21_pm.png

Description: Index node & SQL tab shows proper SQL

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3180#note-3 Originally created by Murtuza Zabuawala at 2018-03-06 09:41:43 UTC.

I'm able to see it, clear your browser cache & try again.

Redmine ticket header update:

Name Old Value New Value
Attachment added Screen Shot 2018-03-06 at 3.08.21 pm.png
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3180#note-4 Originally created by Fahar Abbas at 2018-03-06 10:36:37 UTC.

I am using MAC 10.12.6 on fresh browser of Safari and Firefox as discussed, kindly take a look on my MAC OS X 10.12.6 VM

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Murtuza Zabuawala
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3180#note-5 Originally created by Khushboo Vashi at 2018-03-06 10:40:41 UTC.

Fahar,

Your Index node is not disabled from preferences, right?

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Murtuza Zabuawala Fahar Abbas
dpage commented 6 years ago

Attachment migrated from Redmine: https://redmine.postgresql.org/attachments/download/2868 Originally created by Fahar Abbas at 2018-03-06 10:44:07 UTC.

https://pgadmin-archive.postgresql.org/redmine/3180/2868-Screen_Shot_2018-03-06_at_3.43.14_PM.png

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3180#note-7 Originally created by Fahar Abbas at 2018-03-06 10:44:59 UTC.

Index option is still visible under preferences but not displayed in tree view.

Redmine ticket header update:

Name Old Value New Value
Attachment added Screen Shot 2018-03-06 at 3.43.14 PM.png
Assigned To changed Fahar Abbas Khushboo Vashi
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3180#note-8 Originally created by Khushboo Vashi at 2018-03-06 10:59:07 UTC.

For me, only reproducible on PG10.

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3180#note-9 Originally created by Fahar Abbas at 2018-03-06 11:07:32 UTC.

I only tested on PG-10 server.

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3180#note-10 Originally created by Khushboo Vashi at 2018-03-09 10:38:41 UTC.

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Khushboo Vashi
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3180#note-11 Originally created by Akshay Joshi at 2018-03-28 10:18:38 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed EDB Sprint 11
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3180#note-12 Originally created by Akshay Joshi at 2018-03-28 11:53:55 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
Assigned To changed Akshay Joshi
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3180#note-13 Originally created by Akshay Joshi at 2018-03-29 12:37:14 UTC.

Patch sent: https://www.postgresql.org/message-id/CANxoLDdsG7eSWLpL9u5dgMb73t61tu0pqN1QjoXoGAFc=h1+Pw@mail.gmail.com

dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3180#note-14 Originally created by Akshay Joshi at 2018-03-29 13:09:37 UTC.

Applied in changeset commit:61eb94a23c043930034d66a18ea1189343f0ee8a.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
Done Ratio changed 0 90
dpage commented 6 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3180#note-15 Originally created by Dave Page at 2018-03-29 13:10:03 UTC.

Redmine ticket header update:

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

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3180#note-16 Originally created by Fahar Abbas at 2018-03-30 06:15:36 UTC.

Tested on MAC OS 10.12(Python 3.6)

commit 61eb94a23c043930034d66a18ea1189343f0ee8a

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
Done Ratio changed 90 100
dpage commented 2 years ago

Issue closed on Redmine.