sql - 无法更新或删除表中的行 (Postgres)

Question

我有一个包含 bytea 字段的表。当我尝试从此表中删除一行时，出现这样的错误:

[42704] ERROR: large object 0 does not exist

在这种情况下你能帮我吗？

编辑。来自命令 \d photo 的信息:

    Table "public.photo"
   Column   |          Type          | Modifiers 
------------+------------------------+-----------
 id         | character varying(255) | not null
 ldap_name  | character varying(255) | not null
 file_name  | character varying(255) | not null
 image_data | bytea                  | 
Indexes:
    "pk_photo" PRIMARY KEY, btree (id)
    "photo_file_name_key" UNIQUE CONSTRAINT, btree (file_name)
    "photo_ldap_name" btree (ldap_name)
Triggers:
    remove_unused_large_objects BEFORE DELETE OR UPDATE ON photo FOR EACH ROW EXECUTE PROCEDURE lo_manage('image_data')

Answer 1

放下触发器:

drop trigger remove_unused_large_objects on photo;