From b81456cbbf54d31c127b6098a3666535779605ee Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Sat, 19 Jan 2019 17:31:31 -0500 Subject: [PATCH] imperfect but good enough handling of array datatypes for create_linked_legacy_table_from Signed-off-by: Jason Etheridge --- sql/base/base.sql | 7 ++++++- 1 files changed, 6 insertions(+), 1 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index 78babaa..59ad200 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -283,7 +283,12 @@ CREATE OR REPLACE FUNCTION migration_tools.create_linked_legacy_table_from (TEXT create_sql := create_sql || ', '; column_list := column_list || ', '; end if; - create_sql := create_sql || columns.column_name || ' ' || columns.data_type; + create_sql := create_sql || columns.column_name || ' '; + if columns.data_type = 'ARRAY' then + create_sql := create_sql || 'TEXT[]'; + else + create_sql := create_sql || columns.data_type; + end if; column_list := column_list || columns.column_name; END LOOP; create_sql := create_sql || ' ) INHERITS ( ' || migration_schema || '.' || parent_table || ' );'; -- 1.7.2.5