As the error message tells you – you can not have two rows with the same value in the columns dementia_type, snapid since they need to be unique.
You have to make sure that the two databases has the same values for dementia_type, snapid.
A workaround would be to add a column to your table alter table t_types_of_dementia add column id serial generated always and use that as primary key instead of your current.
Related Posts:
- ERROR: there is no unique constraint matching given keys for referenced table “bar”
- missing FROM-clause entry for table
- Insert text with single quotes in PostgreSQL
- Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
- Postgresql tables exists, but getting “relation does not exist” when querying
- pg_ctl: no database directory specified and environment variable PGDATA unset
- Postgres Error: More than one row returned by a subquery used as an expression
- What is the difference between LATERAL JOIN and a subquery in PostgreSQL?
- PostgreSQL create table if not exists
- updating table rows in postgres using subquery
- PostgreSQL visual interface similar to phpMyAdmin?
- GROUP BY and COUNT using ActiveRecord
- What are database constraints?
- Postgresql column reference “id” is ambiguous
- What is a postgres superuser
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- SQL WITH clause example [duplicate]
- The wait operation timed out. ASP
- Conversion failed when converting date and/or time from character string while inserting datetime
- how to fix oracle ORA-01722 invalid number error
- SQL query to select dates between two dates
- MySQL – Operand should contain 1 column(s)
- SQL SELECT WHERE field contains words
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- NOT IN vs NOT EXISTS
- Must declare the scalar variable
- How can I do a FULL OUTER JOIN in MySQL?
- MySQL query String contains
- How do I escape a single quote in SQL Server?
- T-SQL split string based on delimiter
- Finding duplicate values in a SQL table
- MySQL Cannot Add Foreign Key Constraint
- mysql Foreign key constraint is incorrectly formed error
- Can a foreign key be NULL and/or duplicate?
- How do I do multiple CASE WHEN conditions using SQL Server 2008?
- How do composite indexes work?
- Difference between JOIN and INNER JOIN
- MySQL “WITH” clause
- What is the difference between JOIN and UNION?
- MySQL Multiple Joins in one query?
- Error Code: 2013. Lost connection to MySQL server during query
- SQL join on multiple columns in same tables
- Sql query – getting rid of hard-coded values
- ORA-00918: column ambiguously defined in SELECT *
- Combining “LIKE” and “IN” for SQL Server
- How To Run A Github Repository?
- SQL Switch/Case in ‘where’ clause
- Oracle – ORA-01489: result of string concatenation is too long [duplicate]
- SQL Server WITH statement
- How to run a SQL query on an Excel table?
- SQL Server reports ‘Invalid column name’, but the column is present and the query works through management studio
- Oracle “Partition By” Keyword
- What is the equivalent of ‘describe table’ in SQL Server?
- Add a column with a default value to an existing table in SQL Server
- Remote table-Valued Function Calls are not allowed
- The backend version is not supported to design database diagrams or tables
- Determine ROW that caused “unexpected end of file” error in BULK INSERT?
- Difference between View and table in sql
- Is there a workaround for ORA-01795: maximum number of expressions in a list is 1000 error?
- How do you force mysql LIKE to be case sensitive?
- ORA-06502: PL/SQL: numeric or value error: character string buffer too small
- What is the difference between a stored procedure and a view?
- Bulk load data conversion error (truncation)
- Insert into a MySQL table or update if exists
- Convert timestamp to date in Oracle SQL
- How to order by with union in SQL?
- Update statement with inner join on Oracle
- Can I use multiple “with”?
- Incorrect syntax near ”
- MySQL: Can’t create table (errno: 150)
- Join vs. sub-query
- DATEDIFF function in Oracle
- MySQL – Get row number on select
- Arithmetic overflow error converting varchar to data type numeric. ’10’ <= 9.00
- Difference between EXISTS and IN in SQL?
- What does * mean in sql?
- How to truncate the text returned for a column in a MySQL query
- What’s the best way to dedupe a table?
- Moving database with phpMyAdmin
- How To Write An Inner Join With WP Query
- How do I escape a table name or column name in SQL? esc_sql doesn’t do this
- Update user_login, user_nicename, and display_name
- Change sticky status of posts from phpMyAdmin
- Best Way to Merge a Dev and Live Site to Become a Staging Site?
- How to import a Typo3 database to a wordpress site?
- Clean up very big and very dirty database
- How to delete ALL comments from certain category in WordPress database?
- How can I convert everything from category X to have post format Link
- Bulk delete WordPress Post and all metadata, etc using SQL query
- Reset post IDs with all post meta
- How to Add or Change Post Title
- Why does DROP TABLE-ing the `wp_options` reset my user session?
- How to refactor DB queries for better TTFB in WordPress?
- query sql-table and change entities
- Duplicate WP Migration affecting site on separate domain?
- Analog category_and (WP) in sql query
- Backtick (MySQL norm) added to SQL Server Query causing error
- SQL query to check whether a meta key is set or not for a post in post_meta table
- Firebase with WordPress instead of SQL?
- Want to delete woocommerce coupon in bulk from phpmyadmin based on published date