Skip to content

broken query when using mixedCaseNames #2

@mariusa

Description

@mariusa

Hi,

pg_size_pretty(pg_relation_size(indexrelname::regclass))
https://github.com/HariSekhon/SQL-scripts/blob/54cc9cef687ba3a242688866b6af76956f23865c/postgres_indexes_unused.sql#L19C1-L38C49

says index "mixedcasename" doesn't exist, but it's actual name is "mixedCaseName"

I've changed to this to fix:
pg_size_pretty(pg_relation_size(indexrelid))

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions