There are three indexes created for mysql databases that aren't created for pgsql.

CommentFileSizeAuthor
#1 project_issue_pgsql_indexes.patch.txt2.16 KBdww
project_issue_2.patch1.95 KBdrewish

Comments

dww’s picture

dww
we/he/they
commented
StatusFileSize
new project_issue_pgsql_indexes.patch.txt2.16 KB

This needed a re-roll to fix the update number. However, it also seemed buggy (to my untrained pgsql eyes). For example:

db_query("CREATE INDEX {project_comments}_nid_idx ON {project_issues}(nid)");

Why the {project_issues} at the end there? Seems like a cut and paste bug to me. Attached patch "fixes" this, based on how I think it should work. Utterly untested on pgsql. ;)

drewish’s picture

drewish commented

ah, yeah that looks like a bad copy/paste on my part. not some fancy pgsql trick. hopefully hunmonk can test it out and RTBC it.

hunmonk’s picture

hunmonk commented
Status: Needs review » Reviewed & tested by the community

code looks good. tested on an upgrade and a fresh install, both work perfectly.

dww’s picture

dww
we/he/they
commented
Status: Reviewed & tested by the community » Fixed

Committed to HEAD, backported and committed to DRUPAL-4-7 and DRUPAL-4-7--2.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)