# Issue with declaring composite key in ROM

**URL:** <https://discourse.rom-rb.org/t/issue-with-declaring-composite-key-in-rom/105>\
**Category:** Issues\
**Created:** [November 16, 2016, 11:28pm UTC](https://discourse.rom-rb.org/t/issue-with-declaring-composite-key-in-rom/105 "2016-11-16T23:28:42Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![bluekites](https://avatars.discourse-cdn.com/v4/letter/b/ac8455/32.png) [@bluekites](https://discourse.rom-rb.org/u/bluekites)\
**Post date:** [November 16, 2016, 11:28pm UTC](https://discourse.rom-rb.org/t/issue-with-declaring-composite-key-in-rom/105/1 "2016-11-16T23:28:42Z")

</div>

I was trying to follow the documentation to create a composite key for a relation.

The current setup is `primary_key :job_id, :user_id`

However, calling the primary\_key only yields the `job_id` and does not return both values. I believe this is preventing me from updating and deleting `by_pk`

Please advise.

---

<div class="post-metadata">

**Author:** ![solnic](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.rom-rb.org/solnic/32/279_2.png) [@solnic](https://discourse.rom-rb.org/u/solnic)\
**Post date:** [November 17, 2016, 11:51am UTC](https://discourse.rom-rb.org/t/issue-with-declaring-composite-key-in-rom/105/2 "2016-11-17T11:51:13Z")

</div>

Do you use inferred schemas? As in `schema(infer: true)` in your relation?

---

<div class="post-metadata">

**Author:** ![bluekites](https://avatars.discourse-cdn.com/v4/letter/b/ac8455/32.png) [@bluekites](https://discourse.rom-rb.org/u/bluekites)\
**Post date:** [November 17, 2016, 4:21pm UTC](https://discourse.rom-rb.org/t/issue-with-declaring-composite-key-in-rom/105/3 "2016-11-17T16:21:49Z")

</div>

Yes sir, I tried both using inferred schemas and without. Same result only one primary\_key detected.

We were able to work around it after finding the `view` on line 67 of `rom-sql/lib/rom/sql/relation.rb` to customize it to read our composite keys.

---

<div class="post-metadata">

**Author:** ![solnic](https://yyz1.discourse-cdn.com/flex029/user_avatar/discourse.rom-rb.org/solnic/32/279_2.png) [@solnic](https://discourse.rom-rb.org/u/solnic)\
**Post date:** [December 2, 2016, 11:46am UTC](https://discourse.rom-rb.org/t/issue-with-declaring-composite-key-in-rom/105/4 "2016-12-02T11:46:35Z")

</div>

Could you report an issue in rom-sql explaining what problems you had and how you worked around them? We should address it somehow