Re: Multiple table entries?

From: Jeff Ross <jross(at)wykids(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Greg Stark <gsstark(at)mit(dot)edu>, Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Multiple table entries?
Date: 2009-08-24 01:24:59
Message-ID: 4A91EBEB.9000608@wykids.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tom Lane wrote:
> Jeff Ross <jross(at)wykids(dot)org> writes:
>
>> Tom Lane wrote:
>>
>>> heap_update is broken. Details left as an exercise for the reader
>>>
>
>
>> Well, as the reader that started this all ;-) should I be worried?
>> Should I do a pg_dump and reinstall? Roll back to 8.3.7? Or just
>> relax, don't worry and have a sparkling adult beverage?
>>
>
> Well, it's a pretty bad bug but as far as I can see a simple "VACUUM
> table" command should fix it up --- would you confirm?
>
> regards, tom lane
>
>
Hah! It did indeed clear it up!

pglogd=# \d
List of relations
Schema | Name | Type | Owner
--------+--------------+-------+-------------
public | full_entries | table | _postgresql
public | full_temp | table | jross
public | log_entries | table | _postgresql
public | page_hits | table | _postgresql
public | total_hits | table | _postgresql
(5 rows)

Thanks, Tom and Greg. Looking forward to 8.4.1 :-)

Jeff

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-08-24 01:54:50 Re: Multiple table entries?
Previous Message Tom Lane 2009-08-24 01:03:36 Re: Multiple table entries?