Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Bad table attributes count when parsing #161

Open
Fabiencdp opened this issue Mar 7, 2024 · 0 comments
Open

Bad table attributes count when parsing #161

Fabiencdp opened this issue Mar 7, 2024 · 0 comments

Comments

@Fabiencdp
Copy link

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';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant