Error updating from version beta.3 to latest about graphql-engine-heroku HOT 18 CLOSED

ALTER TABLE hdb_catalog.hdb_version ALTER COLUMN hasura_uuid SET DEFAULT gen_random_uuid()

select * from hdb_catalog.hdb_version;
             hasura_uuid              | version |          upgraded_on          | cli_state |            console_sta
te             
--------------------------------------+---------+-------------------------------+-----------+-----------------------
---------------
 cc0447d8-5d56-4fea-84b7-a5f2fd4512ab | 28      | 2019-12-23 07:49:05.254051+00 | {}        | {"telemetryNotificatio
nShown": true}

select column_name, data_type, character_maximum_length from INFORMATION_SCHEMA.COLUMNS where table_schema = 'hdb_catalog' and table_name = 'hdb_version';
  column_name  |        data_type         | character_maximum_length 
---------------+--------------------------+--------------------------
 hasura_uuid   | uuid                     |                         
 version       | text                     |                         
 upgraded_on   | timestamp with time zone |                         
 cli_state     | jsonb                    |                         
 console_state | jsonb                    |

BEGIN;
    INSERT INTO hdb_catalog.hdb_version (version, upgraded_on) VALUES (31, now())
    ON CONFLICT ((version IS NOT NULL))
    DO UPDATE SET version = 31, upgraded_on = now();
ROLLBACK;

postgres --version
postgres (PostgreSQL) 12.1 (Debian 12.1-1.pgdg100+1)

SELECT * FROM pg_indexes WHERE schemaname = 'hdb_catalog' and tablename = 'hdb_version';

 schemaname  |  tablename  |      indexname      | tablespace |                                                 indexdef                                        
         
-------------+-------------+---------------------+------------+-------------------------------------------------------------------------------------------------
---------
 hdb_catalog | hdb_version | hdb_version_pkey    |            | CREATE UNIQUE INDEX hdb_version_pkey ON hdb_catalog.hdb_version USING btree (hasura_uuid)
 hdb_catalog | hdb_version | hdb_version_one_row |            | CREATE UNIQUE INDEX hdb_version_one_row ON hdb_catalog.hdb_version USING btree (((version IS NOT NULL)))

BEGIN;

DROP TABLE hdb_catalog.hdb_version;

CREATE TABLE hdb_catalog.hdb_version (
    hasura_uuid UUID PRIMARY KEY DEFAULT gen_random_uuid(),
    version TEXT NOT NULL,
    upgraded_on TIMESTAMPTZ NOT NULL,
    cli_state JSONB NOT NULL DEFAULT '{}'::jsonb,
    console_state JSONB NOT NULL DEFAULT '{}'::jsonb
);

CREATE UNIQUE INDEX hdb_version_one_row
ON hdb_catalog.hdb_version((version IS NOT NULL));

INSERT INTO hdb_catalog.hdb_version (version, upgraded_on) values (28, now());

COMMIT;

SELECT column_name, column_default
FROM information_schema.columns
WHERE (table_schema, table_name) = ('hdb_catalog', 'hdb_version')
ORDER BY ordinal_position;

FROM hasura/graphql-engine:v1.1.0.cli-migrations

# Workaround for k8s
RUN mkdir -p /usr/sbin/.hasura && chmod 777 /usr/sbin/.hasura

COPY ./migrations /hasura-migrations

{"type":"startup","timestamp":"2020-03-18T07:14:31.126+0000","level":"info","detail":{"kind":"db_migrate","info":"Successfully migrated from catalog version 28 to version 31."}}

  column_name  |  column_default   
---------------+-------------------
 hasura_uuid   | gen_random_uuid()
 version       | 
 upgraded_on   | 
 cli_state     | '{}'::jsonb
 console_state | '{}'::jsonb