upgrade-0.8.0-to-0.9.0-postgresql.sql results error: "constraint "uk_fid_ver_del" of relation "fileset_version_info" does not exist"

[zuotingbing]

daip-gravitino-pg=# \d fileset_version_info
Table "public.fileset_version_info"
Column | Type | Collation | Nullable | Default
------------------+------------------------+-----------+----------+----------------------------------
id | bigint | | not null | generated by default as identity
metalake_id | bigint | | not null |
catalog_id | bigint | | not null |
schema_id | bigint | | not null |
fileset_id | bigint | | not null |
version | integer | | not null |
fileset_comment | character varying(256) | | | ''::character varying
properties | text | | |
storage_location | text | | not null |
deleted_at | bigint | | not null | 0
Indexes:
"fileset_version_info_pkey" PRIMARY KEY, btree (id)
"fileset_version_info_fileset_id_version_deleted_at_key" UNIQUE CONSTRAINT, btree (fileset_id, version, deleted_at)
"idx_schema_id" btree (schema_id)

daip-gravitino-pg=# ALTER TABLE fileset_version_info DROP CONSTRAINT uk_fid_ver_del;
ERROR: constraint "uk_fid_ver_del" of relation "fileset_version_info" does not exist
daip-gravitino-pg=#

[jerryshao]

Hi @zuotingbing, thanks for the reporting, maybe there's a bug in it. Let me convert this into an issue.

[zuotingbing]

ok, thank you @jerryshao

[mchades]

Thanks for your report. This is fixed by #9027