Re: from 6.5 > 7.1, cannot pg_dumpall.

From: Patrick Coulombe <pcoulombe(at)mediacces(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: from 6.5 > 7.1, cannot pg_dumpall.
Date: 2001-10-07 19:52:55
Message-ID: 001f01c14f69$a8a54b90$6b0e8242@caroline
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Roth, Michael J. 2001-10-08 08:43:56 Why the table allocates so much Space ?
Previous Message JWDougherty 2001-10-07 08:25:41 Starting Postmaster at boot