On May 25, 2009, at 11:13 AM, nuin wrote:
> sqlalchemy.exceptions.DataError: (DataError) missing data for column
> "spectral_analysis_id"
> CONTEXT: COPY precursor, line 360: "13177 13177 13177
> 555.2051 1662.59362792969 64.374"
> "COPY precursor (spectrum_number, scan_begin, scan_end, mass, mtoz,
> elution_time_begin, spectral_analysis_id, charge) F
> ROM 'C:/Users/nuin/workspace/OCBN/src/ipad_parser_1/temp2.csv' " {}
>
im not familiar with direct usage of COPY FROM but it seems here like
line 360 of your input file only has six elements and the COPY
statement is asking for eight. its not a SQLalchemy issue in any
case and if anything would be specific to psycopg2, if at all.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
