This one comes from sql. All objects in a schema have to have a unique name. Tables do not create a separate namespace.
Since H2 tries to be an sql db I think this is correct behaviour. Workaround: Name your indexes uniquely ;-) - rami On 23.3.2010 11:28, ulim wrote:
Hello, when I create two indexes of the same name for two different tables, I get an exception that "index already exists" when creating the second one. This is quite awkward, as we have many indexes of the same name in our production database. Is there a workaround? Kind regards, Ulrich
-- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
