On Thu, Jan 28, 2010 at 10:14 AM, Samuele Kaplun <[email protected]> wrote: > In data giovedì 28 gennaio 2010 10:11:22, Marko Niinimaki ha scritto: >> 2010/1/28 Victor Engmark <[email protected]>: >> > After trying to install, remove, and then install Invenio, it fails at >> > `inveniocfg --load-webstat-conf` saying that "Table 'staEVENT01' >> > already exists". I'm guessing this should have been removed when I ran >> > `inveniocfg --drop-tables` earlier, but that doesn't seem to have >> > happened. Any ideas why? >> >> the tables that are dropped with the --drop-table are listed in >> modules/miscutil/sql/tabdrop.sql > > ...and since the tables in tabdrop.sql are hardcoded they don't include > dynamically created webstat tables. We need to enhance webstatadmin to remove > these tables and trigger this with inveniocfg --drop-tables.
Would it break things for others if we dropped all the tables in the schema, or the entire schema? Otherwise I guess we'll have to parse tabcreate.sql to make sure we get all of them. I guess I'd vote to drop the schema anyway, since auxiliary tables should be in a different schema to avoid namespace collisions when upgrading. -- Victor Engmark
