Re: Reindex + relation doesnt exist

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Reindex + relation doesnt exist
Дата
Msg-id 20254.1205248027@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Reindex + relation doesnt exist  (frant101@googlemail.com)
Список pgsql-admin
frant101@googlemail.com writes:
> I have tried to put the schema name in front of the index name put i
> still get the same error.

> ./reindexdb -e --index sc1.ind1 hermes
> reindexdb: reindexing of index "sc1.ind1" in database "hermes" failed:
> ERROR:  relation "sc1.ind1" does not exist

AFAICS reindexdb won't allow that --- it quotes the name you supply,
so that's going to look like a table name that happens to contain a
dot, not a schema and table name.

You didn't say where you are inserting the non-default schema path
into your interactive sessions...

            regards, tom lane

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

Предыдущее
От: "Milen A. Radev"
Дата:
Сообщение: Re: helpppppppppppppppp??????????
Следующее
От: Melvin Davidson
Дата:
Сообщение: FILL FACTOR information