Witam,
CREATE TABLE equipment (
id serial PRIMARY KEY,
name VARCHAR (50) NOT NULL,
equip_id VARCHAR (16) NOT NULL,
removed TIMESTAMP NULL DEFAULT NULL
);
CREATE UNIQUE INDEX CONCURRENTLY equipment_equip_id
ON equipment (equip_id);
Moze mi ktos dokladnie wytlumaczyc co robi kod ponize? Po co mi Alter talble, jak index juz dziala bez tego? Druga sprawa co to jest te CONCURRENTLY
?
ALTER TABLE equipment
ADD CONSTRAINT unique_equip_id
UNIQUE USING INDEX equipment_equip_id;
I insert:
INSERT INTO equipment(name,equip_id) VALUES('Test1', 1) ON CONFLICT (name,equip_id) WHERE removed IS NULL DO
UPDATE SET name = EXCLUDED.name RETURNING id;