|
What platform is this running on? It looks as if someone executed
a sql script from the Windows environment that contains the control characters and
pointed it to postgres running on Linux/Unix. From:
pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin-owner@xxxxxxxxxxxxxx] On
Behalf Of Marc Fromm In my postgresql logs, found in the pg_log folder, there are
several sql syntax errors where the sql statement is broken up with the
characters “^M”. The error is at the first field name that is broken up by the
^M as shown below in the example. The ^M breaks up the field reference2zip by
splitting it into “r^M” and “eference2zip”. Example -ERROR: syntax error at or near
"eference2zip" at character 699 INSERT INTO loan_requests
(loantype,loan_amt,studentfname,studentlname,studentid,studentdlicense,studentemail,curstudentstreet,curstudentcity,curstudentstate,curstudentzip,curstudentcountry,curstudentphone,permstudentstreet,permstudentcity,permstudentstate,permstudentzip,permstudentcountry,permstudentphone,employername,employerstreet,employercity,employerstate,employerzip,employercountry,parentfname,parentlname,parentstreet,parentcity,parentstate,parentzip,parentcountry,parentphone,reference1fname,reference1lname,reference1street,reference1city,reference1state,reference1zip,reference1country,reference1phone,reference2fname,reference2lname,reference2street,reference2city,reference2state,r^M eference2zip,reference2country,reference2phone,explanation,reason,status)
VALUES ('zzz','zzz','zzz','zzz','zzz','zzz','zzz^M zzz', . . . ) Any ideas on what is generating the ^M and breaking up the
sql statement so that it cannot be executed? Marc |
