Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
The datestamp field is defined as type=int, length=11. When a datestamp field is added, this spec gets translated by db_add_field into the following query
ALTER TABLE {content_type_foo} ADD COLUMN field_bar_value int(11)
This query fails with a syntax error on postgres, because you cannot specify the numeric length for int fields in Postgres. It seems likely that the size parameter is unnecessary, since in MySQL it is only used for display padding and string compares.
Patch attached.
Comment | File | Size | Author |
---|---|---|---|
datestamp_length.patch | 455 bytes | gdd | |
Comments
Comment #1
gddoops setting status
Comment #2
KarenS CreditAttribution: KarenS commentedRight, that should never have been there, but apparently no one ever noticed (or at least no one reported this that I can remember.)
Thanks!
Comment #3
Anonymous (not verified) CreditAttribution: Anonymous commentedAutomatically closed -- issue fixed for two weeks with no activity.