Hello, Noel, here is a very simple test case, which can reproduce the error. Even in InMemory mode. Any comment on schema causes the error. When no comment is set to schema, it works OK.
create schema "S01"; comment on schema "S01" is 'comment01'; create schema "S02"; comment on schema "S02" is 'comment02'; set schema "PUBLIC"; alter schema "S01" rename to "SXX"; alter schema "S02" rename to "S01"; --here is the error My attempt to rename schema is caused by the need to move whole table from one schema to another. Because the tables have tens of millions of records, truncate and insert into from ... select is very slow. Is there any easy way how to reallocate whole table data from one schema to another? I have one schema for each day up to back to 7 days and each day I am shifting data from S01 to S02, S02 to S03... Regards, Stepan Dne úterý 28. listopadu 2017 10:23:16 UTC+1 Noel Grandin napsal(a): > > > Looks like one of the DB schema objects (DATA_D06 ???) has a comment > associated with it, that has not been correctly > moved. Not sure why that is, would need some kind of standalone test case. > > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
