Missing Schema Prefix in DDL `RENAME` Statement

[mpyw]

Missing Schema Prefix in DDL `RENAME` Statement

[a8m]

Hey @mpyw, what URL did you use? See: https://atlasgo.io/concepts/url#scope

Also, please upgrade to latest Atlas and check this.

[a8m]

From docs:

When the database URL is set to a specific schema (e.g., postgres://postgres:pass@host:port/db?search_path=public&sslmode=disable), the scope of the work done by Atlas (inspection, diffing, planning, applying, etc.) is limited to one schema. As a result, DDL statements printed during diffing or planning will be formatted without schema qualifiers and can be executed on any schema. e.g., table instead of schema.table

However, if the database URL does not specify a schema (i.e., without the search_path), Atlas operates on the selected schemas (defaulting to all), and the generated DDL statements include schema qualifiers. e.g., schema.table instead of table.

Closing, but feel free to reopen if you still need help with this.

[mpyw]

@a8m The database URL is postgresql://<USER>:<PW>@localhost:5432/<DBNAME>?sslmode=disable. And the most of other statements (execpt RENAME) qualify with the schema prefix. I believe this is the bug.

[mpyw]

I'll reopen as a new issue.