You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
v_generate_tbl_ddl pulls comments for tables with the same name in different schemas as the join to information_schema."columns" is only joining on table name. Correct this by adding a condition to join on schema as well as shown below:
OLD Line 273:
ON cl.ordinal_position::integer = des.objsubid AND cl.table_name::NAME = c.relname
NEW Line 273:
ON cl.ordinal_position::integer = des.objsubid AND cl.table_name::NAME = c.relname AND cl.table_schema = n.nspname
The text was updated successfully, but these errors were encountered:
v_generate_tbl_ddl pulls comments for tables with the same name in different schemas as the join to information_schema."columns" is only joining on table name. Correct this by adding a condition to join on schema as well as shown below:
OLD Line 273:
ON cl.ordinal_position::integer = des.objsubid AND cl.table_name::NAME = c.relname
NEW Line 273:
ON cl.ordinal_position::integer = des.objsubid AND cl.table_name::NAME = c.relname AND cl.table_schema = n.nspname
The text was updated successfully, but these errors were encountered: