microsoft / azuredatastudio-postgresql

azuredatastudio-postgresql is an extension for Azure Data Studio that enables you to work with PostgreSQL databases
Other
193 stars 36 forks source link

Failed to expand node: An item with the provided index does not exist #501

Open sitefinitysteve opened 2 months ago

sitefinitysteve commented 2 months ago

Describe the bug Unable to view table structure

To Reproduce Steps to reproduce the behavior:

  1. Open Database
  2. Open Table
  3. Expand any child item
  4. See error

Expected behavior The items to expand and show columns names, etc

Screenshots image

Desktop (please complete the following information):

ADS (please complete the following information):

Additional context Using DBNgin for the Postgres instance, Laravel is able to migrate just fine and create the tables, I can see and query them, but the ADS UI just tanks trying to look at things in the UI.

RachelAmbler commented 1 month ago

@sitefinitysteve : This is the gift that MS continues to give us. Last time a similar issue to this was addressed by updating the underlying nodes.sql in the extension [1] - looks like MS have moved away from that so that solution no longer works.

I got around it by going back to v 0.5 of the package for now.

[1] - Azure Data Studio, Error: Failed to Expand Node

sitefinitysteve commented 1 month ago

Thank you, appreciate it!