On Fri, Nov 30, 2007 at 02:52:34PM -0700, m h wrote:
If I create a table, by default it goes into the "tmp" schema. The "tmp" schema isn't intended for such usage. Its to store 'temporary' tables, ie those created using.
create temp table x With a normal login to MonetDB/SQL using the monetdb user, you will end up in the sys schema, ie new tables are created inside this one. Anyway if you don't want that, then you should create your own schema and user(s) etc. Niels
But when I try to create a "users" table, it complains, since there is one in the "sys" schema. Why doesn't it create one in the "tmp" schema?
ie: CREATE TABLE users (fcol FLOAT(25)); !CREATE TABLE: name 'users' already in use
Just wondering about the resolution order.
thanks
-matt
------------------------------------------------------------------------- SF.Net email is sponsored by: The Future of Linux Business White Paper from Novell. From the desktop to the data center, Linux is going mainstream. Let it simplify your IT future. http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4 _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users
-- 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@cwi.nl