permission denied for large object 200936761

From: Andrus <kobruleht2(at)hot(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: permission denied for large object 200936761
Date: 2021-02-01 14:43:29
Message-ID: 47c92baa-949b-92d1-c162-1f0d8348fb50@hot.ee
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

Database does not contain large objects.

pg_dump starts to throw error

ERROR:  permission denied for large object 200936761

Tried

select * from "200936761"

but it returned "relation does not exist"

How to fix this ? How to find which table causes this error ?

How to find and delete all large objects in database ? Maybe it is
created accidently .

Using

 PostgreSQL 12.2 (Debian 12.2-2.pgdg100+1) on x86_64-pc-linux-gnu,
compiled by gcc (Debian 8.3.0-6) 8.3.0, 64-bit

Andrus.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2021-02-01 14:55:22 Re: libpq and mysterious "invalid byte sequence for encoding UTF8".
Previous Message Marc Millas 2021-02-01 14:38:35 ransomware