/usr/bin/postmaster: PostmasterMain: initial environ dump: ----------------------------------------- PWD=/var/lib/pgsql LC_MESSAGES=en_US HOSTNAME=wsvan644.sierrasys.com LESSKEY=/etc/.less LESSOPEN=|/usr/bin/lesspipe.sh %s LANGUAGE=en_US:en KDEDIR=/usr LESS=-MM USER=postgres LS_COLORS=no=00:fi=00:di=01;34:ln=01;36:pi=40;33:so=01;35:bd=40;33;01:cd=40;33;01:or=01;05;37;41:mi=01;05;37;41:ex=01;32:*.cmd=01;32:*.exe=01;32:*.com=01;32:*.btm=01;32:*.bat=01;32:*.tar=01;31:*.tgz=01;31:*.tbz2=01;31:*.arc=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lha=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.gz=01;31:*.bz2=01;31:*.bz=01;31:*.tz=01;31:*.rpm=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.xbm=01;35:*.xpm=01;35:*.png=01;35:*.tif=01;35:*.tiff=01;35: LC_TIME=en_US MACHTYPE=i586-mandrake-linux-gnu LC_ALL=C MAIL=/var/spool/mail/postgres INPUTRC=/etc/inputrc CVS_RSH=/usr/bin/ssh LANG=en JAVA_HOME=/usr/local/jdk1.2.2 LC_NUMERIC=en_US LOGNAME=postgres SHLVL=2 LC_CTYPE=en_US SHELL=/bin/sh HOSTTYPE=i586 CVSROOT=lblain@exhibitx:/home/cvsroot/HBT OSTYPE=linux-gnu HISTSIZE=1000 TERM=xterm-color HOME=/var/lib/pgsql PGDATA=/var/lib/pgsql/data PATH=/bin:/usr/bin:/usr/local/bin:/usr/bin/X11:/usr/X11R6/bin:/usr/games SECURE_LEVEL=3 LC_MONETARY=en_US RPM_INSTALL_LANG=en LC_COLLATE=en_US _=/usr/bin/postmaster ----------------------------------------- invoking IpcMemoryCreate(size=9232384) FindExec: found "/usr/bin/postmaster" using argv[0] DEBUG: database system was shut down at 2001-05-23 15:02:01 DEBUG: CheckPoint record at (0, 566679936) DEBUG: Redo record at (0, 566679936); Undo record at (0, 0); Shutdown TRUE DEBUG: NextTransactionId: 25765; NextOid: 1347203 DEBUG: database system is in production state DEBUG: proc_exit(0) DEBUG: shmem_exit(0) DEBUG: exit(0) /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: CleanupProc: pid 5296 exited with status 0 /usr/bin/postmaster: ServerLoop: handling reading 5 /usr/bin/postmaster: ServerLoop: handling reading 5 /usr/bin/postmaster: ServerLoop: handling writing 5 /usr/bin/postmaster: BackendStartup: pid 5312 user postgres db hbtsynctest2 socket 5 /usr/bin/postmaster child[5312]: starting with (postgres -d3 -v131072 -p hbtsynctest2 ) FindExec: found "/usr/bin/postgres" using argv[0] DEBUG: connection: host=[local] user=postgres database=hbtsynctest2 DEBUG: InitPostgres DEBUG: StartTransactionCommand DEBUG: query: select getdatabaseencoding() DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable <> :jointree { FROMEXPR :fromlist <> :quals <>} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 19 :restypmod -1 :resname getdatabaseencoding :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { EXPR :typeOid 19 :opType func :oper { FUNC :funcid 1039 :functype 19 } :args <>}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: ProcessQuery DEBUG: CommitTransactionCommand DEBUG: StartTransactionCommand DEBUG: query: SELECT usesuper FROM pg_user WHERE usename = 'postgres' DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname pg_user :relid 17291 :subquery <> :alias <> :eref { ATTR :relname pg_user :attrs ( "usename" "usesysid" "usecreatedb" "usetrace" "usesuper" "usecatupd" "passwd" "valuntil" )} :inh true :inFromCl true :checkForRead true :checkForWrite false :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType op :oper { OPER :opno 93 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 19 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 19 :constlen 32 :constbyval false :constisnull false :constvalue 32 [ 112 111 115 116 103 114 101 115 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 ] })}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 16 :restypmod -1 :resname usesuper :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 5 :vartype 16 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: ProcessQuery DEBUG: CommitTransactionCommand DEBUG: StartTransactionCommand DEBUG: query: update cvg_rptd set rptg_session_id = NULL, cvg_rptd_sts_cd = 0, cvg_rptd_except_sts_cd = 0, cvg_rptd_except_desc = NULL, mdfy_dt = now() where emp_grp_id = 'DB1F2BCA-9272-D411-B712-0008C78CB1FE' and ben_plan_id = '51E79587-D136-D411-B5F4-0050DA5FD075' and grp_rate_id = 'F7E6C60D-1979-11D5-AE7D-001083FD6A84' and rate_step_id = 'CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3' and rptg_seq_id = '3743CB52-2D46-11D5-8A09-00508B0E83B6' and rptg_seq_id = '3743CB52-2D46-11D5-8A09-00508B0E83B6' and rptg_prd_end_dt = '2001-04-30'; DEBUG: parse tree: { QUERY :command 2 :utility <> :resultRelation 1 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749 :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rptg_prd_end_dt" "rptg_seq_id" "rptg_session_id" "cvg_rptd_sts_cd" "cvg_rptd_except_sts_cd" "cvg_rptd_except_desc" "mdfy_dt" )} :inh true :inFromCl false :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ -54 43 31 -37 114 -110 17 -44 -73 18 0 8 -57 -116 -79 -2 ] })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ -121 -107 -25 81 54 -47 17 -44 -75 -12 0 80 -38 95 -48 117 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ 13 -58 -26 -9 121 25 -43 17 -82 125 0 16 -125 -3 106 -124 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ -57 62 42 -49 -29 -32 -45 17 -87 -69 0 96 -80 104 35 -61 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ 82 -53 67 55 70 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ 82 -53 67 55 70 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5} { CONST :consttype 1082 :constlen 4 :constbyval true :constisnull false :constvalue 4 [ -27 1 0 0 ] })})}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 7 :restype 1288591 :restypmod -1 :resname rptg_session_id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull true :constvalue <>}} { TARGETENTRY :resdom { RESDOM :resno 8 :restype 21 :restypmod -1 :resname cvg_rptd_sts_cd :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue 2 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 9 :restype 21 :restypmod -1 :resname cvg_rptd_except_sts_cd :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue 2 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 10 :restype 1043 :restypmod 154 :resname cvg_rptd_except_desc :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { EXPR :typeOid 1043 :opType func :oper { FUNC :funcid 669 :functype 1043 } :args ({ CONST :consttype 1043 :constlen -1 :constbyval false :constisnull true :constvalue <>} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue 4 [ -102 0 0 0 ] })}} { TARGETENTRY :resdom { RESDOM :resno 11 :restype 1184 :restypmod -1 :resname mdfy_dt :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { EXPR :typeOid 1184 :opType func :oper { FUNC :funcid 1299 :functype 1184 } :args <>}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: ProcessQuery DEBUG: query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970 :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rate_fmt_flat_amt" "rate_fmt_salary_pct" "rate_fmt_dollars_per_ten_cvg" "rate_fmt_dollars_per_thou_cvg" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176 :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id" "rptg_seq_typ_id" "rptg_seq_start_dt" "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970 :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rate_fmt_flat_amt" "rate_fmt_salary_pct" "rate_fmt_dollars_per_ten_cvg" "rate_fmt_dollars_per_thou_cvg" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176 :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id" "rptg_seq_typ_id" "rptg_seq_start_dt" "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970 :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rate_fmt_flat_amt" "rate_fmt_salary_pct" "rate_fmt_dollars_per_ten_cvg" "rate_fmt_dollars_per_thou_cvg" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176 :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id" "rptg_seq_typ_id" "rptg_seq_start_dt" "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970 :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rate_fmt_flat_amt" "rate_fmt_salary_pct" "rate_fmt_dollars_per_ten_cvg" "rate_fmt_dollars_per_thou_cvg" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176 :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id" "rptg_seq_typ_id" "rptg_seq_start_dt" "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970 :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rate_fmt_flat_amt" "rate_fmt_salary_pct" "rate_fmt_dollars_per_ten_cvg" "rate_fmt_dollars_per_thou_cvg" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176 :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id" "rptg_seq_typ_id" "rptg_seq_start_dt" "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970 :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rate_fmt_flat_amt" "rate_fmt_salary_pct" "rate_fmt_dollars_per_ten_cvg" "rate_fmt_dollars_per_thou_cvg" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176 :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id" "rptg_seq_typ_id" "rptg_seq_start_dt" "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970 :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rate_fmt_flat_amt" "rate_fmt_salary_pct" "rate_fmt_dollars_per_ten_cvg" "rate_fmt_dollars_per_thou_cvg" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176 :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id" "rptg_seq_typ_id" "rptg_seq_start_dt" "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "grp_rate_step" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 FOR UPDATE OF "grp_rate_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname grp_rate_step :relid 1288970 :subquery <> :alias <> :eref { ATTR :relname grp_rate_step :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rate_fmt_flat_amt" "rate_fmt_salary_pct" "rate_fmt_dollars_per_ten_cvg" "rate_fmt_dollars_per_thou_cvg" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "rptg_seq" WHERE "rptg_seq_id" = $1 FOR UPDATE OF "rptg_seq" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname rptg_seq :relid 1289176 :subquery <> :alias <> :eref { ATTR :relname rptg_seq :attrs ( "rptg_seq_id" "rptg_seq_typ_id" "rptg_seq_start_dt" "rptg_seq_semimo_2nd_start_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: CommitTransactionCommand DEBUG: StartTransactionCommand DEBUG: query: update stepped_cvg_rptd set step_cvg_rptd_emp_count = 44, step_cvg_rptd_cvg_amt = NULL where emp_grp_id = 'DB1F2BCA-9272-D411-B712-0008C78CB1FE' and ben_plan_id = '51E79587-D136-D411-B5F4-0050DA5FD075' and grp_rate_id = 'F7E6C60D-1979-11D5-AE7D-001083FD6A84' and rate_step_id = 'CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3' and rptg_seq_id = '3743CB52-2D46-11D5-8A09-00508B0E83B6' and rptg_seq_id = '3743CB52-2D46-11D5-8A09-00508B0E83B6' and rptg_prd_end_dt = '2001-04-30' and cvgstep_id = '73B7259C-3A46-D511-8A0A-00508B0E83B6'; DEBUG: parse tree: { QUERY :command 2 :utility <> :resultRelation 1 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname stepped_cvg_rptd :relid 1289245 :subquery <> :alias <> :eref { ATTR :relname stepped_cvg_rptd :attrs ( "cvgstep_id" "emp_grp_id" "grp_rate_id" "rate_step_id" "ben_plan_id" "rptg_seq_id" "rptg_prd_end_dt" "step_cvg_rptd_emp_count" "step_cvg_rptd_cvg_amt" )} :inh true :inFromCl false :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ -54 43 31 -37 114 -110 17 -44 -73 18 0 8 -57 -116 -79 -2 ] })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ -121 -107 -25 81 54 -47 17 -44 -75 -12 0 80 -38 95 -48 117 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ 13 -58 -26 -9 121 25 -43 17 -82 125 0 16 -125 -3 106 -124 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ -57 62 42 -49 -29 -32 -45 17 -87 -69 0 96 -80 104 35 -61 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ 82 -53 67 55 70 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ 82 -53 67 55 70 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 7 :vartype 1082 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 7} { CONST :consttype 1082 :constlen 4 :constbyval true :constisnull false :constvalue 4 [ -27 1 0 0 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ -100 37 -73 115 70 58 17 -43 -118 10 0 80 -117 14 -125 -74 ] })})}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 8 :restype 23 :restypmod -1 :resname step_cvg_rptd_emp_count :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue 4 [ 44 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 9 :restype 23 :restypmod -1 :resname step_cvg_rptd_cvg_amt :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 23 :constlen 4 :constbyval true :constisnull true :constvalue <>}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: ProcessQuery DEBUG: query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729 :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id" "cvgstep_id" "cvgstep_hal_step_no" "cvgstep_hal_evnt_id" "cvgstep_desc" "cvgstep_per_emp_flat_amt" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749 :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rptg_prd_end_dt" "rptg_seq_id" "rptg_session_id" "cvg_rptd_sts_cd" "cvg_rptd_except_sts_cd" "cvg_rptd_except_desc" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \ :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729 :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id" "cvgstep_id" "cvgstep_hal_step_no" "cvgstep_hal_evnt_id" "cvgstep_desc" "cvgstep_per_emp_flat_amt" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749 :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rptg_prd_end_dt" "rptg_seq_id" "rptg_session_id" "cvg_rptd_sts_cd" "cvg_rptd_except_sts_cd" "cvg_rptd_except_desc" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \ :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729 :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id" "cvgstep_id" "cvgstep_hal_step_no" "cvgstep_hal_evnt_id" "cvgstep_desc" "cvgstep_per_emp_flat_amt" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749 :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rptg_prd_end_dt" "rptg_seq_id" "rptg_session_id" "cvg_rptd_sts_cd" "cvg_rptd_except_sts_cd" "cvg_rptd_except_desc" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \ :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729 :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id" "cvgstep_id" "cvgstep_hal_step_no" "cvgstep_hal_evnt_id" "cvgstep_desc" "cvgstep_per_emp_flat_amt" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749 :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rptg_prd_end_dt" "rptg_seq_id" "rptg_session_id" "cvg_rptd_sts_cd" "cvg_rptd_except_sts_cd" "cvg_rptd_except_desc" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \ :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729 :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id" "cvgstep_id" "cvgstep_hal_step_no" "cvgstep_hal_evnt_id" "cvgstep_desc" "cvgstep_per_emp_flat_amt" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749 :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rptg_prd_end_dt" "rptg_seq_id" "rptg_session_id" "cvg_rptd_sts_cd" "cvg_rptd_except_sts_cd" "cvg_rptd_except_desc" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \ :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729 :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id" "cvgstep_id" "cvgstep_hal_step_no" "cvgstep_hal_evnt_id" "cvgstep_desc" "cvgstep_per_emp_flat_amt" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749 :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rptg_prd_end_dt" "rptg_seq_id" "rptg_session_id" "cvg_rptd_sts_cd" "cvg_rptd_except_sts_cd" "cvg_rptd_except_desc" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \ :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729 :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id" "cvgstep_id" "cvgstep_hal_step_no" "cvgstep_hal_evnt_id" "cvgstep_desc" "cvgstep_per_emp_flat_amt" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749 :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rptg_prd_end_dt" "rptg_seq_id" "rptg_session_id" "cvg_rptd_sts_cd" "cvg_rptd_except_sts_cd" "cvg_rptd_except_desc" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \ :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "coverage_step" WHERE "ben_plan_id" = $1 AND "cvgstep_id" = $2 FOR UPDATE OF "coverage_step" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname coverage_step :relid 1288729 :subquery <> :alias <> :eref { ATTR :relname coverage_step :attrs ( "ben_plan_id" "cvgstep_id" "cvgstep_hal_step_no" "cvgstep_hal_evnt_id" "cvgstep_desc" "cvgstep_per_emp_flat_amt" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: query: SELECT oid FROM ONLY "cvg_rptd" WHERE "emp_grp_id" = $1 AND "ben_plan_id" = $2 AND "grp_rate_id" = $3 AND "rate_step_id" = $4 AND "rptg_seq_id" = $5 AND "rptg_prd_end_dt" = $6 FOR UPDATE OF "cvg_rptd" DEBUG: parse tree: { QUERY :command 1 :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749 :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rptg_prd_end_dt" "rptg_seq_id" "rptg_session_id" "cvg_rptd_sts_cd" "cvg_rptd_except_sts_cd" "cvg_rptd_except_desc" "mdfy_dt" )} :inh false :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \ :paramtype 1288591 })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { PARAM :paramkind 12 :paramid 3 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { PARAM :paramkind 12 :paramid 4 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { PARAM :paramkind 12 :paramid 5 :paramname \ :paramtype 1288591 })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5} { PARAM :paramkind 12 :paramid 6 :paramname \ :paramtype 1082 })})}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno -2}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: CommitTransactionCommand DEBUG: StartTransactionCommand DEBUG: query: update cvg_rptd set rptg_session_id = NULL, cvg_rptd_sts_cd = 0, cvg_rptd_except_sts_cd = 0, cvg_rptd_except_desc = NULL, mdfy_dt = now() where emp_grp_id = 'DB1F2BCA-9272-D411-B712-0008C78CB1FE' and ben_plan_id = 'A0E79587-D136-D411-B5F4-0050DA5FD075' and grp_rate_id = 'F7E6C60E-1979-11D5-AE7D-001083FD6A84' and rate_step_id = 'CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3' and rptg_seq_id = '3743CB52-2D46-11D5-8A09-00508B0E83B6' and rptg_seq_id = '3743CB52-2D46-11D5-8A09-00508B0E83B6' and rptg_prd_end_dt = '2001-04-30'; DEBUG: parse tree: { QUERY :command 2 :utility <> :resultRelation 1 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname cvg_rptd :relid 1288749 :subquery <> :alias <> :eref { ATTR :relname cvg_rptd :attrs ( "emp_grp_id" "ben_plan_id" "grp_rate_id" "rate_step_id" "rptg_prd_end_dt" "rptg_seq_id" "rptg_session_id" "cvg_rptd_sts_cd" "cvg_rptd_except_sts_cd" "cvg_rptd_except_desc" "mdfy_dt" )} :inh true :inFromCl false :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType and :oper <> :args ({ EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ -54 43 31 -37 114 -110 17 -44 -73 18 0 8 -57 -116 -79 -2 ] })} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 2} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ -121 -107 -25 -96 54 -47 17 -44 -75 -12 0 80 -38 95 -48 117 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 3} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ 14 -58 -26 -9 121 25 -43 17 -82 125 0 16 -125 -3 106 -124 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 4} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ -57 62 42 -49 -29 -32 -45 17 -87 -69 0 96 -80 104 35 -61 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ 82 -53 67 55 70 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1288596 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue 16 [ 82 -53 67 55 70 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16 :opType op :oper { OPER :opno 1093 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 5 :vartype 1082 :vartypmod -1 :varlevelsup 0 :varnoold 1 :varoattno 5} { CONST :consttype 1082 :constlen 4 :constbyval true :constisnull false :constvalue 4 [ -27 1 0 0 ] })})}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 7 :restype 1288591 :restypmod -1 :resname rptg_session_id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull true :constvalue <>}} { TARGETENTRY :resdom { RESDOM :resno 8 :restype 21 :restypmod -1 :resname cvg_rptd_sts_cd :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue 2 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 9 :restype 21 :restypmod -1 :resname cvg_rptd_except_sts_cd :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue 2 [ 0 0 0 0 ] }} { TARGETENTRY :resdom { RESDOM :resno 10 :restype 1043 :restypmod 154 :resname cvg_rptd_except_desc :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { EXPR :typeOid 1043 :opType func :oper { FUNC :funcid 669 :functype 1043 } :args ({ CONST :consttype 1043 :constlen -1 :constbyval false :constisnull true :constvalue <>} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue 4 [ -102 0 0 0 ] })}} { TARGETENTRY :resdom { RESDOM :resno 11 :restype 1184 :restypmod -1 :resname mdfy_dt :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { EXPR :typeOid 1184 :opType func :oper { FUNC :funcid 1299 :functype 1184 } :args <>}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()} DEBUG: ProcessQuery ERROR: Relation 2699531655 does not exist DEBUG: AbortCurrentTransaction DEBUG: proc_exit(0) DEBUG: shmem_exit(0) DEBUG: exit(0) /usr/bin/postmaster: reaping dead processes... /usr/bin/postmaster: CleanupProc: pid 5312 exited with status 0