Hi
The line on temp2.csv has all the values, and the delimiters are fine:
13177 13177 13177 555.2051 1662.59362792969 64.374802
109 0
If I remove the line, it sometimes fails again on the same line, with
different values then, or fails in another line. I have a series of tab
delimited files to input, and the command fails with different types of
inputs, integer, floats, etc. A larger file also fails in the middle, a
shorter file also fails. Testing all the possible input sizes on psql,
everything is smooth and the inputs are accepted.
Thanks
Paulo
Michael Bayer wrote:
> 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 sqlalchemy@googlegroups.com
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
