permission denied for large object 200936761 - Mailing list pgsql-general

From Andrus
Subject permission denied for large object 200936761
Date
Msg-id 47c92baa-949b-92d1-c162-1f0d8348fb50@hot.ee
Whole thread Raw
Responses Re: permission denied for large object 200936761
List 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.

pgsql-general by date:

Previous
From: Marc Millas
Date:
Subject: ransomware
Next
From: Tom Lane
Date:
Subject: Re: libpq and mysterious "invalid byte sequence for encoding UTF8".