Hi all,

Kind of new to a lot things here so if I am way off please correct me.

using psycopg2 with postgres / greenplum / redshift it's now pretty easy to
have a single query have a affected row count higher than it seems
.rowcount allows for.

I am pretty sure libpq returns the affected row as a string ("for
historical reasons" according to the pg mailing threads) however when I
have a large update statement (e.g. several billion) I seem to get a
.rowcount back that isn't correct.


using the psql client I can't reproduce the affected row count being
incorrect there.


any ideas or suggestions?


thanks

-Mark
_______________________________________________
DB-SIG maillist  -  DB-SIG@python.org
https://mail.python.org/mailman/listinfo/db-sig

Reply via email to