Re: Remove duplicated row in pg_largeobject_metadata - Mailing list pgsql-general

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