pgadmin-org / pgadmin4

pgAdmin is the most popular and feature rich Open Source administration and development platform for PostgreSQL, the most advanced Open Source database in the world.
https://www.pgadmin.org
Other
2.53k stars 656 forks source link

ALTER COLLUMN bug (RM #3742) #2145

Closed dpage closed 2 years ago

dpage commented 6 years ago

Issue migrated from Redmine: https://redmine.postgresql.org/issues/3742 Originally created by STEPHEN MAGEIRAS at 2018-11-02 17:41:08 UTC.

STEP 1: Tables > Properties > Columns STEP 2: "Edit row" icon > Definition tab

when try to alter the:

two kinds of errors occures for specific types (as shown on attached images): 1) a syntax error (most os the cases) 2) or a type modifier error

both are working properly on the collumn property form.

(No time to test for the rest of types, except for "character varying" that works properly).

dpage commented 6 years ago

Attachment migrated from Redmine: https://redmine.postgresql.org/attachments/download/3411 Originally created by STEPHEN MAGEIRAS at 2018-11-02 17:34:05 UTC.

https://pgadmin-archive.postgresql.org/redmine/3742/3411-ALTER_TYPE_Bugs.7z

dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3742#note-2 Originally created by Akshay Joshi at 2018-11-16 10:34:21 UTC.

Redmine ticket header update:

Name Old Value New Value
Sprint changed Ready
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3742#note-3 Originally created by Akshay Joshi at 2018-11-19 09:15:21 UTC.

Redmine ticket header update:

Name Old Value New Value
Status changed New In Progress
Assigned To changed Akshay Joshi
Sprint changed Ready EDB Sprint 27
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3742#note-4 Originally created by Akshay Joshi at 2018-11-19 11:45:11 UTC.

Patch Sent: https://www.postgresql.org/message-id/CANxoLDdnbzHnf7ofqzCj5qfCx4zEHRASzV9yxSSg27hWYHSZAg@mail.gmail.com

dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3742#note-5 Originally created by Dave Page at 2018-11-20 16:27:21 UTC.

Redmine ticket header update:

Name Old Value New Value
Assigned To changed Akshay Joshi Fahar Abbas
Fixed Version changed 3.6
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3742#note-6 Originally created by Akshay Joshi at 2018-11-20 16:29:24 UTC.

Applied in changeset commit:8b5abdfa8f996773fd5819ccaf92941503089a2d.

Redmine ticket header update:

Name Old Value New Value
Status changed In Progress In Testing
Done Ratio changed 0 90
dpage commented 5 years ago

Comment migrated from Redmine: https://redmine.postgresql.org/issues/3742#note-7 Originally created by Fahar Abbas at 2018-11-27 11:54:57 UTC.

Tested in the pgadmin4 3.6 Release installer on Windows 64.

Redmine ticket header update:

Name Old Value New Value
Status changed In Testing Resolved
Done Ratio changed 90 100
dpage commented 2 years ago

Issue closed on Redmine.