Cannot insert rows for table having values and a foreign key

Question

I am a beginner in SQL and I am currently stuck on something. So I tried to insert 3 rows in admin and it worked fine. Now I want to insert 3 rows of data in data_center however when running it I got an error "column "name" of relation "data_center" does not exist" can someone explain what's happening? Thanks in advance

CREATE TABLE admin
(
    username VARCHAR unique,
    PRIMARY KEY (username)
);

CREATE TABLE data_center
(
    name VARCHAR,
    username VARCHAR,
    capacity INT NOT NULL
        CHECK (capacity > 0 AND capacity < 20000),
    PRIMARY KEY (name),
    FOREIGN KEY (username) REFERENCES admin(username)
);

INSERT INTO admin (username)
VALUES ('Alan'), ('Bob'), ('Lea');
    
INSERT INTO data_center (name, username,capacity)
VALUES ('Alan Johnson'   'Alan'   '4000'),
       ('Bob Lane'   'Bob'   '2000'),
       ('Lea Larsson'   'Lea'   '6000');

I matched the FK values with the PK ones but I still have the same error — 1010l0gic
– 1010l0gic, Commented Feb 27, 2022 at 19:35
Please test your code after editing it but before posting it. Your posted code does not fail with the error you indicate. — jjanes
– jjanes, Commented Feb 28, 2022 at 2:10

जलजनक · Accepted Answer · 2022-02-27 19:41:14Z

2

Values in record need to be comma separated.
Capacity is integer value

    INSERT INTO data_center (name, username, capacity)
    VALUES  ('Alan Johnson', 'Alan', 4000),
            ('Lea Lane', 'Lea', 2000),
            ('Edward Larsson', 'Edward', 6000);

Edward is not in admin table. Edward became Lea between edits.

edited Feb 27, 2022 at 19:41

answered Feb 27, 2022 at 19:34

जलजनक

3,0812 gold badges26 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Cannot insert rows for table having values and a foreign key

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related