5106
|
1 -- DROP and re-CREATE type because adding a value isn't possible in transaction
|
|
2 -- https://www.postgresql.org/docs/11/sql-altertype.html#id-1.9.3.42.7
|
|
3
|
|
4 ALTER TABLE import.imports
|
|
5 ALTER COLUMN state DROP DEFAULT,
|
|
6 ALTER COLUMN state TYPE varchar;
|
|
7
|
|
8 DROP TYPE import_state;
|
|
9
|
|
10 CREATE TYPE import_state AS ENUM (
|
|
11 'queued',
|
|
12 'running',
|
|
13 'failed', 'unchanged', 'pending',
|
|
14 'accepted', 'declined', 'reviewed'
|
|
15 );
|
|
16
|
|
17 ALTER TABLE import.imports
|
|
18 ALTER COLUMN state TYPE import_state USING CAST(state AS import_state),
|
|
19 ALTER COLUMN state SET DEFAULT 'queued';
|