Re: Need help with corrupt pg_statistic

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Kevin Seghetti <kts(at)tenetti(dot)org>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Need help with corrupt pg_statistic
Date: 2005-10-03 02:01:22
Message-ID: 10288.1128304882@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Kevin Seghetti <kts(at)tenetti(dot)org> writes:
> Is there any way to nuke pg_statistic (since its contents can be
> recalculated anyway?)

You want to do "TRUNCATE pg_statistic"; to avoid the permission check,
you'll need to do that in a standalone backend with -O option.

Do *not* try to drop and recreate it --- its OID is hardwired into
various places.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David Fetter 2005-10-03 05:27:44 Re: [HACKERS] pgAdmin guru hints
Previous Message Tom Lane 2005-10-03 01:53:42 Re: Vacuum Full Analyze Stalled