4,568 questions
1
vote
0
answers
71
views
SQL Server Deadlock Delete Insert Statement
Both a delete and insert (range) on the same table are causing a deadlock due to contention on the same primary key index. I don't understand why.
The locks taken are RangeS-S by each process and the ...
- 43
0
votes
1
answer
47
views
How to efficiently match different versions of grouped elements?
I'm trying to remap primary keys between versioned data and code releases with as small a diff as possible.
I have a list of elements, e.g. [a,b,c,...,j], and some deterministic process that assigns ...
- 81
0
votes
1
answer
51
views
JPARepository.save method is not detecting Primary Key Violation trying to insert a record the second time
In a Spring Boot application I tried directly inserting in SQL Server.
CREATE TABLE T_FLATTEN_PROCESSING_INFO(
[HOST_ID] [varchar](150),
[BEGIN_VERSION] [bigint],
[END_VERSION] [bigint],
...
- 79
-1
votes
1
answer
154
views
Obfuscating timestamps in UUID v7
UUID7 is a type of time-ordered UUID, which compared to UUID4:
Does not degrade performance when used as primary keys in databases (e.g. this benchmark).
Includes its creation timestamp, which makes ...
- 11k
1
vote
1
answer
100
views
SQL function to convert ulid stored as VARCHAR(255) to binary(16)
I have a mysql database where everywhere id (Primary Key) is ulid. The problem is that it is stored as VARCHAR(255). I want to correct it (change to binary) the following way:
Add id_bin column of ...
- 53
0
votes
1
answer
62
views
Duplicate Entry Key error when initial 6 characters match [closed]
I have a table BLE_PINS with columns TN, MAC, PIN, and Date. MAC is the primary key. When entering
INSERT INTO `BLE_PINS` (`MAC`, `PIN`) VALUES ('SEEP413E68','99933');
I get the error
#1062 - ...
- 41
1
vote
1
answer
47
views
Does Hibernate support unique constraint inside @TableGenerator
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 ...
- 79
0
votes
2
answers
57
views
Entity's primary key not being updated after changes are saved
I have a DDD setup in C#, linking entities to DB tables. An entity has a configured Id (primary key) that encapsulates a non-negative, non-zero integer (a value object). I have the primary key ...
- 1
0
votes
0
answers
98
views
Oracle constraint stuck in an unusable status
So I have a bit of a pickle.
I have a constraint on a table which is currently in "UNUSABLE" status. I am trying to get it back to "VALID" status.
The normal way to do this is to ...
- 519
0
votes
0
answers
14
views
Is it possible to dedupe child records by date field when uploading supplemental data to Oracle Responsys?
I am new to Oracle responsys so apologies for what might be a foolish question:
Within our account we have a one-to-one relationship between profile lists and profile extension data. As an example, we ...
- 1
0
votes
2
answers
66
views
How to set a primary key in a database created by pandas to_sql() method?
The to_sql() method for Pandas Dataframe is extremely useful, as shown by the example from the documentation
import pandas as pd
from sqlalchemy import create_engine
# Create sqlite engine
engine = ...
- 129
-2
votes
1
answer
109
views
Key isn't auto-incrementing
I have a view model class setup like this:
using System.ComponentModel.DataAnnotations;
namespace Proj1.Models
{
public class Groups
{
[Key]
public int Id { get; set; }
...
- 95
0
votes
1
answer
68
views
Extending IntIdTable in Kotlin Exposed PSQL does not inherit primary key
Problem Summary
I'm trying to create an abstract class UserTable that inherits the IntIdTable of the Kotlin Exposed framework as such:
abstract class UserTable : IntIdTable() {
val userId = ...
- 414
0
votes
0
answers
51
views
SQL Alchemy is not properly updating columns
I have created a sql alchemy script however for some reason it is not behaving as intended:
for index, row in df_journey.iterrows():
journey = JourneySummary(**row)
print(vars(journey))
...
0
votes
0
answers
165
views
Can I use hash partitioning on a non-primary key column in a PostgreSQL table?
I am trying to replace an existing table with a partitioned version of that table. I want the schema of the new partitioned table to exactly match the existing non-partitioned table so that I can ...
- 13