Hello Jean-Pierre, Monday, October 23, 2006, 6:39:34 AM, you wrote:
> Hello Greg, > In the past someone ask this on the internal Ingres mail list (in CA) and I > think the answer is no. > Perhaps we need a DAR here. Something like ... > - CREATE TABLE [IF NOT EXISTS] on mysql > - CREATE OR REPLACE on oracle > snip :-) > There is no way with system catalogs because those tables do not > have any entries here (all in memory). I suppose there is perhap's a > way in asking to ima but I did not find it ... As I mentioned in an earlier response, the SQL standard defines three types of temporary table. Ingres implements the Type 1 tables which are created using DECLARE GLOBAL TEMPORARY TABLE. What you are describing is already defined as a Type 2 or Type 3 "created" temporary table which is created using CREATE TEMPORARY TABLE and which has catalogue entries. I think Type 2 temporary tables (at least) would be a useful enhancement. I am a bit wary of the CREATE OR REPLACE syntax, but I'm not opposed to it. Roy _______________________________________________ Users mailing list [email protected] http://lists.ingres.com/mailman/listinfo/users
