Re: database corruption - Mailing list pgsql-hackers

From Tom Lane
Subject Re: database corruption
Date
Msg-id 3112.1062280831@sss.pgh.pa.us
Whole thread Raw
In response to Re: database corruption  (Joe Conway <mail@joeconway.com>)
List pgsql-hackers
Joe Conway <mail@joeconway.com> writes:
> Fortunately this was his own development database he was messing with, 
> but it was an interesting exercise none-the-less. Maybe this reinforces 
> the need to have a command for enabling/disabling triggers.

No, it reinforces the cardinal rule about not experimenting with system
catalog alterations in databases you care about.  If he'd done his
experimentation in a scratch database, he'd not have been in trouble.

Perhaps we need some documentation about What Not To Do As Superuser.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ALTER TABLE ... TO ... to change related names
Next
From: Andrew Dunstan
Date:
Subject: Re: ALTER TABLE ... TO ... to change related names