Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!cs.utexas.edu!uunet!dev!dgis!jkrueger
From: jkrueger@dgis.dtic.dla.mil (Jon)
Newsgroups: comp.databases
Subject: Re: Request for Info: Journaling Ingres System Catalogs
Keywords: ingres database
Message-ID: <689@dgis.dtic.dla.mil>
Date: 6 Dec 89 17:46:04 GMT
References: <566@rd-atlas.UUCP>
Organization: Defense Technical Information Center (DTIC), Alexandria VA
Lines: 19

osfile@rd-atlas.UUCP (OS File User) writes:

>We are trying to use the Ingres journalization facility to trap changes we
>make to our database structures.  We want to be able to use information from
>the journal file to feed an external data dictionary.  We have not been able
>to cause the system to journalize changes to the system tables (e.g. the
>attribute table).

Journalling logs changes to data, not structure.

There are simpler mechanisms to do what you want.  E.g., save
your SQL scripts that define schema ("create table") as ordinary
files, and source control those files.

-- Jon
-- 
Jonathan Krueger    jkrueger@dtic.dla.mil   uunet!dgis!jkrueger
Isn't it interesting that the first thing you do with your
color bitmapped window system on a network is emulate an ASR33?