pg-mem icon indicating copy to clipboard operation
pg-mem copied to clipboard

Support ALTER TYPE

Open gabssnake opened this issue 3 years ago • 2 comments

Feeling guilty from all the issues opened... ^^

Trying to alter types :

-- Our example table and enum type
CREATE SCHEMA humanity;
CREATE TYPE humanity.moods AS ENUM ('happy', 'ok');

-- Use your enum
CREATE TABLE human (mood humanity.moods);
INSERT INTO (mood) VALUES ('happy'), ('ok'), ('happy');

-- Error: Unexpected token "humanity"
ALTER TYPE humanity.moods ADD VALUE 'enthusiastic';

gabssnake avatar Mar 19 '21 08:03 gabssnake

No problem :) Adding it to todo list ... i'll deal with it when I have some spare time !

oguimbal avatar Mar 19 '21 10:03 oguimbal

Looking forward to this feature too :D

hiroshisiqueira avatar Apr 28 '23 20:04 hiroshisiqueira