https://bz.apache.org/SpamAssassin/show_bug.cgi?id=8098
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- CC| |[email protected] --- Comment #4 from [email protected] --- (In reply to Sidney Markowitz from comment #1) > It looks like the correct fix is to make it totscore = > $self->{tablename}.totscore + ? > > I have attached a patch for perusal by people who know SQL better than I do > and who have access to postgres for testing. if I read the manual correctly, in PostgreSQL at least, you can use the special EXCLUDED prefix to refer to the row that could not be modified due to the conflict. That would make the query: totscore = EXCLUDED.totscore + ? There are a number of examples of this in the documentation: https://www.postgresql.org/docs/15/sql-insert.html I think this might be better than concatenating / pasting the table name as a prefix into the SQL query? -- You are receiving this mail because: You are the assignee for the bug.
