You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@gravitino.apache.org by "zuotingbing (via GitHub)" <gi...@apache.org> on 2025/11/18 03:09:02 UTC

Re: [D] 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" [gravitino]

GitHub user zuotingbing closed 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 dev@gravitino.apache.org.
To unsubscribe, please send an email to: dev-unsubscribe@gravitino.apache.org