From f8438714cad0d6128c8f61d488fb134d8eb6575e Mon Sep 17 00:00:00 2001 From: George Joseph Date: Mon, 28 Aug 2023 07:11:27 -0600 Subject: [PATCH] alembic: Fix quoting of the 100rel column Add quoting around the ps_endpoints 100rel column in the ALTER statements. Although alembic doesn't complain when generating sql statements, postgresql does (rightly so). Resolves: #274 --- .../versions/539f68bede2c_add_peer_supported_to_100rel.py | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/contrib/ast-db-manage/config/versions/539f68bede2c_add_peer_supported_to_100rel.py b/contrib/ast-db-manage/config/versions/539f68bede2c_add_peer_supported_to_100rel.py index 6293dabb0f..99d4065fba 100644 --- a/contrib/ast-db-manage/config/versions/539f68bede2c_add_peer_supported_to_100rel.py +++ b/contrib/ast-db-manage/config/versions/539f68bede2c_add_peer_supported_to_100rel.py @@ -33,9 +33,9 @@ def upgrade(): enum = ENUM(*NEW_ENUM, name='pjsip_100rel_values_v2') enum.create(op.get_bind(), checkfirst=False) - op.execute('ALTER TABLE ps_endpoints ALTER COLUMN 100rel TYPE' + op.execute('ALTER TABLE ps_endpoints ALTER COLUMN "100rel" TYPE' ' pjsip_100rel_values_v2 USING' - ' 100rel::text::pjsip_100rel_values_v2') + ' "100rel"::text::pjsip_100rel_values_v2') ENUM(name="pjsip_100rel_values").drop(op.get_bind(), checkfirst=False) @@ -50,8 +50,8 @@ def downgrade(): enum = ENUM(*OLD_ENUM, name='pjsip_100rel_values') enum.create(op.get_bind(), checkfirst=False) - op.execute('ALTER TABLE ps_endpoints ALTER COLUMN 100rel TYPE' + op.execute('ALTER TABLE ps_endpoints ALTER COLUMN "100rel" TYPE' ' pjsip_100rel_values USING' - ' 100rel::text::pjsip_100rel_values') + ' "100rel"::text::pjsip_100rel_values') ENUM(name="pjsip_100rel_values_v2").drop(op.get_bind(), checkfirst=False) -- 2.47.2