Path: utzoo!utgpu!news-server.csri.toronto.edu!rpi!zaphod.mps.ohio-state.edu!mips!swrinde!elroy.jpl.nasa.gov!decwrl!stanford.edu!leland.Stanford.EDU!chesky
From: chesky@leland.Stanford.EDU (Snehylata Gupta)
Newsgroups: comp.databases
Subject: Re: Ingres system catalogs
Keywords: why not update system catalogs
Message-ID: <1991Apr8.200508.21885@leland.Stanford.EDU>
Date: 8 Apr 91 20:05:08 GMT
References: <773@fdmetd.uucp>
Organization: AIR, Stanford University
Lines: 25

In article <773@fdmetd.uucp> petter@fdmetd.uucp (Petter Henrik Hansen) writes:
>I wish to update the ingres system catalogs directly without using
>the standard Ingres interface (accessdb etc.). I have just 3 questions:
>
>	1. Are the database going to be corrupted because of this?
>	2. WHY in that case will the database be corrupted?
>	3. Anyone out there that has tried this and failed/succeded?
>
>
>Petter Henrik Hansen,  Fellesdata a.s, P.O. Box 248, 0212 OSLO 2, NORWAY

Be extremely careful when you are updating the system catalogs directly
Sometimes you have no choice but to update system catalogs directly.
One way to make sure that database does not get corrupted is not use
use any wild cards or defaults. 

Whether the database may get corrupted depends on what you are updating
in the system catalogs.

I have updated system catalogs a lot for example to change ownership
of objects in the database.

Sanjay

p.s. If you need specific info let me know