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 > [email protected] > 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: [EMAIL PROTECTED] ------------------------------------------------------------------------- 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 [email protected] https://lists.sourceforge.net/lists/listinfo/monetdb-developers
