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

From Andrus
Subject Re: permission denied for large object 200936761
Date
Msg-id 541b70a0-95cf-d919-0b48-618837481922@hot.ee
Whole thread Raw
In response to Re: permission denied for large object 200936761  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
>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.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: permission denied for large object 200936761
Next
From: Martín Marqués
Date:
Subject: Re: vacuum is time consuming