No select possible, but vacuum shows results?

Поиск
Список
Период
Сортировка
От Ralf Tschiersch
Тема No select possible, but vacuum shows results?
Дата
Msg-id Pine.LNX.4.10.10010021547060.30790-100000@dilbert.net-service.de
обсуждение исходный текст
Список pgsql-admin
Hi -

after working for more than 26 hours on my specific problem (pg_log
deleted, all data still in files but not accessible), I have gotten
further for one inch.

Now I can see the relation ("\dt" and "\d tablename" both work proper),
and vaccum shows the correct amount of tuples (and throws nothing away),
but: "select * from tablename" brings 0 rows.

Is there a solution for that? Upgrade from 6.5.3 to 7.0.2?

Greetings
Ralf


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

Предыдущее
От: "omid omoomi"
Дата:
Сообщение: Re: PostgreSQL and Win95/98
Следующее
От: "Paulo Roberto Siqueira"
Дата:
Сообщение: Foreign key