If you have data to share, it needs to be in a regular table. Most likely Ingres will keep it in the cache if it is being continually accessed and updated.
In this way you can be sure if the server fails you will not lose important data. You will be able to recover to a point in time. Perhaps your application would be more suited to DB events? Paul -----Original Message----- From: [EMAIL PROTECTED] On Behalf Of Shearer, Greg GS Sent: Tuesday, 24 October 2006 11:00 AM To: [email protected] Subject: RE: [Users] Session Tables Hi all, I have a related but less technical question on temporary tables. I've only recently made use of Ingres 'declare global temporary table'. The programme involved required frequent temporary updates of data in a small table. My intention (hope?) is that the table will always reside in memory. My understanding of 'how they work' is that ONLY the creating session can see the table at all. Am I missing something, as I would really like to be able to share temporary tables between a programmes. The system has other frequently updating data (1 second updates) which must be shared between programmes. At the moment this is done through a standard database table, which I would like to avoid! One alternative would be to used shared memory, but for elegance it would be nice to retain in a table. Perhaps I don't understand the Ingres 'session' correctly? The documentation says different 'sessions' can create temporary tables having the same name. As they are invisible to other 'sessions', this is not a problem. As a 'session' is within a 'connection', a temporary table should only be seen by the creating programme. So I expected that running queries from other sessions would always fail? Anyway, can someone let me know if my understanding is correct? I've read the Ingres documentation, and tested from isql and I can't see the temporary table. Thanks, Greg Shearer -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Betty & Karl Schendel Sent: Monday, 23 October 2006 6:53 PM To: [email protected] Subject: Re: [Users] Session Tables You wrote: > >Does any body know if there are any system tables I can access that >will let me know if a session table exists No, there isn't. What I have done is write a select against the given session temp, using a bad column name. If the error returned is "bad column", the table exists. If it's "bad table", it doesn't. Karl _______________________________________________ Users mailing list [email protected] http://lists.ingres.com/mailman/listinfo/users The material contained in this email may be confidential, privileged or copyrighted. If you are not the intended recipient, use, disclosure or copying of this information is prohibited. If you have received this document in error, please advise the sender and delete the document. Neither OneSteel nor the sender accept responsibility for any viruses contained in this email or any attachments. _______________________________________________ Users mailing list [email protected] http://lists.ingres.com/mailman/listinfo/users
