# Primary key constraint on multiple columns

**URL:** <https://community.cratedb.com/t/primary-key-constraint-on-multiple-columns/262>\
**Category:** SQL\
**Created:** [August 3, 2019, 7:05pm UTC](https://community.cratedb.com/t/primary-key-constraint-on-multiple-columns/262 "2019-08-03T19:05:27Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mateusz\_Pytel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/mateusz_pytel/32/120_2.png) [@Mateusz\_Pytel](https://community.cratedb.com/u/Mateusz_Pytel)\
**Post date:** [August 3, 2019, 7:05pm UTC](https://community.cratedb.com/t/primary-key-constraint-on-multiple-columns/262/1 "2019-08-03T19:05:27Z")

</div>

I have created a table with constraints on two columns (of type TEXT and IP), but insert operation works well with just one column different then existing. This leads to duplicates when I want to explicitly have unique values on both columns.

Running a single node

---

<div class="post-metadata">

**Author:** ![smu](https://sea2.discourse-cdn.com/flex020/user_avatar/community.cratedb.com/smu/32/60_2.png) [@smu](https://community.cratedb.com/u/smu)\
**Post date:** [October 24, 2019, 7:18am UTC](https://community.cratedb.com/t/primary-key-constraint-on-multiple-columns/262/2 "2019-10-24T07:18:46Z")

</div>

Can you please provide more information like used CrateDB version, table schema/steps to reproduce?