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.

CommentFileSizeAuthor
datestamp_length.patch455 bytesgdd
Support from Acquia helps fund testing for Drupal Acquia logo

Comments

gdd’s picture

Status: Active » Needs review

oops setting status

KarenS’s picture

Status: Needs review » Fixed

Right, that should never have been there, but apparently no one ever noticed (or at least no one reported this that I can remember.)

Thanks!

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.