GitHub user AviralDobhal07 created a discussion: Superset 6.0: PostgreSQL Case-Sensitive Column Names Causing Errors (Auto-Quote Identifiers Support?)
Hi team, I recently upgraded Superset to the latest master / v6.x build and I'm experiencing an issue with PostgreSQL datasets that contain mixed-case or uppercase column names (for example: D1DATE, D2EL01, etc.). Superset automatically generates SQL without quotes, so PostgreSQL lowercases identifiers. This results in errors like: "SELECT D1DATE FROM my_table" Error: column "d1date" does not exist PostgreSQL rewrites it to d1date and the query fails. Any help will be appriciated. GitHub link: https://github.com/apache/superset/discussions/36243 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
