Thanks - logged here: https://redmine.postgresql.org/issues/1669
On Tue, Sep 6, 2016 at 2:39 AM, Jan Rössler <jan.rossler1@gmail.com> wrote:
> Hello,
>
> it currently seems to be impossible to change or remove "length" from a
> column's definition.
>
> How to reproduce:
> 1. CREATE TABLE test(string character varying(1));
> 2. In sidebar, right click on "test" table and select "Properties"
> 3. Select "Columns"
> 4. Press the edit icon on column "string"
> 5. Go to the "Definition" tab
> 6. Delete the "Length" value
> 7. Press "Save" button
>
> The inline value of length will change by itself to NaN and an error message
> saying "can't execute an empty query" is returned when trying to save. When
> I try to delete the length value inline, same error message is also returned
> upon save. Meanwhile the SQL tab only shows "--modified SQL", instead of the
> needed ALTER statement.
>
> When I want to just edit the length to a different value, it doesn't work
> either. In this case some SQL does get generated, but it is not a valid
> statement (at least not on version 9.3).
> The error message is: ERROR: syntax error at or near "," LINE 2: ALTER
> COLUMN string TYPE character varying (11, None);
>
> Tested on: pgAdmin4 1.0-RC1 Desktop, Windows 7 x64, Server: PostgreSQL 9.3.4
>
>
> Regards,
> Jan Rössler
--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake
EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company