"jonerf1" <jonesrf1@qwest.net> writes:
> DEBUG: query: INSERT INTO images
> HERE NEXT LINE SHORTENED UP
> VALUES('doss','\\377WPC^\\012\\000\\000\\001\\012\\002\\001\\000\\000\\000\\002\\005\\0\\000\\324')
>
> ERROR: pg_atoi: error in "doss": can't parse "doss"
It'd appear to me that the problem is the lack of a column name list
in this version of the INSERT command. The command is evidently
attempting to insert 'doss' into some integer column. The version
that you said worked called out the two column names explicitly
(and, I infer, skipped at least one integer column).
You should be trying to figure out why the column name list is
missing.
regards, tom lane