 |
Forums |
Admin  Start New Thread
| Message: 45086 |
|
BY: Philip Nelson (scotdb)
DATE: 2008-02-23 22:40
SUBJECT: Schema Dumper Fails because of XML index Alex / Antonio,
I know this is pushing the boundaries a bit.
However, my project is using pureXML within a RoR framework (accessing XML columns through stored procedures).
I've applied your patches (and some of my own) to schema_dumper.rb to allow me to prepare my test database.
However this is failing because it fails to differentiate between an XML index and an ordinary index (and fails because you can't create an ordinary index on an XML column).
I've dug into this a bit. The indexes method in schema_dumper.rb calls the ActiveRecord indexes method. This in turn uses the IBM_DB statistics method to construct an IndexDefinition object. Obviously we can't extend the IndexDefinition object. But I also had a look at the statistics method to see if there is anything at that level which differentiates between the different index types. It seems that there are four definitions of "type" but virtually everything gets put into type 3 (INDEX_OTHER).
So I'm a bit stuck on exactly how to approach this. Probably having to check and eliminate XML indexes using SQL first ?
Any help appreciated.
Phil | |
Thread View
Post a followup to this message
|
|
Schema Dumper Fails because of XML index