videoez.sql does not populate the customer table on AWS RDS #3
Description
I created a PostgreSQL instance on AWS RDS, connected to it, created the videoez db, set it as the default, and then ran videoezy.sql.
Afterwards, I ran select * from customer;. The output is empty.
Running INSERT INTO customer VALUES (1, 1, 'MARY', 'SMITH', 'MARY.SMITH@sakilacustomer.org', 5, true, '2006-02-14', '2006-02-15 09:57:20', 1); results in the error SQL Error [23503]: ERROR: insert or update on table "customer" violates foreign key constraint "customer_store_id_fkey" Detail: Key (store_id)=(1) is not present in table "store".
Do you have any idea what is going on?