Re: pg_dump Error

Поиск
Список
Период
Сортировка
От Guido Barosio
Тема Re: pg_dump Error
Дата
Msg-id 40E15211.4060009@sinectis.com.ar
обсуждение исходный текст
Ответ на pg_dump Error  ("Nigel Bishop" <Nigel.Bishop@ioko.com>)
Список pgsql-admin
An idea only.

Ever try this?


select reltype from pg_class where relname='foo';

Then, delete the reltype from pg_class

To me goes fine.

Best wishes,
Guido


Nigel Bishop wrote:

>Hi
>
>I'm getting an error with pg_dump:
>
>I'm using
>
>pg_dump -v -C -U username database > ./dumpfile.dmp
>
>and it errors with:
>
>pg_dump: saving database definition
>pg_dump: reading namespaces
>pg_dump: reading user-defined types
>pg_dump: reading user-defined functions
>pg_dump: reading user-defined aggregate functions
>pg_dump: reading user-defined operators
>pg_dump: reading user-defined operator classes
>pg_dump: reading user-defined tables
>pg_dump: Attempt to lock table "Foo" failed.  ERROR:  MySchema:
>permission denied
>pg_dump: *** aborted because of error
>
>
>Issueing a SELECT * FROM PG_TABLES;
>
>Shows:
>
>MySchema   | Foo            | postgres   | t          | f        | f
>
>
>If I try to drop this it errors saying the table foo doesn't exist.
>
>Where did this object come from and how can I resolve the pg_dump error
>
>
>TIA
>
>
>Nigel
>
>---------------------------(end of broadcast)---------------------------
>TIP 7: don't forget to increase your free space map settings
>
>
>
>




В списке pgsql-admin по дате отправления:

Предыдущее
От: "Lee Wu"
Дата:
Сообщение: C function from 7.3.2 to 7.4.3
Следующее
От: "Tuttle, Gene"
Дата:
Сообщение: PL/pgsql