search

mfvanek / pg-index-health-sql

pg-index-health-sql is a set of sql-queries for analyzing and maintaining indexes and tables health in Postgresql databases.
Apache License 2.0
81 stars 11 forks source link

Query to check duplicated foreign key #49

Closed BLoHny closed 1 month ago

BLoHny commented 2 months ago

Query to check duplicated foreign key

relates https://github.com/mfvanek/pg-index-health/issues/390

BLoHny commented 2 months ago

image

Other lint errors have been fixed, But In the current sqlfluff version, I think it can't parse "cross join lateral". Is there a solution?

mfvanek commented 2 months ago

image

Other lint errors have been fixed, But In the current sqlfluff version, I think it can't parse "cross join lateral". Is there a solution?

Take a look at https://github.com/sqlfluff/sqlfluff/issues/4623

You can try to create a new issue for sqlfluff.

mfvanek commented 1 month ago

Superseded by https://github.com/mfvanek/pg-index-health-sql/pull/50