All Questions
3 questions
7
votes
1
answer
5k
views
Constraint in ON CONFLICT clause has no associated index
I have this simple setup using PostgreSQL 13, latest dockerized:
CREATE TABLE stop (
id INT UNIQUE,
name TEXT,
PRIMARY KEY(id)
);
CREATE TABLE line (
id INT UNIQUE,...
- 171
0
votes
1
answer
48
views
Constraint Information - PostgreSQL 9.2
I was trying to delete some data from the table dm.billables:
1 - Select the id - PASS
SELECT * INTO junk.clientid_10306 FROM dm.billables WHERE account_id = 10306;
2 - Delete the data from the ...
user83914
1
vote
1
answer
4k
views
Getting error while importing large data through csv
I am new Postgres. I am getting constraint violation errors while importing a
large CSV file.
I want to disable all of the database constraints temporarily - I do not know how to do this.
- 11