801 B
801 B
Issue when migrating events resolved by running SQL below. User needed updating when running in prod.
CREATE TABLE IF NOT EXISTS hdb_catalog.hdb_source_catalog_version ( version text COLLATE pg_catalog."default" NOT NULL, upgraded_on timestamp with time zone NOT NULL )
TABLESPACE pg_default;
ALTER TABLE hdb_catalog.hdb_source_catalog_version OWNER to postgres; -- Index: hdb_source_catalog_version_one_row
-- DROP INDEX hdb_catalog.hdb_source_catalog_version_one_row;
CREATE UNIQUE INDEX hdb_source_catalog_version_one_row ON hdb_catalog.hdb_source_catalog_version USING btree ((version IS NOT NULL) ASC NULLS LAST) TABLESPACE pg_default;
INSERT INTO hdb_catalog.hdb_source_catalog_version (version, upgraded_on) VALUES ('2', NOW());