就是改了一个格式,为啥就报错了,网上找了很多帖子,还是没有解决我的问题。
而且全部插入也都报错
>>> cur.execute("INSERT INTO aliyun_api(area, time_point,position_coordinate, cldas_ssra, cldas_wind, cldas_temp,cldas_prs,cldas_shu,cldas_prep)VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s)",('没报', '113.164,23.073', '20171211_000000', '0.0', '1.68005454540253', '17.622430419922',' 0.0', '1.00594921971379', '0.0'))
Traceback (most recent call last):
File "<pyshell#25>", line 1, in <module>
cur.execute("INSERT INTO aliyun_api(area, time_point,position_coordinate, cldas_ssra, cldas_wind, cldas_temp,cldas_prs,cldas_shu,cldas_prep)VALUES(%s,%s,%s,%s,%s,%s,%s,%s,%s)",('没报', '113.164,23.073', '20171211_000000', '0.0', '1.68005454540253', '17.622430419922',' 0.0', '1.00594921971379', '0.0'))
psycopg2.InternalError: current transaction is aborted, commands ignored until end of transaction block