gistfile1.txt

2018-05-28 19:21:34.896 PDT [19160] LOG:  listening on IPv6 address "::1", port 5432
2018-05-28 19:21:34.896 PDT [19160] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2018-05-28 19:21:34.929 PDT [19160] FATAL:  could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock": Permission denied
2018-05-28 19:21:34.929 PDT [19160] LOG:  database system is shut down
2018-05-29 09:36:20.036 PDT [24089] LOG:  listening on IPv6 address "::1", port 5432
2018-05-29 09:36:20.036 PDT [24089] LOG:  listening on IPv4 address "127.0.0.1", port 5432
2018-05-29 09:36:20.080 PDT [24089] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2018-05-29 09:36:20.226 PDT [24090] LOG:  database system was shut down at 2018-05-29 09:36:10 PDT
2018-05-29 09:36:20.281 PDT [24089] LOG:  database system is ready to accept connections
2018-05-29 09:42:05.945 PDT [24206] ERROR:  syntax error at or near "SELECT" at character 27
2018-05-29 09:42:05.945 PDT [24206] STATEMENT:  SELECT * from restaurants
	SELECT * from restaurants
	SELECT * FROM restaurants
	SELECT * from restaurants;
2018-05-29 09:43:44.538 PDT [24206] ERROR:  column "italian" does not exist at character 43
2018-05-29 09:43:44.538 PDT [24206] STATEMENT:  SELECT * from restaurants
	WHERE cuisine = "italian"
	;
2018-05-29 09:44:02.173 PDT [24206] ERROR:  column "Italian" does not exist at character 43
2018-05-29 09:44:02.173 PDT [24206] STATEMENT:  SELECT * from restaurants
	WHERE cuisine = "Italian"
	;
2018-05-29 09:44:47.453 PDT [24206] ERROR:  column "Italian" does not exist at character 43
2018-05-29 09:44:47.453 PDT [24206] STATEMENT:  SELECT * from restaurants
	WHERE cuisine = "Italian";
2018-05-29 09:47:38.074 PDT [24206] ERROR:  syntax error at or near "limit" at character 64
2018-05-29 09:47:38.074 PDT [24206] STATEMENT:  select id, name from restaurants
	where cuisine = 'Italian'
	and limit = 10;
2018-05-29 09:47:50.601 PDT [24206] ERROR:  syntax error at or near "=" at character 66
2018-05-29 09:47:50.601 PDT [24206] STATEMENT:  select id, name from restaurants
	where cuisine = 'Italian'
	limit = 10;
2018-05-29 09:48:02.241 PDT [24206] ERROR:  syntax error at or near "," at character 59
2018-05-29 09:48:02.241 PDT [24206] STATEMENT:  select id, name from restaurants
	where cuisine = 'Italian',
	limit = 10;
2018-05-29 09:50:29.305 PDT [24206] ERROR:  column "zipcode" does not exist at character 61
2018-05-29 09:50:29.305 PDT [24206] STATEMENT:  select count(*) from restaurants
	where cuisine = 'Thai'
	and zipcode = 11372;
2018-05-29 09:50:33.783 PDT [24206] ERROR:  column "zip" does not exist at character 61
2018-05-29 09:50:33.783 PDT [24206] STATEMENT:  select count(*) from restaurants
	where cuisine = 'Thai'
	and zip = 11372;
2018-05-29 11:02:20.507 PDT [24206] ERROR:  column "address_zip" does not exist at character 61
2018-05-29 11:02:20.507 PDT [24206] STATEMENT:  select count(*) from restaurants
	where cuisine = 'Thai'
	and address_zip = 11372;
2018-05-29 11:02:56.436 PDT [24206] ERROR:  column "address_zip" does not exist at character 61
2018-05-29 11:02:56.436 PDT [24206] STATEMENT:  select count(*) from restaurants
	where cuisine = 'Thai'
	and address_zip = 11372;
2018-05-29 11:10:22.493 PDT [24206] ERROR:  syntax error at or near "restaurants" at character 22
2018-05-29 11:10:22.493 PDT [24206] STATEMENT:  select id, name form restaurants
	where cuisine = 'Italian'
	and address_zipcode between 10012 and 10014
	order by name asc
	limit 5;
2018-05-29 11:10:44.318 PDT [24206] ERROR:  syntax error at or near "restaurants" at character 22
2018-05-29 11:10:44.318 PDT [24206] STATEMENT:  select id, name form restaurants
	where cuisine = 'Italian'
	and address_zipcode between 10012 and 10014
	order by name asc
	limit 5;
2018-05-29 11:11:11.523 PDT [24206] ERROR:  operator does not exist: text >= integer at character 80
2018-05-29 11:11:11.523 PDT [24206] HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
2018-05-29 11:11:11.523 PDT [24206] STATEMENT:  select id, name from restaurants
	where cuisine = 'Italian'
	and address_zipcode between 10012 and 10014
	order by name asc
	limit 5;
2018-05-29 11:12:20.295 PDT [24206] ERROR:  operator does not exist: text >= integer at character 80
2018-05-29 11:12:20.295 PDT [24206] HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
2018-05-29 11:12:20.295 PDT [24206] STATEMENT:  select id, name from restaurants
	where cuisine = 'Italian'
	and address_zipcode between 10012 and 10014
	order by name asc
	limit 5;
2018-05-29 11:12:55.680 PDT [24206] ERROR:  operator does not exist: text >= integer at character 57
2018-05-29 11:12:55.680 PDT [24206] HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
2018-05-29 11:12:55.680 PDT [24206] STATEMENT:  select id, name from restaurants
	where  address_zipcode between 10012 and 10014
	order by name asc
	limit 5;
2018-05-29 11:15:48.374 PDT [24206] ERROR:  syntax error at or near "address_zipcode" at character 61
2018-05-29 11:15:48.374 PDT [24206] STATEMENT:  select id, name from restaurants
	where cuisine = 'Italian'  address_zipcode between '10012' and '10014'
	select id, name from restaurants
	
	where cuisine = 'Italian'
	and address_zipcode between '10012' and '10014'
	order by name asc
	limit 5;
2018-05-29 11:16:21.317 PDT [24206] ERROR:  syntax error at or near "address_zipcode" at character 61
2018-05-29 11:16:21.317 PDT [24206] STATEMENT:  select id, name from restaurants
	where cuisine = 'Italian'  address_zipcode between '10012' and '10014'
	select id, name from restaurants
	where cuisine = 'Italian'
	and address_zipcode between '10012' and '10014'
	order by name asc
	limit 5;
2018-05-29 11:16:58.710 PDT [24206] ERROR:  syntax error at or near "address_zipcode" at character 61
2018-05-29 11:16:58.710 PDT [24206] STATEMENT:  select id, name from restaurants
	where cuisine = 'Italian'  address_zipcode between '10012' and '10014'
	select id, name from restaurants
	where cuisine = 'Italian'
	and address_zipcode between '10012' and '10014'
	order by name asc
	limit 5;
2018-05-29 11:17:30.616 PDT [24206] ERROR:  syntax error at or near "address_zipcode" at character 61
2018-05-29 11:17:30.616 PDT [24206] STATEMENT:  select id, name from restaurants
	where cuisine = 'Italian'  address_zipcode between '10012' and '10014'
	select id, name from restaurants
	where cuisine = 'Italian'
	and address_zipcode between '10012' and '10014';
2018-05-29 11:17:37.045 PDT [24206] ERROR:  syntax error at or near "address_zipcode" at character 61
2018-05-29 11:17:37.045 PDT [24206] STATEMENT:  select id, name from restaurants
	where cuisine = 'Italian'  address_zipcode between '10012' and '10014'
	select id, name from restaurants
	where cuisine = 'Italian';
2018-05-29 11:30:28.482 PDT [27374] ERROR:  syntax error at or near "insert" at character 191
2018-05-29 11:30:28.482 PDT [27374] STATEMENT:  insert into restaurants
	(name, borough, cuisine, address_building_number,
	address_street, address_zipcode) values
	('Byte Cheese2', 'Brooklyn', 'cheese', '1243', 'Atlanctic Avenue', '11231')
	insert into restaurants
	(name, borough, cuisine, address_building_number,
	address_street, address_zipcode) values
	('taco hut', 'Brooklyn', 'tacos', '4233', 'shunm Avenue', '11221')
	insert into restaurants
	(name, borough, cuisine, address_building_number,
	address_street, address_zipcode) values
	('tree soup', 'Queens', 'soup', '4774', 'tree street', '11323') returning id, name;
2018-05-29 11:31:10.438 PDT [27374] ERROR:  syntax error at or near "insert" at character 191
2018-05-29 11:31:10.438 PDT [27374] STATEMENT:  insert into restaurants
	(name, borough, cuisine, address_building_number,
	address_street, address_zipcode) values
	('Byte Cheese2', 'Brooklyn', 'cheese', '1243', 'Atlanctic Avenue', '11231')
	insert into restaurants
	(name, borough, cuisine, address_building_number,
	address_street, address_zipcode) values
	('taco hut', 'Brooklyn', 'tacos', '4233', 'shunm Avenue', '11221')
	insert into restaurants
	(name, borough, cuisine, address_building_number,
	address_street, address_zipcode) values
	('tree soup', 'Queens', 'soup', '4774', 'tree street', '11323') returning id, name;
2018-05-29 11:31:44.002 PDT [27374] ERROR:  syntax error at or near "and" at character 191
2018-05-29 11:31:44.002 PDT [27374] STATEMENT:  insert into restaurants
	(name, borough, cuisine, address_building_number,
	address_street, address_zipcode) values
	('Byte Cheese2', 'Brooklyn', 'cheese', '1243', 'Atlanctic Avenue', '11231')
	and insert into restaurants
	(name, borough, cuisine, address_building_number,
	address_street, address_zipcode) values
	('taco hut', 'Brooklyn', 'tacos', '4233', 'shunm Avenue', '11221')
	insert into restaurants
	(name, borough, cuisine, address_building_number,
	address_street, address_zipcode) values
	('tree soup', 'Queens', 'soup', '4774', 'tree street', '11323') returning id, name;
2018-05-29 11:34:04.229 PDT [27501] FATAL:  role "postgres" does not exist
2018-05-29 11:41:19.173 PDT [27374] ERROR:  update or delete on table "restaurants" violates foreign key constraint "grades_restaurant_id_fkey" on table "grades"
2018-05-29 11:41:19.173 PDT [27374] DETAIL:  Key (id)=(22) is still referenced from table "grades".
2018-05-29 11:41:19.173 PDT [27374] STATEMENT:  delete from restaurants where id = 22;
2018-05-29 11:46:49.467 PDT [27374] ERROR:  syntax error at or near "in" at character 10
2018-05-29 11:46:49.467 PDT [27374] STATEMENT:  select * in inspectors;
2018-05-29 11:48:15.443 PDT [27374] ERROR:  relation "grade" does not exist
2018-05-29 11:48:15.443 PDT [27374] STATEMENT:  alter table grade
	add column notes text;