#280 postgres alter table error for varchar

3.6.1
open
nobody
PostgreSQL (24)
5
2014-02-28
2012-10-29
helix84
No

When trying to change only varchar length (from 2 to 3 in this example) using alter table, an incorrect SQL command is formed causing the following error:

ERROR: syntax error at or near "("
LINE 2: ALTER "type" TYPE character varying(2)(3),

Discussion

  • Jakub Vrána
    Jakub Vrána
    2012-12-12

    • milestone: --> 3.6.1
     
  • Jakub Vrána
    Jakub Vrána
    2012-12-12

    • assigned_to: jakubvrana --> nobody
     
  • helix84
    helix84
    2014-02-28

    I verified that this works in 4.0.3.