Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group