Hi Andrew, > While creating a table using the latest development build, I was asked > which schema should contain the table. My two choices were > INFORMATION_SCHEMA and PUBLIC. Which schema should I use and why? The > default is INFORMATION_SCHEMA.
It's a bug in the table wizard that you're offered this choice, it will be fixed in m121 or so. > My expectation was that it should be stored in PUBLIC, but the default > is the other. I was not able to actually create the tables to see if I > could notice a difference, because the table creation wizard always > crashed when I selected Finish. Then again, the wizard had some other > problems as well :-( Yes, there were a number of problems caused by the schema selection, see issue 52305. > This lead me to ask, what is the definition of CATALOG and SCHEMA, as > they relate to OpenOffice.org. As with any other database :) HSQLDB 1.8, which is used nowadays, in theory supports schemas, and has two default schemas: PUBLIC (where all tables usually go) and INFORMATION_SCHEMA, which is only for internal purposes. However, when integrated into OOo, schema support is disabled (because it was a too-late change to fully incorporate, and because our HSQLDB integration targets at use cases which we don't want to complicate with such strange concepts as "schemas"). Obviously, the table wizard originally slipped our attention when we did this disabling :) Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Database http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
