Thread: pgAdmin4 1.0-RC1 - Cannot remove nor change length definition on column in "The Table Dialog"
pgAdmin4 1.0-RC1 - Cannot remove nor change length definition on column in "The Table Dialog"
From
Jan Rössler
Date:
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
Re: pgAdmin4 1.0-RC1 - Cannot remove nor change length definition on column in "The Table Dialog"
From
Dave Page
Date:
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