When comment.module saves the values of moderation_roles under PostgreSQL, there is a failure. The insert line looks something like this:
drupal=# INSERT INTO moderation_roles (mid, rid, value) VALUES ('6', '2', '-3'), ('5', '2', '-1'), ('4', '2', '1'), ('2', '2', '2'), ('1', '2', '3'), ('6', '3', '-3'), ('5', '3', '-1'), ('4', '3', '1'), ('2', '3', '2'), ('1', '3', '3'), ('6', '4', '-3'), ('5', '4', '-1'), ('4', '4', '1'), ('2', '4', '2'), ('1', '4', '3'), ('6', '5', '-3'), ('5', '5', '-1'), ('4', '5', '1'), ('2', '5', '2'), ('1', '5', '3');
ERROR: syntax error at or near "," at character 71
PostgreSQL only allows one line of insertion with each insert statement, unless the insert statement includes "select".
I have attached a patch which will create one insert statement for each votes entry, rather than just one insert line for all of the combined entries.
Comment | File | Size | Author |
---|---|---|---|
comments.patch | 842 bytes | nereocystis | |
Comments
Comment #1
Dries CreditAttribution: Dries commentedCommitted to both the HEAD and the DRUPAL-4-4 branch. Thanks.
Comment #2
(not verified) CreditAttribution: commented