--drop agg functions
--drop the previous funcitons
DROP AGGREGATE IF EXISTS sum(vint2);
DROP AGGREGATE IF EXISTS sum(vint4);
DROP AGGREGATE IF EXISTS sum(vint8);
DROP AGGREGATE IF EXISTS sum(vfloat4);
DROP AGGREGATE IF EXISTS sum(vfloat8);

DROP AGGREGATE IF EXISTS avg(vint2);
DROP AGGREGATE IF EXISTS avg(vint4);
DROP AGGREGATE IF EXISTS avg(vint8);
DROP AGGREGATE IF EXISTS avg(vfloat4);
DROP AGGREGATE IF EXISTS avg(vfloat8);

DROP AGGREGATE IF EXISTS count(vint2);
DROP AGGREGATE IF EXISTS count(vint4);
DROP AGGREGATE IF EXISTS count(vint8);
DROP AGGREGATE IF EXISTS count(vfloat4);
DROP AGGREGATE IF EXISTS count(vfloat8);

DROP AGGREGATE IF EXISTS veccount(*);

DROP FUNCTION IF EXISTS vint2_accum(int8, vint2);
DROP FUNCTION IF EXISTS vint4_accum(int8, vint4);
DROP FUNCTION IF EXISTS vint8_accum(numeric, vint8);
DROP FUNCTION IF EXISTS vfloat4_accum(float4, vfloat4);
DROP FUNCTION IF EXISTS vfloat8_accum(float8, vfloat8);

DROP FUNCTION IF EXISTS vint2_avg_accum(bytea, vint2);
DROP FUNCTION IF EXISTS vint4_avg_accum(bytea, vint4);
DROP FUNCTION IF EXISTS vint8_avg_accum(bytea, vint8);
DROP FUNCTION IF EXISTS vfloat4_avg_accum(bytea, vfloat4);
DROP FUNCTION IF EXISTS vfloat8_avg_accum(bytea, vfloat8);

DROP FUNCTION IF EXISTS vint2_inc(int8, vint2);
DROP FUNCTION IF EXISTS vint4_inc(int8, vint4);
DROP FUNCTION IF EXISTS vint8_inc(int8, vint8);
DROP FUNCTION IF EXISTS vfloat4_inc(int8, vfloat4);
DROP FUNCTION IF EXISTS vfloat8_inc(int8, vfloat8);

DROP FUNCTION IF EXISTS vec_inc_any(int8);

drop type vint2 cascade;
drop type vint4 cascade;
drop type vint8 cascade;
drop type vfloat8 cascade;
drop type vfloat4 cascade;
drop type vbool cascade;
drop type vdateadt cascade;