Re: Broken pg_class table

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Roger Ging <roger(at)musicreports(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Broken pg_class table
Date: 2006-07-16 05:13:01
Message-ID: 27390.1153026781@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Roger Ging <roger(at)musicreports(dot)com> writes:
> I accidentally wrecked the pg_class table in a database by leaving off
> the where clause of an update statement when setting the reltriggers
> back to the count from pg_trigger after a bulk data load.

What was the *exact* update statement, and which PG version is this?

regards, tom lane

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Roger Ging 2006-07-16 15:28:35 Re: Broken pg_class table
Previous Message Devrim GUNDUZ 2006-07-15 08:45:56 Re: Recycle error logs