Re: Zeroing single tuple in data file. - Mailing list pgsql-admin

From Matthew Walden
Subject Re: Zeroing single tuple in data file.
Date
Msg-id AANLkTimeNEMZfKXt0u9SVajgzZ+8h0Jia625CpAayrQY@mail.gmail.com
Whole thread Raw
In response to Zeroing single tuple in data file.  (Lukasz Brodziak <lukasz.brodziak@gmail.com>)
List pgsql-admin
Can you post the select and the exact error?

On Sun, Nov 21, 2010 at 6:43 PM, Lukasz Brodziak <lukasz.brodziak@gmail.com> wrote:
Hello,

I have a problem with one of the tables in my database. The thing is
that one of the rows is present in corresponding data file yet I'm
unable to perform any actions on it including simple SELECT statement.
Is there a way of deleting the tuple from the file by zeroing it and
then reindexing the table. I tried other ways of dealing with the
problem like vacuming and clustering the table but it pops out the
error and terminates when processing the given row. I have several
data folders so when I find the exact error message I will post it

pgsql-admin by date:

Previous
From: Lukasz Brodziak
Date:
Subject: Re: Zeroing single tuple in data file.
Next
From: Matthew Walden
Date:
Subject: Re: Zeroing single tuple in data file.