hi all,
I've partition a table in PostgreSQL, with rules on UPDATE, DELETE and INSERT.
When I INSERT a row, ok, but when i UPDATE a row, the program raise:
ConcurrentModificationError: Updated rowcount 0 does not match number of
objects updated 1
I know that when i use a RULE the command status return 0:
ma=# SELECT * from smoduls.datirim_prev where id=6;
turno | id | rim_id | prev_id
-------+----+--------+---------
d | 6 | 2 | 12
(1 row)
ma=# UPDATE smoduls.datirim_prev set rim_id=3 where id=6;
UPDATE 0
^^^^^^^^^^^^^^^^^^^^^^^^^^
ma=# SELECT * from smoduls.datirim_prev where id=6;
turno | id | rim_id | prev_id
-------+----+--------+---------
d | 6 | 3 | 12
(1 row)
but is "sane" to catch the exception with pass ?? what can I do to resolve ?
tanks in advance ... I hope that you've understood ;-))
--
#include <stdio.h>
int main(void){char c[]={10,65,110,116,111,110,105,111,32,98,97,114,98,111,110,
101,32,60,104,105,110,100,101,109,105,116,64,116,105,115,99,97,108,105,110,101,
116,46,105,116,62,10,10,0};printf("%s",c);return 0;}
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
