Re: from 6.5 > 7.1, cannot pg_dumpall.

Поиск
Список
Период
Сортировка
От Patrick Coulombe
Тема Re: from 6.5 > 7.1, cannot pg_dumpall.
Дата
Msg-id 001f01c14f69$a8a54b90$6b0e8242@caroline
обсуждение исходный текст
Ответ на from 6.5 > 7.1, cannot pg_dumpall.  (Patrick Coulombe <pcoulombe@mediacces.com>)
Список pgsql-novice
> How recent is your last pg_dump backup?
2 weeks... i have more recent versions, but i think those versions are like
actual one.

the table that cause me trouble is contacts_secteurs. i have take a look at
a copy of this table that i did past week. 26 meg of null value! how can i
remove null value from this table is this query doesn't work :

medias=> delete from contacts_secteurs where contact_id is null;
ERROR:  heap_delete: (am)invalid tid

(the index is drop)

patrick


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

Предыдущее
От: JWDougherty
Дата:
Сообщение: Starting Postmaster at boot
Следующее
От: "Roth, Michael J."
Дата:
Сообщение: Why the table allocates so much Space ?