Miguel Oliveira migueltaoliveira

## deadlock.sql
#Check deadlocks
SELECT relation::regclass, * FROM pg_locks WHERE NOT granted;

## createsequence.sql
CREATE SEQUENCE agentserial
START WITH 1
INCREMENT BY 1
NO MINVALUE
NO MAXVALUE
CACHE 1;

CREATE SEQUENCE roleserial
START WITH 1
INCREMENT BY 1
	#Check deadlocks
	SELECT relation::regclass, * FROM pg_locks WHERE NOT granted;
	CREATE SEQUENCE agentserial
	START WITH 1
	INCREMENT BY 1
	NO MINVALUE
	NO MAXVALUE
	CACHE 1;

	CREATE SEQUENCE roleserial
	START WITH 1
	INCREMENT BY 1