I run the following SQL that never commits the transaction: rollback; begin; create table testing_stuff ( id serial, num integer NOT NULL unique deferrable initially immediate ); insert into testing_stuff (num) values (2), (1); -- no issues with deferrable even…
How to Create a Case-Insensitive Unique Compound Index in MongoDB? Question Body: I'm trying to create a compound unique text index in MongoDB with the following fields: tenant_id: 1 seller_id: 1 seller_sku_code: text However, I'm encountering an error when trying…
I am trying to avoid duplicate entries in the table based on type and names however the unique constraint not getting applied. CREATE TABLE IF NOT EXISTS test ( id integer NOT NULL DEFAULT nextval('threshold_retry.threshold_details_id_seq'::regclass), component_type text COLLATE pg_catalog."default" NOT…
I have a table like this: CREATE TABLE "users" ( id serial PRIMARY KEY, town text NOT NULL, street text not null, building text ); I want to be able to store unique entries by 3 columns "town", "street" and…
I refresh my indexes in my Postgresql database with the "reindex index concurrently" command. However, I never renewed my primary key indexes because it might damage my primary key indexes or cause problems. My question is: Is there any harm…
I am trying to add a unique constraint to an existing table in Postgres on a null column named personnel_id. Most of the records have null personnel_id. Here's how I do it: ALTER TABLE "myschema"."mytable" ADD UNIQUE NULLS not distinct…
I am receiving this error message. ERROR: there is no unique constraint matching given keys for referenced table "Employees" This is what I have run: -- Exported from QuickDBD: https://www.quickdatabasediagrams.com/ -- Link to schema: https://app.quickdatabasediagrams.com/#/d/Sa6Ijr -- NOTE! If you have…
I have a table with a unique constraint over 5 columns, all nullable=false. These columns are varchar(30), varchar, 3 float8 columns. There is an autoincrement id column, but that is not included in the constraint. Often times I have duplicates…
I have two tables A and B each with unique constraints for appid and name columns to ensure name is unique for each appid. However, now I also need to ensure that name value is unique across the both tables.…
I am trying to add a column and a new constraint to a simple table in Postgres. It's balking on the keyword UNIQUE. I've gone back and forth between my sliver of code and the documentation for ALTER TABLE, but…