create database aaa;
\c aaa
create schema envision01;
set search_path to envision01;
CREATE TABLE IF NOT EXISTS yx_channel (
  yx_id          bigint       NOT NULL,
  channel        tinyint      NOT NULL,
  raw_data       tinyint      DEFAULT NULL,
  q             bigint       DEFAULT NULL,
  ld_alias       varchar(64) DEFAULT NULL,
  order_no       smallint     DEFAULT '-1',
  gin           bigint       DEFAULT NULL,
  source_mode   tinyint      DEFAULT NULL,
  change_time   bigint       DEFAULT '0',
  PRIMARY KEY (yx_id, channel)
);
CREATE or replace FUNCTION "ti_yx_channel_trigger_function"() RETURNS "trigger"
    LANGUAGE "plpgsql" NOT SHIPPABLE
AS $$
DECLARE
    num1 INTEGER;
BEGIN
    IF NEW.ld_alias IS NOT NULL AND NEW.order_no >= 0 THEN
        SELECT COUNT(*) INTO num1 FROM yx_channel
          WHERE channel = NEW.channel AND ld_alias = NEW.ld_alias AND order_no = NEW.order_no ;
        IF num1 > 0 THEN
        END IF ;
    END IF ;
    RETURN NEW;
END$$;
CREATE TRIGGER "ti_yx_channel" BEFORE INSERT ON "yx_channel" FOR EACH ROW EXECUTE PROCEDURE "ti_yx_channel_trigger_function"();

\! @abs_bindir@/gs_dump -p @portstring@  -E=utf8 -n envision01 --lock-wait-timeout=300000 -c --force-clean aaa -f before_clean.sql >/dev/null;
create table t1(aaa int);
\! @abs_bindir@/gsql -daaa -p @portstring@ -f "before_clean.sql";

\! @abs_bindir@/gs_dump -p @portstring@ -s -E=utf8 -n envision01 --lock-wait-timeout=300000 --force-clean aaa -f before_clean.sql;
\c regression
drop database aaa;