pg-mem
pg-mem copied to clipboard
Support ALTER TYPE
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';
No problem :) Adding it to todo list ... i'll deal with it when I have some spare time !
Looking forward to this feature too :D