David,

There is no journaling either. Journals are in fact written from the
transaction log file, so if there's no logging, there cannot be any
journaling.

John

-----Original Message-----
From: info-ingres-bounces (AT) kettleriver...ting (DOT) com
[mailto:info-ingres-bounces (AT) kettleriverconsulting (DOT) com] On Behalf Of
David Greenberg
Sent: Wednesday, 10 June 2009 5:54 PM
To: info-ingres (AT) kettleriverconsulting (DOT) com
Subject: [Info-Ingres] Journaling on a temprary global table

Hi
We use Inges 2.0 on VMS.

I know that logging is not performed on temporary global tables.
What about journaling ?

David Greenberg

Hi
We use Inges 2.0 on VMS.

I know that logging is not performed on temporary global tables.
What about journaling ?

David Greenberg

David Greenberg wrote:

Nope. Apart from the fact that the journals are constructed by
harvesting the log file, you would need to terminate the session that
owns the table in order to roll it forward so there would be no table to
recover.

But perhaps you just want to audit it? Unfortunately you can't do that
either.

--
Roy

UK Ingres User Association Conference 2009 will be on Tuesday June 9, 2009
See www.iua.org.uk/docs/IUA_Invitation_2009.pdf