Re: Dynamic table names and DBIx::Class

[GotToBTru]

Does your database even support such a thing? In my experience, partitioning is implemented in the DB such that queries are written exactly the same for partitioned and non-partitioned tables. Even if you're willing to hack DBI, access to the individual partitions is not available, or certainly discouraged.

[einhverfr]

The DB (PostgreSQL) does support it. And in fact I have moved a fair bit of the code to a module that doesn't go through DBIx::Class just to avoid this. But DBIx::Class calls still block when an unused partition is locked and that's what I am trying to avoid.