Comments (1)
Hi Ronan,
The simplest fix is as follows:
diff --git a/pyrseas/dbobject/column.py b/pyrseas/dbobject/column.py
index f068806..37b27c3 100644
--- a/pyrseas/dbobject/column.py
+++ b/pyrseas/dbobject/column.py
@@ -56,7 +56,10 @@ class Column(DbSchemaObject):
"""
if hasattr(self, 'dropped'):
return ""
- return "ALTER TABLE %s DROP COLUMN %s" % (self.table, self.name)
+ if hasattr(self, '_table'):
+ return "ALTER TABLE %s DROP COLUMN %s" % (self.table, self.name)
+ else:
+ return "ALTER TYPE %s DROP ATTRIBUTE %s" % (self.table, self.name)
def rename(self, newname):
"""Return SQL statement to RENAME the column
I'll think about it a bit more because it feels a bit like "cheating", but I'll probably commit it or something like it soon.
from pyrseas.
Related Issues (20)
- "KeyError" for partitioned table with indexes (including constraints) HOT 1
- 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
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.