Re: permission denied for large object 200936761

On 2/1/21 1:28 PM, Andrus wrote:
> Hi!
> 
>  >Long term figure out what they are and if they are needed or not.
> 
> Non-superuser backup worked earlier. It looks like large objects 
> suddenly appeared in database:
> 
> select * from  pg_largeobject_metadata
> 
> Oid                      Lomowner
> 
> 200936761       30152
> 200936762      30152
> 200936767       30152
> 
> How to figure out what are large object with oids   200936761, 200936762 
> and 200936767 ?

I misspoke earlier about large objects not being tied to a schema.table. 
They can be as a column of type oid.

To see if they are try :

SELECT
     relname,
     attname
FROM
     pg_attribute AS pa
     JOIN pg_class AS pc ON pa.attrelid = pc.oid
WHERE
     atttypid = 'oid'::regtype
     AND relnamespace = 'public'::regnamespace
     AND attnum > 0;

Where relnamespace is the schema you are interested in.

> 
> Pd_dump throws error on first of them: 200936761
> 
> Andrus.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com