constraints Questions
3
Solved
I've searched and have found answers that make sense when you have access to change an existing interface definition. In my case, I do not have that ability. I'm trying to create a new object with ...
Victorie asked 7/10 at 19:38
1
Is it possible to create a partial foreign key (similar to partial indexes) in general sql / postgresql? I have not found a way to force referential integrity in the following case:
Table A is soft...
Helsell asked 28/11, 2017 at 13:1
3
Solved
I'm trying to solve a second order ODE using odeint from scipy. The issue I'm having is the function is implicitly coupled to the second order term, as seen in the simplified snippet (please ignore...
Alarick asked 10/5, 2014 at 7:58
2
Solved
I have the following unique constraint
dup_Checklist_QNum UNIQUE (QUESTION_NO, IS_ACTIVE)
I am trying to prevent two questions having the same question number while being active (IS_ACTIVE value...
Propaedeutic asked 4/7, 2012 at 22:9
4
How to set default spacing between rgb views (100pt) if their container (VStack) not conflicts with bottom black view.(like iPhone 11 Pro Max). BUT shrinks if there is no space for 100p height.(lik...
Ammadis asked 2/12, 2019 at 9:15
6
Solved
I am trying to generate a list of all combinations numbers that satisfy all the following conditions:
Any combination is exactly 6 numbers long
The possible numbers are only 1,5,7
1 can only be fo...
Annapolis asked 1/5 at 3:42
5
Solved
I want to have a SQL table with two columns. One is a key into another table, the other holds a string literal. The idea is phone numbers can be entered either exactly (in which case the ID into th...
Spagyric asked 8/4, 2011 at 11:39
3
Solved
I got a pyomo concrete model with lots of variables and constraints.
Somehow, one of the variable inside my model violates one constraint, which makes my model infeasible:
WARNING: Loading a Solv...
Scrimmage asked 26/6, 2018 at 13:36
1
I've written the following program that uses requires without parentheses. The program compiles with msvc but not with gcc and clang. I want to know which compiler is right here. Demo
#include <...
Unemployment asked 13/3 at 15:47
16
Solved
Why doesn't a TRUNCATE on mygroup work?
Even though I have ON DELETE CASCADE SET I get:
ERROR 1701 (42000): Cannot truncate a table referenced in a foreign key constraint (mytest.instance, CONST...
Prohibitionist asked 27/3, 2011 at 21:57
7
Solved
I would like to add a BOOLEAN column to a MySQL table which will be named is_default. In this column, only one record can have is_default set to true.
How can I add this constraint to my column wi...
Churr asked 6/1, 2011 at 17:43
2
I'm developing an application with core data. There are many entities that uses relationships and in many of them they are the primary key.
I'm trying to use the unique constraints feature in the x...
Voiced asked 27/7, 2016 at 7:0
12
Solved
I have a table whose primary key is used in several other tables and has several foreign keys to other tables.
CREATE TABLE location (
locationID INT NOT NULL AUTO_INCREMENT PRIMARY KEY
...
) E...
Hermit asked 8/5, 2009 at 5:25
4
If I have a table in Postgresql:
create table Education (
id integer references Profiles(id),
finished YearValue not null,
started YearValue,
qualification text,
schoolName text,
studiedAt ...
Felicefelicia asked 27/3, 2011 at 7:47
2
Solved
Currently In our database design we have an circular reference between two entities. In other words, we have foreign keys in each table that reference each others primary key. In order to insert re...
Nuli asked 15/6, 2009 at 20:41
2
Solved
I have read about notnull constraint in C# and it was written that "This allows either value types or non-nullable reference types but not nullable reference types."
(the quote is from &q...
Nonbelligerent asked 13/1 at 13:48
5
Solved
How to list all constraints (Primary key, Foreign Key, check, unique mutual exclusive, ..) of a table in PostgreSQL?
Endophyte asked 20/7, 2020 at 2:28
8
Solved
There are many guides out there that talk about auto-layout such as: http://www.raywenderlich.com/83129/beginning-auto-layout-tutorial-swift-part-1
Now constraints don't seem to be super complica...
Linzy asked 11/9, 2015 at 1:37
3
Solved
We're having an issue with a poorly coded SQL function(which works fine in live, but not in our test environment). This function is used to provide a default value in many tables, trying to ALTER t...
Dineric asked 22/1, 2010 at 14:8
10
Solved
How can I drop all user tables in oracle?
I have problem with constraints. When I disable all it is still no possible.
Mcardle asked 6/11, 2009 at 20:59
5
Solved
I have an SQLite database. I am trying to insert values (users_id, lessoninfo_id) in table bookmarks, only if both do not exist before in a row.
INSERT INTO bookmarks(users_id,lessoninfo_id)
VALU...
Ormuz asked 12/10, 2013 at 17:19
3
Solved
Let's say I have an N-side dice with non-uniform probabilities for each side and I throw it M times. Now instead of observing the individual outcomes, we only observe the sum.
I have to code the li...
Tubercle asked 15/9, 2023 at 23:36
12
I have an existing table called Person which already has existing 1000 rows of data. In this table I have 5 fields:
personId
Pname
PMid
Pdescription
Pamt
The table already has an existing compoun...
Phosphorus asked 3/8, 2012 at 11:17
7
Solved
Inside IB I have a viewController with a segmentedControl and 2 containerViews. In each containerView I have a tableView. From each tableView I push on a detailView. My auto layout is in IB.
Once ...
Rabaul asked 24/3, 2017 at 22:31
5
Solved
Does SQL Server allow constraint violations (i.e. deferred constraints) in a transaction as long as the transaction has not been committed yet?
I have a running, uncommitted transaction and while ...
Pasley asked 12/5, 2011 at 7:31
1 Next >
© 2022 - 2024 — McMap. All rights reserved.