[odb-users] Same obect in multiple schemas with different table names

[Seymour, Robert]

Hi,

I'm trying to use the same class in two schemas within the same application.  I'm building for SQLITE (I have a database file per schema)
When I do the odb::schema_catalog::create_schema() call I give the corresponding schema name for each database.  This all looks correct, when I use sqlite command line I see the schema in each database as expected.

However I notice that when performing transactions if the table names are not the same in both schemas for the given class I get an exception about no such table existing and it gives the name from the other schema.  The code is segregated so there is no overlap in the header files.

Is it possible to have the same class in multiple schemas (-schema-name) that have different table names for sqlite?

Thanks,
-Rob