Re: permission denied for large object 200936761

[Andrus <kobruleht2@xxxxxx>]

    >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.
>       
>

pg_dump which throws error is called with -n public -n firma74 parameters

I tried

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

It returs 0 rows.

    Andrus.