[Monetdb-developers] find temp tables....

Niels Nes Niels.Nes at cwi.nl
Sat Jan 5 20:19:54 CET 2008


On Sat, Jan 05, 2008 at 08:08:15PM +0100, Romulo Goncalves wrote:
> In sql we have some problems in locate temp tables. If I create the 
> following table:
> create global temporary t1(id int);
> 
> If I do:
> select * from t1;
> or
> select * from tmp.t1;
> 
> I can see the table. However, When I do alter table, copy into, create 
> trigger, create index statements I cannot detect the table even if I use 
> tmp.t1
> 
> Should I open a bug? Or there is a special reason for this?
There is a simple reason for this all these are only defined/implemented
for persistent tables not for temps. You opened this box of new
features, ie have fun implementing them ;-).

Niels
> 
> Regards,
> Romulo
> 
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2005.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Monetdb-developers mailing list
> Monetdb-developers at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/monetdb-developers

-- 

Niels Nes, Centre for Mathematics and Computer Science (CWI)
Kruislaan 413, 1098 SJ Amsterdam, The Netherlands
room C0.02,  phone ++31 20 592-4098, fax ++31 20 592-4312
url: http://www.cwi.nl/~niels   e-mail: Niels.Nes at cwi.nl




More information about the developers-list mailing list