int(1) is not a valid data type for a postgres database :)
attached patch changes the data type to 'smallint', which seems to have standard usage in the database updates for postgresql, and most closely matches the corresponding data type in mysql.
tested as working. incidentally, we should probably have some kind of a rule where somebody actually _tries_ the updates for both mysql and postgresql before we commit a db update patch to core. :)
| Comment | File | Size | Author |
|---|---|---|---|
| #2 | system_20.patch | 2.19 KB | bjaspan |
| #1 | database-patch_0.txt | 25.07 KB | bjaspan |
| cache_pgsql.patch | 1.21 KB | hunmonk |
Comments
Comment #1
bjaspan commentedI found the same bug. The previous patch only fixes the _update function, not the _install function. New patch attached.
Comment #2
bjaspan commentedOoops! Sorry, that was the wrong patch file. Correct one now attached.
Comment #3
ChrisKennedy commentedRTBC.
Comment #4
dries commentedCommitted to CVS HEAD. Thanks! :)
Comment #5
hunmonk commentedComment #6
(not verified) commented