On 11/26/2015 7:11 PM, mrtruji wrote:
for x in features:
cur.execute('insert into data (features_bin) values (%s);',[x])
conn.commit()
yup, my guess was right. you inserted new rows with the features_bin
field, but no other fields.
you want to use UPDATE, not INSERT, and you'd better have some way of
specifying which row you want each UPDATE to modify... like...
UPDATE data SET features_bin = %s WHERE id = ....;
--
john r pierce, recycling bits in santa cruz
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
