Comments (5)
Andrey, this looks similar to issue #42, where Francisco claims to have used yamltodb -N to supposedly exclude the public schema. I have been unable to reproduce that problem, but I have a hunch as to what may be wrong with yours. Could you please make and test the following with your data?
diff --git a/pyrseas/dbobject/schema.py b/pyrseas/dbobject/schema.py
index 3c503ea..21eeb05 100644
--- a/pyrseas/dbobject/schema.py
+++ b/pyrseas/dbobject/schema.py
@@ -133,7 +133,7 @@ class SchemaDict(DbObjectDict):
schema = self[sch] = Schema(name=sch)
inschema = inmap[key]
objdict = {}
- for key in list(inschema.keys()):
+ for key in sorted(inschema.keys()):
mapped = False
for prefix in list(PREFIXES.keys()):
if key.startswith(prefix):
from pyrseas.
Andrey, did you get a chance to test the above change? Please let me know. Thanks.
from pyrseas.
I can't manage to reproduce this issue now :-\
from pyrseas.
If you didn't apply the patch, then it tends to confirm my hunch. In any case, I'll commit the suggested change to close the issue. If it happens again, we can always reopen it.
from pyrseas.
This is presumably fixed by change 0052e8a.
from pyrseas.
Related Issues (20)
- yamltodb fails on Postgres 13 due to removal of pg_pltemplate catalog HOT 25
- ALTER SEQUENCE OWNER comes before CREATE TABLE HOT 3
- SSL Connection to remote database HOT 3
- datacopy CSV with null trailing columns not importing with -u HOT 7
- CREATE EXTENSION statements in the change script HOT 5
- [Contribution] Docker support HOT 2
- Sequences processing doesn't skip schemas defined with '-N' option. HOT 3
- dbtoyaml fails when dealing with extension-owned triggers/functions HOT 7
- Multiline Strings (source: |2) Output Unstable HOT 5
- Enable Github Discussions HOT 2
- Fails to Install: Error: pg_config executable not found HOT 5
- Error Using dbtoyaml With Supabase Schema HOT 67
- dbtoyaml Fails When PG Password Has Spaces (Improper Escaping) HOT 1
- Convert .travis.yml to GH Actions
- Fold pgdbconn back into Pyrseas HOT 1
- Key error when converting aggregate to YAML HOT 4
- plv8 to extension and fix reserved words in the primary key HOT 5
- Add REFERENCING tables in trigger HOT 3
- Support columns GENERATED AS (x) STORED HOT 2
- Support --revert for tables 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 pyrseas.