search

appsmithorg / appsmith

Platform to build admin panels, internal tools, and dashboards. Integrates with 25+ databases and any API.
https://www.appsmith.com
Apache License 2.0
32.29k stars 3.5k forks source link

[Bug]: Dashes in Postgres Datasource Table Name Fail to Load #34596

Open JosTheDude opened 2 days ago

JosTheDude commented 2 days ago

Is there an existing issue for this?

Description

I currently am using a Postgres Datasource for my AppSmith UIs via AppSmith Cloud. However, when a table I'm working with has a dash in the name:

Example: image

It completely fails to load: image

All other data tables without dashes load fine.

Steps To Reproduce

1) Use a Postgres Datasource in AppSmith Cloud 2) Create a table in the Postgres Database 3) View the Datasource in AppSmith / attempt work with it

Public Sample App

No response

Environment

Production

Severity

High (Blocker to building or releasing)

Issue video log

No response

Version

Cloud

JosTheDude commented 2 days ago

Most databases follow proper Postgres snakecase table name convention, however, this particular dataset didn't follow that convention hence the discovery.