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.

CommentFileSizeAuthor
comments.patch842 bytesnereocystis
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Dries’s picture

Committed to both the HEAD and the DRUPAL-4-4 branch. Thanks.

Anonymous’s picture