Come together with the global Drupal community in Rotterdam, 28 Sept – 1 Oct 2026. Sessions, contribution, connection, and Early Bird savings until 8 June.You can't create an index ("KEY" in MySQL) within a CREATE TABLE statement. You need to do a CREATE INDEX statement following the table creation. I've attached my patch.
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | project_release_install_pgsql.patch.txt | 1.63 KB | dww |
| project_release.install.patch | 1.35 KB | Arthaey |
Comments
Comment #1
dwwnow that i have my pgsql test site up again, i'm on a rampage to clean up and fix all the pgsql issues with project*. this is critical for pgsql. i'll take a look at your patch in the near future. meanwhile, if you care about this stuff, please take a look at http://drupal.org/node/82696 and keep your eye out for project + project_issues issues that mention pgsql which are marked as needs review.
thanks!
-derek
Comment #2
dwwyour table names for the indexes don't match the real tables, and the coding style needs a little help (just indentation stuff... core likes to keep such things all on 1 line). i'm cleaning it up right now... stay tuned.
Comment #3
dwwthis appears to work perfectly. anyone else care to test/review before i commit?
thanks,
-derek
Comment #4
dwwafter more testing, committed to HEAD and DRUPAL-4-7--2.
Comment #5
(not verified) commented