joereynolds / sql-lint

An SQL linter
MIT License
437 stars 40 forks source link

Why is `CREATE TEMPORARY TABLE` allowed but `CREATE TEMP TABLE` not allowed? #252

Closed chris-s-friedman closed 1 year ago

chris-s-friedman commented 1 year ago

See title.

In PostgreSQL, CREATE TABLE has a parameter to indicate if a table is temporary. Per psql docs, this param can either be TEMPORARY or TEMP.

Per the sql-lint docs, only CREATE TEMPORARY TABLE is allowed but CREATE TEMP TABLE is not allowed.

Why isn't this pattern permitted in sql-lint?

joereynolds commented 1 year ago

Closing as resolved by yourself here https://github.com/joereynolds/sql-lint/pull/253