)]}'
{"id":"openstack%2Fdesignate~668616","triplet_id":"openstack%2Fdesignate~stable%2Fstein~Id87bd31513517190474f425acc1b6b0d77279108","project":"openstack/designate","branch":"stable/stein","topic":"bug/1834993","hashtags":[],"change_id":"Id87bd31513517190474f425acc1b6b0d77279108","subject":"sqlalchemy: Fix migrations for PostgreSQL","status":"ABANDONED","created":"2019-07-02 06:50:00.000000000","updated":"2019-07-02 06:50:58.000000000","total_comment_count":0,"unresolved_comment_count":0,"has_review_started":true,"meta_rev_id":"63b18f93cbe8987bcb51fec3bb6136df404bc7d3","_number":668616,"virtual_id_number":668616,"owner":{"_account_id":27056,"name":"Sven Wegener","email":"sven.wegener@stealer.net","username":"swegener"},"actions":{},"labels":{"Verified":{"values":{"-2":"Fails","-1":"Doesn\u0027t seem to work"," 0":"No score","+1":"Works for me","+2":"Verified"},"description":"","default_value":0,"optional":true},"Code-Review":{"values":{"-2":"Do not merge","-1":"This patch needs further work before it can be merged"," 0":"No score","+1":"Looks good to me, but someone else must approve","+2":"Looks good to me (core reviewer)"},"description":"","default_value":0,"optional":true},"Workflow":{"values":{"-1":"Work in progress"," 0":"Ready for reviews","+1":"Approved"},"description":"","default_value":0,"optional":true},"Review-Priority":{"values":{"-1":"Branch Freeze"," 0":"No Priority","+1":"Important Change","+2":"Gate Blocker Fix / Urgent Change"},"description":"","default_value":0,"optional":true}},"removable_reviewers":[],"reviewers":{},"pending_reviewers":{},"reviewer_updates":[],"messages":[{"id":"25daaef1e7bd42411e66efc7f08f1d646df2c4ef","author":{"_account_id":27056,"name":"Sven Wegener","email":"sven.wegener@stealer.net","username":"swegener"},"date":"2019-07-02 06:50:00.000000000","message":"Uploaded patch set 1.","accounts_in_message":[],"_revision_number":1},{"id":"f52b880c074136bb6802cb6112bfdabbab62b8e9","author":{"_account_id":27056,"name":"Sven Wegener","email":"sven.wegener@stealer.net","username":"swegener"},"date":"2019-07-02 06:50:58.000000000","message":"Abandoned\n\nwrong branch","accounts_in_message":[],"_revision_number":1}],"current_revision_number":1,"current_revision":"378c418b9ff613b573062c2833259ddef593abf2","revisions":{"378c418b9ff613b573062c2833259ddef593abf2":{"kind":"REWORK","_number":1,"created":"2019-07-02 06:50:00.000000000","uploader":{"_account_id":27056,"name":"Sven Wegener","email":"sven.wegener@stealer.net","username":"swegener"},"ref":"refs/changes/16/668616/1","fetch":{"anonymous http":{"url":"https://review.opendev.org/openstack/designate","ref":"refs/changes/16/668616/1","commands":{"Checkout":"git fetch https://review.opendev.org/openstack/designate refs/changes/16/668616/1 \u0026\u0026 git checkout FETCH_HEAD","Cherry Pick":"git fetch https://review.opendev.org/openstack/designate refs/changes/16/668616/1 \u0026\u0026 git cherry-pick FETCH_HEAD","Format Patch":"git fetch https://review.opendev.org/openstack/designate refs/changes/16/668616/1 \u0026\u0026 git format-patch -1 --stdout FETCH_HEAD","Pull":"git pull https://review.opendev.org/openstack/designate refs/changes/16/668616/1"}}},"commit":{"parents":[{"commit":"4a564e1804ebe085d4f992423da9ed0ba6c33cbe","subject":"Merge \"Allow pdns4 backend to select tsigkey\" into stable/stein","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/designate/commit/4a564e1804ebe085d4f992423da9ed0ba6c33cbe"}]}],"author":{"name":"Sven Wegener","email":"sven.wegener@inovex.de","date":"2019-06-28 12:12:30.000000000","tz":120},"committer":{"name":"Sven Wegener","email":"sven.wegener@inovex.de","date":"2019-07-02 06:49:44.000000000","tz":120},"subject":"sqlalchemy: Fix migrations for PostgreSQL","message":"sqlalchemy: Fix migrations for PostgreSQL\n\nPostgreSQL does not support specifying the same name for the column, but\ndoes require a name for the enum.\n\nThis fixes:\n\nsqlalchemy.exc.CompileError: PostgreSQL ENUM type requires a name.\n\noslo_db.exception.DBMigrationError: (psycopg2.ProgrammingError) column \"type\" of relation \"recordsets\" already exists\n [SQL: \u0027\\nALTER TABLE recordsets RENAME COLUMN type TO type\u0027] (Background on this error at: http://sqlalche.me/e/f405)\n\nChange-Id: Id87bd31513517190474f425acc1b6b0d77279108\nCloses-Bug: 1834993\nSigned-off-by: Sven Wegener \u003csven.wegener@inovex.de\u003e\n","web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/designate/commit/378c418b9ff613b573062c2833259ddef593abf2"}],"resolve_conflicts_web_links":[{"name":"gitea","tooltip":"Open in GitWeb","url":"https://opendev.org/openstack/designate/commit/378c418b9ff613b573062c2833259ddef593abf2"}]},"branch":"refs/heads/stable/stein"}},"requirements":[],"submit_records":[],"submit_requirements":[]}