Comments (4)
Hey @mpyw, what URL did you use? See: https://atlasgo.io/concepts/url#scope
Also, please upgrade to latest Atlas and check this.
from atlas.
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 ofschema.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.
from atlas.
@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.
from atlas.
I'll reopen as a new issue.
from atlas.
Related Issues (20)
- Feature Request: Support for Clickhouse Dictionary
- Bypass interactive approval for column `RENAME` detection HOT 5
- Hard to keep HCL files concise when they contain same table names
- What is the HCL standard library? Is this documented anywhere? HOT 1
- Linter for versioned workflow doesn't follow transaction model
- Latest release makes diff command fail
- Feature Request: Add support of SSH tunnel
- [REOPEN of #3006] Missing Schema Prefix in DDL `RENAME`
- Atlas hash incorrect order for golang migrate
- Fix the URL parsing for special characters. HOT 2
- Running atlas commands against cockroachdb returns error with postgres wire protocol HOT 2
- Add Postgres 15+ support for security = INVOKER
- Feature Request: Support for `SET configuration_parameter { TO value | = value | FROM CURRENT }` in Function Definition Syntax HOT 2
- Declarative workflow breaks on YugabyteDB HOT 6
- Atlas HCL Syntax: String Not Recognized by Linter HOT 5
- [Multi-file schema]: Allow glob pattern for `env.src` HOT 2
- [Multi-file schema / vsCode extension]: Load related schema files into extension context HOT 5
- [vsCode extension]: Do not require schema files to end in `.pg.hcl` HOT 1
- Go 1.23 support with ent schema loader HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from atlas.