DEV Community

Discussion on: Postgres table partitioning with Rails

View post
Collapse
 
rhymes profile image
rhymes •

Hi @d0nkeybob , I think we're missing some information here to be able to help effectively :)

  • have you tried testing the partitions without Rails? Do the various CRUD operations work?
  • how are the partitions defined?
  • what's the schema of these two tables? what about the constraints?
  • what are you using in Rails to support partitions?
Collapse
 
d0nkeybob profile image
Rich •

Apologies, I'll update the post with that info.

Collapse
 
rhymes profile image
rhymes •

Gathering from your updates:

I have through psql statements. updates don't work.

So the issue is not Rails though. If the CRUD operations don't all work manually, there's probably something wrong in how the partition is set or configured.

Through a check on an id and by month

But what's the schema of the tables? Can you share it? Maybe through sqlfiddle.com/ or db-fiddle.com/ so we can take a look?