Re: 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(at)sss(dot)pgh(dot)pa(dot)us> wrote:

Keaton Adams <kadams(at)mxlogic(dot)com> 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