in reply to Dynamic table names and DBIx::Class

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.

Dum Spiro Spero
  • Comment on Re: Dynamic table names and DBIx::Class

Replies are listed 'Best First'.
Re^2: Dynamic table names and DBIx::Class
by einhverfr (Friar) on Jun 26, 2015 at 06:48 UTC

    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.

[reply]

In Section Seekers of Perl Wisdom