| From: | Matthew Walden <matthew(dot)walden(at)bcs(dot)org> |
|---|---|
| To: | Lukasz Brodziak <lukasz(dot)brodziak(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Zeroing single tuple in data file. |
| Date: | 2010-11-21 19:19:09 |
| Message-ID: | AANLkTimeNEMZfKXt0u9SVajgzZ+8h0Jia625CpAayrQY@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Can you post the select and the exact error?
On Sun, Nov 21, 2010 at 6:43 PM, Lukasz Brodziak
<lukasz(dot)brodziak(at)gmail(dot)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<http://www.postgresql.org/mailpref/pgsql-admin>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matthew Walden | 2010-11-21 19:56:33 | Re: Zeroing single tuple in data file. |
| Previous Message | Lukasz Brodziak | 2010-11-21 18:45:51 | Re: Zeroing single tuple in data file. |