Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group