Hi, I'll wait for the next release. But I'm not sure what you mean by run that statement. My H2 database is already populated (many tables & data) from previous version of H2 and I want to connect it from ODBC, so to migrate to new version of H2 of course I'll need to backup with runscript from the previous version and then execute script to create the database against the new version, is it considered new database or old? So after I have my H2 database in new version, I need to execute this SQL query to my h2 database? SQL: "delete from pg_catalog.pg_index"
Thanks, Paul On Jul 6, 11:31 pm, Thomas Mueller <[email protected]> wrote: > Hi, > > I think I know where the problem is, but it's relatively complicated > to fix. As a workaround, I have now disabled the index meta data. MS > Access will then ask you for the unique keys, but I guess that's > acceptable. For existing databases, run this statement: delete from > pg_catalog.pg_index; For new databases, you would need to change > pg_catalog.sql (add "and 1=0" to the select statement where > pg_catalog.pg_index is filled) and then re-compile H2. However, I > found out there is still a bug that prevents editing data in MS Access > (UnsupportedOperationException). I will fix that in the next release. > If you want to try, I suggest to use the current trunk. > > Regards, > Thomas -- 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.
