create or replace function inline_0 () returns integer as $$ DECLARE v_dummy integer; BEGIN select setting from pg_settings where name='server_version_num' and setting::int >= 90200 into v_dummy; IF found THEN drop view IF EXISTS download_reasons_sequence; ALTER SEQUENCE IF EXISTS download_reasons_seq RENAME TO download_reasons_sequence; -- remove unused sequence drop view IF EXISTS download_archive_type_seqence; DROP SEQUENCE IF EXISTS download_archive_type_seq; ELSE -- version earlier than 9.2, no "IF EXISTS" on ALTER SEQUENCE drop view download_reasons_sequence; ALTER SEQUENCE download_reasons_seq RENAME TO download_reasons_sequence; -- remove unused sequence drop view download_archive_type_seqence; DROP SEQUENCE download_archive_type_seq; END IF; return 1; END; $$ language 'plpgsql'; select inline_0(); drop function inline_0();