Thread: SQL update statements are failing if submitted in sequence on same connection

SQL update statements are failing if submitted in sequence on same connection

From
Paul-Andre Panon
Date:
============================================================================

                       POSTGRESQL BUG REPORT TEMPLATE
============================================================================



Your name               :    Paul-Andre Panon
Your email address      : Paul-AndrePanon@sierrasystems.com
<mailto:Paul-AndrePanon@sierrasystems.com>


System Configuration
---------------------
 Architecture (example: Intel Pentium)         : Intel Pentium Pro

 Operating System (example: Linux 2.0.26 ELF)  :Mandrake Linux 7.2
Kernel 2.2.17-21mdksmp

 PostgreSQL version (example: PostgreSQL-7.1.1):   PostgreSQL-7.1,
7.1.1, 7.1.2

 Compiler used (example:  gcc 2.95.2)          :gcc version 2.95.3
19991030 (prerelease)

 I use rpms rebuilt from the source RPMs on the ftp site. For 7.1.2, I
modified the the 7.1.1 spec and support files to use the 7.1.2 tar
files, but I have the same problem with the stock 7.1 and 7.1.1 rpms.

Please enter a FULL description of your problem:
------------------------------------------------

SQL update statements are failing, possibly in the query planner. A copy
of the -d3 postgres log is attached. The error returned by psql when
submitting this query is
ERROR:  Relation 2699531655 does not exist
The third update statement fails if executed on the same connection as
the first two, but succeeds if it is executed on a different connection.

I am using a custom GUID/UUID data type extension similar to the MS SQL
Server uniqueidentifier data type. I used the varbits type in the
contrib directory as a template, as well as the FreeDCE library to
generate new UUIDs. I would be happy to contribute this code if anybody
is interested. With the new ODBC driver working towards ODBC 3.0 level
support, there may be more interest in having GUID support in
PostgreSQL. Although I can't rule out that the UUID data type may be at
fault, it does work correctly under 7.0.2 . The included uniqid.tar.gz
should be extracted into the contrib directory and compiled and
installed from there.

I have a database dump of a pared down version of the database, as well
as the statements that cause the problem.
If you run the three statements in sequence on the same connection you
get the crash, but if you run the third update by itself on a new
connection it works correctly. I have massaged the database dump to
include the uniqueidentifier type definitions assuming the shared
library  is placed in /usr/lib/pgsql/modules. If you place the shared
library in a different location, you will  need to change the reference
in the dump. Alternately, you can run the uniqid.sql generated and
installed by the make process before your restore the database dump; the
restore will then provide some error messages regarding the type
redefinitions but they can be ignored.

Unfortunately I can't include a copy of the uniqid source code or the
database dump because the bug tool rejects the message as too long
(>40KB). I am more than happy to make both available to anyone who would
like to look into this problem; just e-mail me.

----------------------------------------------------------------------


Perhaps this may be related to another bug that Tom Lane describes as:
"The direct cause of the problem is that EvalPlanQual isn't completely
initializing the estate that it sets up for re-evaluating the plan. In
particular it's not filling in es_result_relations and
es_num_result_relations, which need to be set up if the top plan node is
an Append."
since psql refers to a vary large relation oid in its error message?

/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
:ressortgroupref0 :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
00 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" )}
:inhtrue :inFromCl false :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({
RANGETBLREF1 }) :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
:opTypeand :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER
:opno1288596 :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
:varnoold1 :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
:varnoold1 :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
:varnoold1 :varoattno 4} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [
-5762 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
:varnoold1 :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
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ 82 -53 67
5570 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1093 :opid 0
:opresulttype16 } :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
:constisnulltrue :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
:constbyvaltrue :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
:consttype21 :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
:resjunkfalse } :expr { EXPR :typeOid 1043  :opType func :oper { FUNC :funcid 669 :functype 1043 } :args ({ CONST
:consttype1043 :constlen -1 :constbyval false :constisnull true :constvalue <>} { CONST :consttype 23 :constlen 4
:constbyvaltrue :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" =
$3AND "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
:varnoold1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1)
:targetList({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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 ({
RANGETBLREF1 }) :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
:paramid1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM
:resno1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno1 :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" =
$3AND "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
:varnoold1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1)
:targetList({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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 ({
RANGETBLREF1 }) :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
:paramid1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM
:resno1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno1 :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" =
$3AND "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
:varnoold1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1)
:targetList({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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 ({
RANGETBLREF1 }) :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
:paramid1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM
:resno1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno1 :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" =
$3AND "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
:varnoold1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1)
:targetList({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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 ({
RANGETBLREF1 }) :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
:paramid1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM
:resno1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno1 :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" =
$3AND "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
:varnoold1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1)
:targetList({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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 ({
RANGETBLREF1 }) :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
:paramid1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM
:resno1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno1 :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" =
$3AND "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
:varnoold1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1)
:targetList({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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 ({
RANGETBLREF1 }) :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
:paramid1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM
:resno1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno1 :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" =
$3AND "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
:varnoold1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1)
:targetList({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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 ({
RANGETBLREF1 }) :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
:paramid1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM
:resno1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno1 :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" =
$3AND "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
:varnoold1 :varoattno 1} { PARAM :paramkind 12 :paramid 1 :paramname \<unnamed> :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid3 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno4} { PARAM :paramkind 12 :paramid 4 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks ( 1)
:targetList({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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 ({
RANGETBLREF1 }) :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
:paramid1 :paramname \<unnamed> :paramtype 1288591 })}} :rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM
:resno1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR
:varno1 :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
:inFromClfalse :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
:typeOid16  :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
:typeOid16  :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
:typeOid16  :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
:typeOid16  :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
:typeOid16  :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
:typeOid16  :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
:typeOid16  :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
:typeOid16  :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
:constisnullfalse :constvalue  4 [ -27 1 0 0 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596 :opid 0
:opresulttype16 } :args ({ VAR :varno 1 :varattno 1 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno1} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ -100 37 -73
11570 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
:ressortgroupref0 :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
:checkForReadtrue :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR
:typeOid16  :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
:paramkind12 :paramid 1 :paramname \<unnamed> :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
:varnoold1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks (
1):targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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" )}
:inhfalse :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({
RANGETBLREF1 }) :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
:opTypeand :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 \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed> :paramtype 1082
})})}}:rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid
:reskey0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1
:varlevelsup0 :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
:checkForReadtrue :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR
:typeOid16  :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
:paramkind12 :paramid 1 :paramname \<unnamed> :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
:varnoold1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks (
1):targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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" )}
:inhfalse :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({
RANGETBLREF1 }) :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
:opTypeand :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 \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed> :paramtype 1082
})})}}:rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid
:reskey0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1
:varlevelsup0 :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
:checkForReadtrue :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR
:typeOid16  :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
:paramkind12 :paramid 1 :paramname \<unnamed> :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
:varnoold1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks (
1):targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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" )}
:inhfalse :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({
RANGETBLREF1 }) :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
:opTypeand :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 \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed> :paramtype 1082
})})}}:rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid
:reskey0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1
:varlevelsup0 :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
:checkForReadtrue :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR
:typeOid16  :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
:paramkind12 :paramid 1 :paramname \<unnamed> :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
:varnoold1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks (
1):targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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" )}
:inhfalse :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({
RANGETBLREF1 }) :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
:opTypeand :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 \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed> :paramtype 1082
})})}}:rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid
:reskey0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1
:varlevelsup0 :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
:checkForReadtrue :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR
:typeOid16  :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
:paramkind12 :paramid 1 :paramname \<unnamed> :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
:varnoold1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks (
1):targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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" )}
:inhfalse :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({
RANGETBLREF1 }) :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
:opTypeand :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 \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed> :paramtype 1082
})})}}:rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid
:reskey0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1
:varlevelsup0 :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
:checkForReadtrue :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR
:typeOid16  :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
:paramkind12 :paramid 1 :paramname \<unnamed> :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
:varnoold1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks (
1):targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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" )}
:inhfalse :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({
RANGETBLREF1 }) :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
:opTypeand :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 \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed> :paramtype 1082
})})}}:rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid
:reskey0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1
:varlevelsup0 :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
:checkForReadtrue :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR
:typeOid16  :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
:paramkind12 :paramid 1 :paramname \<unnamed> :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
:varnoold1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks (
1):targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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" )}
:inhfalse :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({
RANGETBLREF1 }) :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
:opTypeand :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 \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed> :paramtype 1082
})})}}:rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid
:reskey0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1
:varlevelsup0 :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
:checkForReadtrue :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({ RANGETBLREF 1 }) :quals { EXPR
:typeOid16  :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
:paramkind12 :paramid 1 :paramname \<unnamed> :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
:varnoold1 :varoattno 2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})}} :rowMarks (
1):targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid :reskey 0 :reskeyop 0
:ressortgroupref0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1  :varlevelsup 0
:varnoold1 :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" )}
:inhfalse :inFromCl true :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({
RANGETBLREF1 }) :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
:opTypeand :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 \<unnamed> :paramtype 1288591 })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno2} { PARAM :paramkind 12 :paramid 2 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed>
:paramtype1288591 })})} { 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
:paramid4 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1288596
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno6} { PARAM :paramkind 12 :paramid 5 :paramname \<unnamed> :paramtype 1288591 })})} { EXPR :typeOid 16
:opTypeop :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 \<unnamed> :paramtype 1082
})})}}:rowMarks ( 1) :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 26 :restypmod -1 :resname oid
:reskey0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno -2 :vartype 26 :vartypmod -1
:varlevelsup0 :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" )}
:inhtrue :inFromCl false :checkForRead true :checkForWrite true :checkAsUser 0}) :jointree { FROMEXPR :fromlist ({
RANGETBLREF1 }) :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
:opTypeand :oper <> :args ({ EXPR :typeOid 16  :opType and :oper <> :args ({ EXPR :typeOid 16  :opType op :oper { OPER
:opno1288596 :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
:varnoold1 :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
:varnoold1 :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
:varnoold1 :varoattno 4} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [
-5762 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
:varnoold1 :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
:opid0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 6 :vartype 1288591 :vartypmod -1  :varlevelsup 0 :varnoold 1
:varoattno6} { CONST :consttype 1288591 :constlen 16 :constbyval false :constisnull false :constvalue  16 [ 82 -53 67
5570 45 -43 17 -118 9 0 80 -117 14 -125 -74 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 1093 :opid 0
:opresulttype16 } :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
:constisnulltrue :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
:constbyvaltrue :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
:consttype21 :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
:resjunkfalse } :expr { EXPR :typeOid 1043  :opType func :oper { FUNC :funcid 669 :functype 1043 } :args ({ CONST
:consttype1043 :constlen -1 :constbyval false :constisnull true :constvalue <>} { CONST :consttype 23 :constlen 4
:constbyvaltrue :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

Attachment
Paul-Andre Panon <Paul-AndrePanon@SierraSystems.com> writes:
> SQL update statements are failing, possibly in the query planner. A copy
> of the -d3 postgres log is attached. The error returned by psql when
> submitting this query is
> ERROR:  Relation 2699531655 does not exist

Could you set a breakpoint at elog() and provide a stack backtrace
from the point of the error?

Also, if you didn't already, it'd be a good idea to reconfigure and
rebuild with --enable-cassert to aid in tracking the problem.

            regards, tom lane

PS: we don't need four copies of the next report ;-)