Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

aerich creates multiple sql queries for a single column update #169

Closed
FIRDOUS-BHAT opened this issue Jun 14, 2021 · 2 comments
Closed

aerich creates multiple sql queries for a single column update #169

FIRDOUS-BHAT opened this issue Jun 14, 2021 · 2 comments

Comments

@FIRDOUS-BHAT
Copy link

Here is what I got,

-- upgrade -- ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE INT USING "subscription_duration"::INT; ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE INT USING "subscription_duration"::INT; ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE INT USING "subscription_duration"::INT; ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE INT USING "subscription_duration"::INT; -- downgrade -- ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE VARCHAR(100) USING "subscription_duration"::VARCHAR(100); ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE VARCHAR(100) USING "subscription_duration"::VARCHAR(100); ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE VARCHAR(100) USING "subscription_duration"::VARCHAR(100); ALTER TABLE "studentchoices" ALTER COLUMN "subscription_duration" TYPE VARCHAR(100) USING "subscription_duration"::VARCHAR(100);

@long2ice
Copy link
Member

Latest source fixed that

@FIRDOUS-BHAT
Copy link
Author

FIRDOUS-BHAT commented Jun 15, 2021

Latest version of aerich is 0.5.3 and the above issue came from the same version only!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants