Hi Bas, On Mon, Mar 05, 2012 at 05:17:12AM -0800, Bas Kaptijn wrote:
Hi,
repeatedly we get in a situation where tables end up duplicate in the sys.tables table: SELECT count(*) FROM tables WHERE name='mytable'; returns: 2 We think this should never be the case.
IMHO, that can very well happen: the same table name can occur in multiple schemas; only once per schema, though ...
It seems this gives problems with dumping the database and in other situations.
Could you maybe be more precise about (1) what the exact problem are, (2) how you dump the database (using `mclient --dump` or `msqldump`, or in a "custom" way?), and (3) what the other situations are?
This is an older version of MonetDB (Apr2011 SP1). We want to know whether someone knows this was/is a symptom of any known issue
Sincerely, Bas
Stefan -- | Stefan.Manegold @ CWI.nl | DB Architectures (INS1) | | http://CWI.nl/~manegold/ | Science Park 123 (L321) | | Tel.: +31 (0)20 592-4212 | 1098 XG Amsterdam (NL) |