Re: permission denied for large object 200936761

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: permission denied for large object 200936761
Дата
Msg-id 541b70a0-95cf-d919-0b48-618837481922@hot.ee
обсуждение исходный текст
Ответ на Re: permission denied for large object 200936761  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список 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 по дате отправления:

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: permission denied for large object 200936761
Следующее
От: Martín Marqués
Дата:
Сообщение: Re: vacuum is time consuming