Tobias Meyer <t9m@xxxxxxx> writes: > Now I see > select oid,* from pg_largeobject_metadata where oid=665238; > oid | lomowner | lomacl > --------+----------+-------- > 665238 | 16123 | > 665238 | 16123 | > (2 rows) hmm ... is this a reasonably up-to-date v10? > Deleting both would be a no-go, as I cannot INSERT a specific oid to add > one back as far as I know. > So how do I delete only one of the two? Delete by ctid. select ctid, oid, * from pg_largeobject_metadata where oid=665238; delete from pg_largeobject_metadata where ctid = 'pick one'; regards, tom lane
