Re: Missing chunk number on a view?

[Keaton Adams <kadams@xxxxxxxxxxx>]

Title: Re: [GENERAL] Missing chunk number on a view?

Sorry.  Good point.  I always try to remember to include that important info:

PostgreSQL 8.1.4 on RHEL 4  (we’re moving to 8.3.x on RHEL 5 this summer)

Thanks again,

Keaton




On 6/11/08 2:20 PM, "Tom Lane" <tgl@xxxxxxxxxxxxx> wrote:

> Keaton Adams <kadams@xxxxxxxxxxx> writes:
> > When I attempt to drop the view I receive the following:
>
> > keaton=# drop view kda_log_data cascade;
> > ERROR:  missing chunk number 0 for toast value 84631845
>
> Presumably the toasted object in question is pg_rewrite's textual
> representation of the view's ON SELECT rule.  If you're lucky, this is
> just an index problem and reindexing pg_rewrite's toast table index will
> fix it.  Since you didn't mention your PG version, I can't give you a
> cookbook recipe for that ...
>
>                         regards, tom lane