Skip to content

Instantly share code, notes, and snippets.

@chanmix51

chanmix51/restart_pgtap.sql

Created July 17, 2015 13:32
Show Gist options
  • Save chanmix51/0068b3a0fbd1a8e8e07f to your computer and use it in GitHub Desktop.
Save chanmix51/0068b3a0fbd1a8e8e07f to your computer and use it in GitHub Desktop.
Download ZIP
Restarting PgTap plan
Raw
restart_pgtap.sql
CREATE OR REPLACE FUNCTION public.restart_plan()
RETURNS void
LANGUAGE sql
AS $function$
truncate table pg_temp_2.__tcache__;
alter sequence pg_temp_2.__tresults___numb_seq restart ;
alter sequence pg_temp_2.__tcache___id_seq restart ;
$function$
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment