Skip to main content
AI Assist is now on Stack Overflow. Start a chat to get instant answers from across the network. Sign up to save and share your chats.
1,384 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
2 votes
2 answers
202 views

I understand that soft deletion is useful for preserving data history and avoiding the need to manually handle child records. However, soft deletion can cause issues with unique constraints. For ...
laitmiro's user avatar
  • 324
1 vote
3 answers
224 views

We have two columns, id_begins and id_ends. We use a BETWEEN statement to select the row where a specific id number will fit between the values in those two fields (including the begins and ends ...
dallin's user avatar
  • 9,514
3 votes
0 answers
86 views

I am encountering an error when trying to save data using JPA and Hibernate. The error message is: Caused by: org.hibernate.MappingException: Foreign key (FKi3uxs48nod3arim7hhpwx1anb:role_group [...
Mahdi Sahebzamani's user avatar
  • 31
0 votes
1 answer
61 views

I have table_1 and table_1_history in PostgreSQL. I have setup a trigger for insert, update, delete on table_1. So any changes in table_1 will reflect to table_1_history and will create a new row. ...
Sachin's user avatar
  • 65
1 vote
2 answers
127 views

I have a filtered unique index defined as: builder .HasIndex(e => new { e.UserId, e.IsDefault }) .HasFilter($"[{nameof(MyEntity.IsDefault)}] = 1") .IsUnique() ....
Seb's user avatar
  • 830
0 votes
0 answers
44 views

I'm working with a MySQL table that has a composite unique constraint on two columns (column1 and column2), like this: CREATE TABLE example_table ( column1 INT, column2 INT, column3 ...
Saggy's user avatar
  • 85
0 votes
1 answer
32 views

Using the module Event (website_event_sale), there is an error occuring for some (few) of the customers in front office, when they click on the REGISTER-button that bring to the cart: ERROR xxxxx-oerp-...
S Bonnet's user avatar
  • 1,720
1 vote
1 answer
63 views

I tried generating the values for my primary keys using @tableGenerator annotation. Since this annotation will create a table and generate the value from it, I want to place a unique constraint on the ...
Chris's user avatar
  • 89
0 votes
1 answer
181 views

Below is my update query : update table_name set Name = concat('zzzz', Name) where ID = 100 The table has unique constraint on ID and Name - UNIQUE KEY `UK_table_name` (`ID`,`Name`) ID and Name are ...
Manika Midha's user avatar
  • 1
2 votes
1 answer
56 views

I have the following entity model class: public class RoutePermission { public Guid? UserId { get; set; } public Guid? DistrictId { get; set; } public Guid RouteId { get; set; } public ...
Shmuli Adelman's user avatar
  • 138
1 vote
1 answer
100 views

I have several tables in which "whole" items are stored across multiple columns for each of their "parts," and I wish to ensure that the "whole" is unique. These tables ...
Josh's user avatar
  • 1,093
0 votes
1 answer
488 views

I have the following table definition in the schema on pgAdmin4 I'm trying to execute: CREATE TABLE IF NOT EXISTS Reporting ( SEQ integer, Product character varying(30) NOT NULL, Version integer ...
S'mon's user avatar
  • 25
3 votes
2 answers
1k views

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 ...
Adam A's user avatar
  • 14.7k
0 votes
2 answers
152 views

I'm trying to build up my first project in Django and I'm having some issues while creating an entry into my model Prevision (including sales forecasts), which has a uniqueConstraint to ensure that ...
grover999's user avatar
  • 303
0 votes
1 answer
117 views

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 ...
Brainfuck's user avatar
  • 61

15 30 50 per page
1
2 3 4 5
…
93