Re: Re: pg_dumpall failed

Поиск
Список
Период
Сортировка
От Oleg Lebedev
Тема Re: Re: pg_dumpall failed
Дата
Msg-id 3B8E9BE7.83E9D905@waterford.org
обсуждение исходный текст
Ответ на Re: Re: [SQL] HELP: Trend reporting  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Ответы Re: Re: pg_dumpall failed
Список pgsql-admin
I can't find any reference to this table in my current database.
What's the best way to find this out?
thank you,

Oleg

Stephan Szabo wrote:

> On Thu, 30 Aug 2001, Oleg Lebedev wrote:
>
> > Hi,
> > I am trying to upgrade to 7.1.2 and when I use:
> > pg_dumpall -o > file.bac
> > I get an error saying:
> > dumpRules(): SELECT failed for table setmedias. Explanation from backend:
> > 'ERROR: cache lookup of attribute 5 in relation 23945 failed"
> >
> > As I understand setmedias table corresponds to relation 23945, but I dropped
> > it a long time ago. How should remove this relation pointer?
> > thanks,
>
> It sounds like you have a rule that still refers to the dead table.


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

Предыдущее
От: Stephan Szabo
Дата:
Сообщение: Re: Re: [SQL] HELP: Trend reporting
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: Re: pg_dumpall failed