Tobias Meyer <t9m@qad.com> 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