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. :)

Comments

bjaspan’s picture

StatusFileSize
new25.07 KB

I found the same bug. The previous patch only fixes the _update function, not the _install function. New patch attached.

bjaspan’s picture

StatusFileSize
new2.19 KB

Ooops! Sorry, that was the wrong patch file. Correct one now attached.

ChrisKennedy’s picture

Status: Needs review » Reviewed & tested by the community

RTBC.

dries’s picture

Committed to CVS HEAD. Thanks! :)

hunmonk’s picture

Status: Reviewed & tested by the community » Fixed
Anonymous’s picture

Status: Fixed » Closed (fixed)