Thanks a lot. I will check it. Paulo
On Mon, May 25, 2009 at 6:19 PM, Michael Bayer <[email protected]> wrote: > > As I said, the issue lies with the usage of the psycopg2 dbapi. Write > a test case using only psycopg2: > > import psycopg2 > conn = psycopg2.connect(user=user, passwd=password) > cursor = conn.cursor() > cursor.execute("my statement") > > Assuming the behavior reproduces, check with their mailing list. > There is nothing SQLAlchemy does outside of the above. > > > > On May 25, 2009, at 11:38 AM, Paulo Nuin wrote: > >> >> 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 [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 -~----------~----~----~----~------~----~------~--~---
