apgdiff icon indicating copy to clipboard operation
apgdiff copied to clipboard

Alter column type is not supported

Open tinganho opened this issue 9 years ago • 0 comments

It seems like altering column type is not suppoerted?

ALTER TABLE users
    ALTER COLUMN email TYPE VARCHAR(50) /* TYPE change - table: users original: VARCHAR(50) NOT NULL UNIQUE new: VARCHAR(50) */,
    ALTER COLUMN email SET NOT NULL;
Exception in thread "main"
cz.startnet.utils.pgdiff.parsers.ParserException: Cannot parse string: ALTER TABLE users
    ALTER COLUMN email TYPE VARCHAR(50) /* TYPE change - table: users original: VARCHAR(50) NOT NULL UNIQUE new: VARCHAR(50) */,
    ALTER COLUMN email SET NOT NULL;
Unsupported command at position 39 'TYPE VARCHAR(50) /* '
``

tinganho avatar Dec 12 '15 04:12 tinganho