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
Got an error after adding then removing a column multiple times in the destination table:
NOTICE: BULK LOAD START
,ERROR: copy failed: ERROR: function return row and target table row do not match
DETAIL: Returned row contains 24 attribute(s), but target table expects 27.
The table as 24 attributes.
Seems that the value "27" come from the "ordinal_position" of "information_schema.columns" wich look like a autoincrement value. so adding/deleting columns could break the count of attributes.
select ordinal_position
from information_schema.columns
where table_name = 'table_name' and column_name = 'column_name';
The text was updated successfully, but these errors were encountered:
Got an error after adding then removing a column multiple times in the destination table:
The table as 24 attributes.
Seems that the value "27" come from the "ordinal_position" of "information_schema.columns" wich look like a autoincrement value. so adding/deleting columns could break the count of attributes.
The text was updated successfully, but these errors were encountered: