Final test: Web stack

Read the output

The copy's rows match the original, but the counters do not. What happens on the first order insert into shop_check?

$ psql -XAt -d shop -c 'SELECT last_value FROM orders_id_seq'
6
$ psql -XAt -d shop_check -c 'SELECT last_value FROM orders_id_seq'
5
$ psql -XAt -d shop_check -c 'SELECT max(id) FROM orders'
6

• A duplicate key … Key (id)=(6) already exists
• B The insert succeeds, since the counter catches up with max(id) by itself.
• C The order gets id 5 and overwrites the fifth.
• D The order gets id 7.