use column.copy() for column operations due to SQLAlchemy "column is already attached" issue #753

zzzeek · 2020-11-05T13:07:21Z

the change in sqlalchemy/sqlalchemy#5618 is now hitting me as I'm trying to write a recipe for someone. when we take columns into the operations we should just run _copy() on them so that we dont get the already attached to table issue.

sqla-tester · 2020-11-05T13:22:46Z

Mike Bayer has proposed a fix for this issue in the master branch:

Copy column that's already attached https://gerrit.sqlalchemy.org/c/sqlalchemy/alembic/+/2345

A fix for sqlalchemy#753 was merged in November 2020 and released in 1.5.0 in January 2021. This updates the references to sqlalchemy#753 in cookbook.rst to note that a fix for sqlalchemy#753 has been released.

zzzeek added requires triage New issue that requires categorization bug Something isn't working op directives and removed requires triage New issue that requires categorization labels Nov 5, 2020

zzzeek mentioned this issue Nov 5, 2020

1.3.20 breaks certain Alembic patterns with ArgumentError: column object already assigned to table sqlalchemy/sqlalchemy#5669

Closed

sqlalchemy-bot closed this as completed in a41d5e6 Nov 5, 2020

fitzoh mentioned this issue Feb 6, 2021

Update cookbook.rst references to #753 #791

Merged

1 task

use column.copy() for column operations due to SQLAlchemy "column is already attached" issue #753

use column.copy() for column operations due to SQLAlchemy "column is already attached" issue #753

zzzeek commented Nov 5, 2020

sqla-tester commented Nov 5, 2020

use column.copy() for column operations due to SQLAlchemy "column is already attached" issue #753

use column.copy() for column operations due to SQLAlchemy "column is already attached" issue #753

Comments

zzzeek commented Nov 5, 2020

sqla-tester commented Nov 5, 2020