Mercurial > gemma
view schema/updates/1431/01.add_state.sql @ 5115:bb5459faadb7 queued-stage-done
Dont leave old jobs behind if retrying remove jobs.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Wed, 25 Mar 2020 18:02:46 +0100 |
parents | 13fff84c2b70 |
children |
line wrap: on
line source
-- DROP and re-CREATE type because adding a value isn't possible in transaction -- https://www.postgresql.org/docs/11/sql-altertype.html#id-1.9.3.42.7 ALTER TABLE import.imports ALTER COLUMN state DROP DEFAULT, ALTER COLUMN state TYPE varchar; DROP TYPE import_state; CREATE TYPE import_state AS ENUM ( 'queued', 'running', 'failed', 'unchanged', 'pending', 'accepted', 'declined', 'reviewed' ); ALTER TABLE import.imports ALTER COLUMN state TYPE import_state USING CAST(state AS import_state), ALTER COLUMN state SET DEFAULT 'queued';