postgres alter table error for varchar

Database management in a single PHP file

Brought to you by: jakubvrana

#280 postgres alter table error for varchar

Milestone: 3.6.1

Status: closed-out-of-date

Owner: nobody

Labels: PostgreSQL (42)

Priority: 5

Updated: 2018-01-24

Created: 2012-10-29

Creator: helix84

Private: 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 - 2012-12-12

milestone: --> 3.6.1
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jakub Vrána - 2012-12-12

assigned_to: jakubvrana --> nobody
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

helix84 - 2014-02-28

I verified that this works in 4.0.3.

If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

Jakub Vrána - 2018-01-24

status: open --> closed-out-of-date
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:

postgres alter table error for varchar

Database management in a single PHP file

Group

Searches

Help

#280 postgres alter table error for varchar

Discussion