GitHub user zuotingbing created a discussion: 
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"

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=# 

GitHub link: https://github.com/apache/gravitino/discussions/8978

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to