Re: Remove duplicated row in pg_largeobject_metadata

Tobias Meyer <t9m(at)qad(dot)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