CREATE OR REPLACE FUNCTION bulk_insert_events(filename text)
  RETURNS integer AS
$BODY$ 
declare  
 copy_query text; 
begin 
	create temp table tmp_events (event_id int, place_no smallint, club_id int, last_query timestamp, event_data int) WITHOUT OIDS; 
	copy_query = 'copy tmp_events(event_id, place_no, club_id, last_query, event_data) from ''' || filename || ''';'; 
	begin 
	  execute copy_query; 
	exception 
	  when OTHERS then  
	  begin 
		drop table tmp_events;	 
		return  0 ; 
	  end; 
	end; 
	 
	insert into events(event_id, place_no, club_id, last_query, event_data) select event_id, place_no, club_id, last_query, event_data from tmp_events; 
	drop table tmp_events;	 
	return  1 ; 
end 
$BODY$
  LANGUAGE 'plpgsql' VOLATILE;