Skip to content
  • Ryuta Kamizono's avatar
    1745e905
    Allow changing text and blob size without giving the `limit` option · 1745e905
    Ryuta Kamizono authored
    In MySQL, the text column size is 65,535 bytes by default (1 GiB in
    PostgreSQL). It is sometimes too short when people want to use a text
    column, so they sometimes change the text size to mediumtext (16 MiB) or
    longtext (4 GiB) by giving the `limit` option.
    
    Unlike MySQL, PostgreSQL doesn't allow the `limit` option for a text
    column (raises ERROR: type modifier is not allowed for type "text").
    So `limit: 4294967295` (longtext) couldn't be used in Action Text.
    
    I've allowed changing text and blob size without giving the `limit`
    option, it prevents that migration failure on PostgreSQL.
    1745e905
    Allow changing text and blob size without giving the `limit` option
    Ryuta Kamizono authored
    In MySQL, the text column size is 65,535 bytes by default (1 GiB in
    PostgreSQL). It is sometimes too short when people want to use a text
    column, so they sometimes change the text size to mediumtext (16 MiB) or
    longtext (4 GiB) by giving the `limit` option.
    
    Unlike MySQL, PostgreSQL doesn't allow the `limit` option for a text
    column (raises ERROR: type modifier is not allowed for type "text").
    So `limit: 4294967295` (longtext) couldn't be used in Action Text.
    
    I've allowed changing text and blob size without giving the `limit`
    option, it prevents that migration failure on PostgreSQL.
Loading