Testing table integrity constraints:

run 02_test_hw7.sql

the output should be (ignore the initial junk; HOWEVER, the errors should be 
there - that is what we are testing for!!!):
DELETE 0
DELETE 2
DROP TABLE
NOTICE:  table "movies" does not exist, skipping
psql:/usr0/stu415_s13/etaralova415/loading.sql:1: NOTICE:  table "movies" does not exist, skipping
DROP TABLE
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "movies_pkey" for table "movies"
psql:/usr0/stu415_s13/etaralova415/loading.sql:4: NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "movies_pkey" for table "movies"
CREATE TABLE
COPY 20
CREATE INDEX
INSERT 0 1
 count 
-------
     1
(1 row)

ERROR:  duplicate key value violates unique constraint "users_pkey"
STATEMENT:  /*double registration*/
	    insert into users  (login_name,email,passwd) values ('anca', 'anca@cmu.edu', 'ancapass');
psql:tests/02_test_hw7.sql:12: ERROR:  duplicate key value violates unique constraint "users_pkey"
 count 
-------
     1
(1 row)

ERROR:  duplicate key value violates unique constraint "users_pkey"
STATEMENT:  /*duplicate login_name, different email, pass*/
	    insert into users (login_name,email,passwd)  values ('anca', 'aaaau', 'aaaa');
psql:tests/02_test_hw7.sql:15: ERROR:  duplicate key value violates unique constraint "users_pkey"
 count 
-------
     1
(1 row)

INSERT 0 1
 count 
-------
     2
(1 row)

INSERT 0 1
 count 
-------
     1
(1 row)

ERROR:  duplicate key value violates unique constraint "likes_pkey"
STATEMENT:  /*duplicate like*/
	    insert into likes (login_name,mtitle) values ('anca', 'Armageddon');
psql:tests/02_test_hw7.sql:28: ERROR:  duplicate key value violates unique constraint "likes_pkey"
 count 
-------
     1
(1 row)

INSERT 0 1
 count 
-------
     2
(1 row)

INSERT 0 1
 count 
-------
     3
(1 row)
