CREATE OR REPLACE FUNCTION dbo.reset_sequence(
tablename text,
columnname text,
sequence_name text)
RETURNS void AS
$BODY$
  DECLARE
  BEGIN
    IF( (SELECT MAX( columnname ) ) < (SELECT min_value FROM dbo.tablename)  )
     THEN
        --   EXECUTE 'SELECT setval( ' || sequence_name || ', (SELECT min_value FROM dbo.' || sequence_name ||')';
    ELSE
     --  EXECUTE 'SELECT setval( ' || sequence_name || ', ' || '(SELECT MAX("' || columnname || '") FROM dbo."' || tablename || '")' || '+1)';
    END IF;
    END;
$BODY$
LANGUAGE plpgsql VOLATILE
COST 100;
ALTER FUNCTION dbo.reset_sequence(text, text, text, text)
OWNER TO postgres;