Re: from 6.5 > 7.1, cannot pg_dumpall. - Mailing list pgsql-novice

From Patrick Coulombe
Subject Re: from 6.5 > 7.1, cannot pg_dumpall.
Date
Msg-id 001f01c14f69$a8a54b90$6b0e8242@caroline
Whole thread Raw
In response to from 6.5 > 7.1, cannot pg_dumpall.  (Patrick Coulombe <pcoulombe@mediacces.com>)
List 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 by date:

Previous
From: JWDougherty
Date:
Subject: Starting Postmaster at boot
Next
From: "Roth, Michael J."
Date:
Subject: Why the table allocates so much Space ?