ERROR: there is no unique constraint matching given keys for referenced table “bar”

It’s because the name column on the bar table does not have the UNIQUE constraint.

So imagine you have 2 rows on the bar table that contain the name 'ams' and you insert a row on baz with 'ams' on bar_fk, which row on bar would it be referring since there are two rows matching?

Related Posts:

  1. postgresql: error duplicate key value violates unique constraint
  2. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  3. INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
  4. MySQL Cannot Add Foreign Key Constraint
  5. Can a foreign key be NULL and/or duplicate?
  6. When to use “ON UPDATE CASCADE”
  7. The ALTER TABLE statement conflicted with the FOREIGN KEY constraint
  8. missing FROM-clause entry for table
  9. Insert text with single quotes in PostgreSQL
  10. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  11. Postgresql tables exists, but getting “relation does not exist” when querying
  12. pg_ctl: no database directory specified and environment variable PGDATA unset
  13. Postgres Error: More than one row returned by a subquery used as an expression
  14. What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
  15. PostgreSQL create table if not exists
  16. updating table rows in postgres using subquery
  17. PostgreSQL visual interface similar to phpMyAdmin?
  18. GROUP BY and COUNT using ActiveRecord
  19. Postgresql column reference “id” is ambiguous
  20. What is a postgres superuser
  21. Unknown column in ‘field list’ error on MySQL Update query
  22. When should I use CROSS APPLY over INNER JOIN?
  23. Insert Data Into Temp Table with Query
  24. How to create Temp table with SELECT * INTO tempTable FROM CTE Query
  25. SQL SELECT WHERE field contains words
  26. Using group by on multiple columns
  27. Efficiently convert rows to columns in sql server
  28. Nested select statement in SQL Server
  29. What’s the difference between VARCHAR and CHAR?
  30. How to split the name string in mysql?
  31. Sql Server equivalent of a COUNTIF aggregate function
  32. Column name or number of supplied values does not match table definition
  33. Simple PHP Pagination script
  34. SQL Server FOR EACH Loop
  35. ORA-12560: TNS:protocol adaptor error
  36. How can I select the first day of a month in SQL?
  37. Warning: Null value is eliminated by an aggregate or other SET operation in Aqua Data Studio
  38. SQL – HAVING vs. WHERE
  39. What’s the difference between RANK() and DENSE_RANK() functions in oracle?
  40. MySQL combine two columns into one column
  41. How to SUM two fields within an SQL query
  42. DateTime2 vs DateTime in SQL Server
  43. ORA-01861: literal does not match format string
  44. Difference between numeric, float and decimal in SQL Server
  45. SQL Server Insert if not exists
  46. SQL Server: Invalid Column Name
  47. “ORA-01438: value larger than specified precision allowed for this column” when inserting 3
  48. String or binary data would be truncated. The statement has been terminated
  49. Error converting data type varchar to float
  50. How to concatenate text from multiple rows into a single text string in SQL Server
  51. Count(*) vs Count(1) – SQL Server
  52. Arithmetic overflow error converting numeric to data type numeric
  53. Remove duplicate rows in MySQL
  54. I want to use CASE statement to update some records in sql server 2005
  55. “You tried to execute a query that does not include the specified aggregate function”
  56. How to write a SQL DELETE statement with a SELECT statement in the WHERE clause?
  57. How to round down to nearest integer in MySQL?
  58. How do I reset a sequence in Oracle?
  59. Query to convert from datetime to date mysql
  60. MySQL error: key specification without a key length
  61. SQL: Two select statements in one query
  62. How to query MongoDB with “like”
  63. Check if MySQL table exists without using “select from” syntax?
  64. mysql update column with value from another table
  65. Replacing NULL with 0 in a SQL server query
  66. SQL Server dynamic PIVOT query?
  67. How to delete from multiple tables in MySQL?
  68. How to copy a row and insert in same table with a autoincrement field in MySQL?
  69. Error converting data type varchar
  70. I want to use CASE statement to update some records in sql server 2005
  71. What does Include() do in LINQ?
  72. SQL Server “cannot perform an aggregate function on an expression containing an aggregate or a subquery”, but Sybase can
  73. Get everything after and before certain character in SQL Server
  74. LEFT function in Oracle
  75. Inner Joining three tables
  76. How do I view the Explain Plan in Oracle Sql developer?
  77. ORA-01779: cannot modify a column which maps to a non key-preserved table
  78. SUM OVER PARTITION BY
  79. SQLite string contains other string query
  80. Cannot insert explicit value for identity column in table ‘table’ when IDENTITY_INSERT is set to OFF
  81. Sorting search results by taxonomy terms
  82. How to properly sanitize strings without $wpdb->prepare?
  83. WordPress SQL LIKE request doesn’t work for fields with special symbols
  84. posts_where Fails with More than One Custom Field in Query
  85. Restose content from revisions – sql query
  86. Better way to migrate to server?
  87. Inner Join user tables to select users with roles
  88. $wpdb->prepare with LIKE returning blank array instead of rows
  89. Removing posts by sql
  90. WooCommerce database query : Get product category image path+name from thumbnail_id [closed]
  91. WordPress can I manually add columns in users table and display it in the default manage user plugin and registration form? [closed]
  92. Help me SELECT thumbnail from SQL and use
  93. Why is my insert row only inserting the final row from the loop into the database rather than just inserting one
  94. Search results sort order failing: set by date only
  95. Creating a “forum” – showing last post or last commented post
  96. Replace Unwanted Space in Post Content URL
  97. SQL to transform all email addresses in my DB in lowercase [closed]
  98. How to write inner join using posts_clauses?
  99. Firebase with WordPress instead of SQL?
  100. Want to delete woocommerce coupon in bulk from phpmyadmin based on published date

Leave a Comment