DEBUG:  StartTransactionCommand
DEBUG:  query: select * from dbshphdr where courier_id='2' and pos_shipper='3' and pos_recipient='5' and manifest_no='25'
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname dbshphdr :relid 1740739  :subquery <> :alias <> :eref { ATTR :relname dbshphdr :attrs ( "courier_id"   "pos_shipper"   "pos_recipient"   "manifest_no"   "cap_user"   "cap_date"   "cap_time"   "upd_user"   "upd_date"   "upd_time"   "status"   "carrier"   "mawb"   "shipping_date"   "awbs"   "pckgs"   "real_weight"   "calc_weight"   "weight_units"   "containers"   "service_via" )} :inh true :inFromCl true :checkForRead true :checkForWrite false :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 96 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 2 0 0 0 ] })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 94 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 3 0 0 0 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 94 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 5 0 0 0 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 25 0 0 0 ] })})}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname courier_id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1}} { TARGETENTRY :resdom { RESDOM :resno 2 :restype 21 :restypmod -1 :resname pos_shipper :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 2 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2}} { TARGETENTRY :resdom { RESDOM :resno 3 :restype 21 :restypmod -1 :resname pos_recipient :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 3 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3}} { TARGETENTRY :resdom { RESDOM :resno 4 :restype 23 :restypmod -1 :resname manifest_no :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 4 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4}} { TARGETENTRY :resdom { RESDOM :resno 5 :restype 20 :restypmod -1 :resname cap_user :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 5 :vartype 20 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5}} { TARGETENTRY :resdom { RESDOM :resno 6 :restype 1082 :restypmod -1 :resname cap_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 6 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6}} { TARGETENTRY :resdom { RESDOM :resno 7 :restype 1083 :restypmod -1 :resname cap_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 7 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 7}} { TARGETENTRY :resdom { RESDOM :resno 8 :restype 20 :restypmod -1 :resname upd_user :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 8 :vartype 20 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 8}} { TARGETENTRY :resdom { RESDOM :resno 9 :restype 1082 :restypmod -1 :resname upd_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 9 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 9}} { TARGETENTRY :resdom { RESDOM :resno 10 :restype 1083 :restypmod -1 :resname upd_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 10 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 10}} { TARGETENTRY :resdom { RESDOM :resno 11 :restype 1042 :restypmod 5 :resname status :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 11 :vartype 1042 :vartypmod 5  :varlevelsup 0 :varnoold 1 :varoattno 11}} { TARGETENTRY :resdom { RESDOM :resno 12 :restype 1043 :restypmod 49 :resname carrier :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 12 :vartype 1043 :vartypmod 49  :varlevelsup 0 :varnoold 1 :varoattno 12}} { TARGETENTRY :resdom { RESDOM :resno 13 :restype 1043 :restypmod 24 :resname mawb :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 13 :vartype 1043 :vartypmod 24  :varlevelsup 0 :varnoold 1 :varoattno 13}} { TARGETENTRY :resdom { RESDOM :resno 14 :restype 1082 :restypmod -1 :resname shipping_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 14 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 14}} { TARGETENTRY :resdom { RESDOM :resno 15 :restype 21 :restypmod -1 :resname awbs :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 15 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 15}} { TARGETENTRY :resdom { RESDOM :resno 16 :restype 21 :restypmod -1 :resname pckgs :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 16 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 16}} { TARGETENTRY :resdom { RESDOM :resno 17 :restype 700 :restypmod -1 :resname real_weight :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 17 :vartype 700 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 17}} { TARGETENTRY :resdom { RESDOM :resno 18 :restype 700 :restypmod -1 :resname calc_weight :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 18 :vartype 700 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 18}} { TARGETENTRY :resdom { RESDOM :resno 19 :restype 1042 :restypmod 5 :resname weight_units :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 19 :vartype 1042 :vartypmod 5  :varlevelsup 0 :varnoold 1 :varoattno 19}} { TARGETENTRY :resdom { RESDOM :resno 20 :restype 21 :restypmod -1 :resname containers :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 20 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 20}} { TARGETENTRY :resdom { RESDOM :resno 21 :restype 1042 :restypmod 5 :resname service_via :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 21 :vartype 1042 :vartypmod 5  :varlevelsup 0 :varnoold 1 :varoattno 21}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
ERROR:  Cannot insert a duplicate key into unique index dbshpawb001
DEBUG:  AbortCurrentTransaction
DEBUG:  plan: { INDEXSCAN :startup_cost 0.00 :total_cost 2.02 :rows 1 :width 130 :qptargetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname courier_id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1}} { TARGETENTRY :resdom { RESDOM :resno 2 :restype 21 :restypmod -1 :resname pos_shipper :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 2 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2}} { TARGETENTRY :resdom { RESDOM :resno 3 :restype 21 :restypmod -1 :resname pos_recipient :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 3 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3}} { TARGETENTRY :resdom { RESDOM :resno 4 :restype 23 :restypmod -1 :resname manifest_no :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 4 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4}} { TARGETENTRY :resdom { RESDOM :resno 5 :restype 20 :restypmod -1 :resname cap_user :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 5 :vartype 20 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5}} { TARGETENTRY :resdom { RESDOM :resno 6 :restype 1082 :restypmod -1 :resname cap_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 6 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6}} { TARGETENTRY :resdom { RESDOM :resno 7 :restype 1083 :restypmod -1 :resname cap_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 7 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 7}} { TARGETENTRY :resdom { RESDOM :resno 8 :restype 20 :restypmod -1 :resname upd_user :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 8 :vartype 20 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 8}} { TARGETENTRY :resdom { RESDOM :resno 9 :restype 1082 :restypmod -1 :resname upd_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 9 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 9}} { TARGETENTRY :resdom { RESDOM :resno 10 :restype 1083 :restypmod -1 :resname upd_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 10 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 10}} { TARGETENTRY :resdom { RESDOM :resno 11 :restype 1042 :restypmod 5 :resname status :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 11 :vartype 1042 :vartypmod 5  :varlevelsup 0 :varnoold 1 :varoattno 11}} { TARGETENTRY :resdom { RESDOM :resno 12 :restype 1043 :restypmod 49 :resname carrier :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 12 :vartype 1043 :vartypmod 49  :varlevelsup 0 :varnoold 1 :varoattno 12}} { TARGETENTRY :resdom { RESDOM :resno 13 :restype 1043 :restypmod 24 :resname mawb :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 13 :vartype 1043 :vartypmod 24  :varlevelsup 0 :varnoold 1 :varoattno 13}} { TARGETENTRY :resdom { RESDOM :resno 14 :restype 1082 :restypmod -1 :resname shipping_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 14 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 14}} { TARGETENTRY :resdom { RESDOM :resno 15 :restype 21 :restypmod -1 :resname awbs :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 15 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 15}} { TARGETENTRY :resdom { RESDOM :resno 16 :restype 21 :restypmod -1 :resname pckgs :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 16 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 16}} { TARGETENTRY :resdom { RESDOM :resno 17 :restype 700 :restypmod -1 :resname real_weight :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 17 :vartype 700 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 17}} { TARGETENTRY :resdom { RESDOM :resno 18 :restype 700 :restypmod -1 :resname calc_weight :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 18 :vartype 700 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 18}} { TARGETENTRY :resdom { RESDOM :resno 19 :restype 1042 :restypmod 5 :resname weight_units :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 19 :vartype 1042 :vartypmod 5  :varlevelsup 0 :varnoold 1 :varoattno 19}} { TARGETENTRY :resdom { RESDOM :resno 20 :restype 21 :restypmod -1 :resname containers :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 20 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 20}} { TARGETENTRY :resdom { RESDOM :resno 21 :restype 1042 :restypmod 5 :resname service_via :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 21 :vartype 1042 :vartypmod 5  :varlevelsup 0 :varnoold 1 :varoattno 21}}) :qpqual <> :lefttree <> :righttree <> :extprm () :locprm () :initplan <> :nprm 0  :scanrelid 1 :indxid ( 1740771) :indxqual (({ EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 2 0 0 0 ] })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 94 :opid 63 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 3 0 0 0 ] })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 94 :opid 63 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 5 0 0 0 ] })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 25 0 0 0 ] })})) :indxqualorig (({ EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 2 0 0 0 ] })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 94 :opid 63 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 2 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2} { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 3 0 0 0 ] })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 94 :opid 63 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 3 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3} { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 5 0 0 0 ] })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 4 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 4} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 25 0 0 0 ] })})) :indxorderdir 1 }
DEBUG:  ProcessQuery
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: select * from dbbillhd where courier_id='2' and pos_shipper='3' and pos_recipient='5'
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','235','1','A','29','08:55:01PM','03/12/02','29','08:55:01PM','03/12/02','1','1','2','4','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  parse tree: { QUERY :command 1  :utility <> :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable ({ RTE :relname dbbillhd :relid 1738277  :subquery <> :alias <> :eref { ATTR :relname dbbillhd :attrs ( "courier_id"   "pos_sender"   "bill_no"   "status"   "cap_user"   "cap_date"   "cap_time"   "upd_user"   "upd_date"   "upd_time"   "packages"   "payments"   "pos_shipper"   "pos_recipient"   "pos_destination"   "sender"   "receiver"   "service_via"   "total_weight"   "description"   "special_instruct"   "coupon_id"   "disc_perc"   "serv_charge"   "discount"   "ctax"   "insurance"   "subtotal"   "declared_value"   "total_weight_unit"   "ho_date"   "ho_time"   "ca_date"   "ca_time"   "vo_date"   "vo_time"   "rt_date"   "rt_time"   "packages_lost"   "dc_date"   "dc_time"   "dp_date"   "dp_time"   "dl_date"   "dl_time"   "dn_date"   "dn_time"   "reason_code"   "dlv_name"   "dlv_relation"   "dlv_typedoc"   "dlv_doc"   "dlv_comments"   "en_date"   "en_time"   "ex_no_items"   "oth_charge" )} :inh true :inFromCl true :checkForRead true :checkForWrite false :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 op :oper { OPER :opno 96 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 2 0 0 0 ] })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 94 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 13 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 13} { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 3 0 0 0 ] })})} { EXPR :typeOid 16  :opType op :oper { OPER :opno 94 :opid 0 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 14 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 14} { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 5 0 0 0 ] })})}} :rowMarks () :targetList ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname courier_id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1}} { TARGETENTRY :resdom { RESDOM :resno 2 :restype 21 :restypmod -1 :resname pos_sender :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 2 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2}} { TARGETENTRY :resdom { RESDOM :resno 3 :restype 23 :restypmod -1 :resname bill_no :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 3 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3}} { TARGETENTRY :resdom { RESDOM :resno 4 :restype 1043 :restypmod 6 :resname status :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 4 :vartype 1043 :vartypmod 6  :varlevelsup 0 :varnoold 1 :varoattno 4}} { TARGETENTRY :resdom { RESDOM :resno 5 :restype 20 :restypmod -1 :resname cap_user :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 5 :vartype 20 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5}} { TARGETENTRY :resdom { RESDOM :resno 6 :restype 1082 :restypmod -1 :resname cap_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 6 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6}} { TARGETENTRY :resdom { RESDOM :resno 7 :restype 1083 :restypmod -1 :resname cap_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 7 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 7}} { TARGETENTRY :resdom { RESDOM :resno 8 :restype 20 :restypmod -1 :resname upd_user :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 8 :vartype 20 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 8}} { TARGETENTRY :resdom { RESDOM :resno 9 :restype 1082 :restypmod -1 :resname upd_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 9 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 9}} { TARGETENTRY :resdom { RESDOM :resno 10 :restype 1083 :restypmod -1 :resname upd_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 10 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 10}} { TARGETENTRY :resdom { RESDOM :resno 11 :restype 21 :restypmod -1 :resname packages :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 11 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 11}} { TARGETENTRY :resdom { RESDOM :resno 12 :restype 21 :restypmod -1 :resname payments :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 12 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 12}} { TARGETENTRY :resdom { RESDOM :resno 13 :restype 21 :restypmod -1 :resname pos_shipper :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 13 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 13}} { TARGETENTRY :resdom { RESDOM :resno 14 :restype 21 :restypmod -1 :resname pos_recipient :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 14 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 14}} { TARGETENTRY :resdom { RESDOM :resno 15 :restype 21 :restypmod -1 :resname pos_destination :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 15 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 15}} { TARGETENTRY :resdom { RESDOM :resno 16 :restype 23 :restypmod -1 :resname sender :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 16 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 16}} { TARGETENTRY :resdom { RESDOM :resno 17 :restype 23 :restypmod -1 :resname receiver :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 17 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 17}} { TARGETENTRY :resdom { RESDOM :resno 18 :restype 1042 :restypmod 5 :resname service_via :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 18 :vartype 1042 :vartypmod 5  :varlevelsup 0 :varnoold 1 :varoattno 18}} { TARGETENTRY :resdom { RESDOM :resno 19 :restype 700 :restypmod -1 :resname total_weight :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 19 :vartype 700 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 19}} { TARGETENTRY :resdom { RESDOM :resno 20 :restype 1043 :restypmod 1028 :resname description :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 20 :vartype 1043 :vartypmod 1028  :varlevelsup 0 :varnoold 1 :varoattno 20}} { TARGETENTRY :resdom { RESDOM :resno 21 :restype 1043 :restypmod 1028 :resname special_instruct :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 21 :vartype 1043 :vartypmod 1028  :varlevelsup 0 :varnoold 1 :varoattno 21}} { TARGETENTRY :resdom { RESDOM :resno 22 :restype 1043 :restypmod 12 :resname coupon_id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 22 :vartype 1043 :vartypmod 12  :varlevelsup 0 :varnoold 1 :varoattno 22}} { TARGETENTRY :resdom { RESDOM :resno 23 :restype 1700 :restypmod 262150 :resname disc_perc :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 23 :vartype 1700 :vartypmod 262150  :varlevelsup 0 :varnoold 1 :varoattno 23}} { TARGETENTRY :resdom { RESDOM :resno 24 :restype 1700 :restypmod 786438 :resname serv_charge :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 24 :vartype 1700 :vartypmod 786438  :varlevelsup 0 :varnoold 1 :varoattno 24}} { TARGETENTRY :resdom { RESDOM :resno 25 :restype 1700 :restypmod 655366 :resname discount :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 25 :vartype 1700 :vartypmod 655366  :varlevelsup 0 :varnoold 1 :varoattno 25}} { TARGETENTRY :resdom { RESDOM :resno 26 :restype 1700 :restypmod 655366 :resname ctax :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 26 :vartype 1700 :vartypmod 655366  :varlevelsup 0 :varnoold 1 :varoattno 26}} { TARGETENTRY :resdom { RESDOM :resno 27 :restype 1700 :restypmod 655366 :resname insurance :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 27 :vartype 1700 :vartypmod 655366  :varlevelsup 0 :varnoold 1 :varoattno 27}} { TARGETENTRY :resdom { RESDOM :resno 28 :restype 1700 :restypmod 655366 :resname subtotal :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 28 :vartype 1700 :vartypmod 655366  :varlevelsup 0 :varnoold 1 :varoattno 28}} { TARGETENTRY :resdom { RESDOM :resno 29 :restype 1700 :restypmod 917510 :resname declared_value :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 29 :vartype 1700 :vartypmod 917510  :varlevelsup 0 :varnoold 1 :varoattno 29}} { TARGETENTRY :resdom { RESDOM :resno 30 :restype 1042 :restypmod 5 :resname total_weight_unit :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 30 :vartype 1042 :vartypmod 5  :varlevelsup 0 :varnoold 1 :varoattno 30}} { TARGETENTRY :resdom { RESDOM :resno 31 :restype 1082 :restypmod -1 :resname ho_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 31 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 31}} { TARGETENTRY :resdom { RESDOM :resno 32 :restype 1083 :restypmod -1 :resname ho_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 32 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 32}} { TARGETENTRY :resdom { RESDOM :resno 33 :restype 1082 :restypmod -1 :resname ca_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 33 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 33}} { TARGETENTRY :resdom { RESDOM :resno 34 :restype 1083 :restypmod -1 :resname ca_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 34 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 34}} { TARGETENTRY :resdom { RESDOM :resno 35 :restype 1082 :restypmod -1 :resname vo_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 35 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 35}} { TARGETENTRY :resdom { RESDOM :resno 36 :restype 1083 :restypmod -1 :resname vo_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 36 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 36}} { TARGETENTRY :resdom { RESDOM :resno 37 :restype 1082 :restypmod -1 :resname rt_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 37 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 37}} { TARGETENTRY :resdom { RESDOM :resno 38 :restype 1083 :restypmod -1 :resname rt_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 38 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 38}} { TARGETENTRY :resdom { RESDOM :resno 39 :restype 21 :restypmod -1 :resname packages_lost :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 39 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 39}} { TARGETENTRY :resdom { RESDOM :resno 40 :restype 1082 :restypmod -1 :resname dc_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 40 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 40}} { TARGETENTRY :resdom { RESDOM :resno 41 :restype 1083 :restypmod -1 :resname dc_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 41 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 41}} { TARGETENTRY :resdom { RESDOM :resno 42 :restype 1082 :restypmod -1 :resname dp_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 42 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 42}} { TARGETENTRY :resdom { RESDOM :resno 43 :restype 1083 :restypmod -1 :resname dp_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 43 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 43}} { TARGETENTRY :resdom { RESDOM :resno 44 :restype 1082 :restypmod -1 :resname dl_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 44 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 44}} { TARGETENTRY :resdom { RESDOM :resno 45 :restype 1083 :restypmod -1 :resname dl_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 45 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 45}} { TARGETENTRY :resdom { RESDOM :resno 46 :restype 1082 :restypmod -1 :resname dn_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 46 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 46}} { TARGETENTRY :resdom { RESDOM :resno 47 :restype 1083 :restypmod -1 :resname dn_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 47 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 47}} { TARGETENTRY :resdom { RESDOM :resno 48 :restype 21 :restypmod -1 :resname reason_code :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 48 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 48}} { TARGETENTRY :resdom { RESDOM :resno 49 :restype 1043 :restypmod 29 :resname dlv_name :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 49 :vartype 1043 :vartypmod 29  :varlevelsup 0 :varnoold 1 :varoattno 49}} { TARGETENTRY :resdom { RESDOM :resno 50 :restype 1043 :restypmod 24 :resname dlv_relation :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 50 :vartype 1043 :vartypmod 24  :varlevelsup 0 :varnoold 1 :varoattno 50}} { TARGETENTRY :resdom { RESDOM :resno 51 :restype 1043 :restypmod 24 :resname dlv_typedoc :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 51 :vartype 1043 :vartypmod 24  :varlevelsup 0 :varnoold 1 :varoattno 51}} { TARGETENTRY :resdom { RESDOM :resno 52 :restype 1043 :restypmod 19 :resname dlv_doc :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 52 :vartype 1043 :vartypmod 19  :varlevelsup 0 :varnoold 1 :varoattno 52}} { TARGETENTRY :resdom { RESDOM :resno 53 :restype 1043 :restypmod 1028 :resname dlv_comments :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 53 :vartype 1043 :vartypmod 1028  :varlevelsup 0 :varnoold 1 :varoattno 53}} { TARGETENTRY :resdom { RESDOM :resno 54 :restype 1082 :restypmod -1 :resname en_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 54 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 54}} { TARGETENTRY :resdom { RESDOM :resno 55 :restype 1083 :restypmod -1 :resname en_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 55 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 55}} { TARGETENTRY :resdom { RESDOM :resno 56 :restype 21 :restypmod -1 :resname ex_no_items :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 56 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 56}} { TARGETENTRY :resdom { RESDOM :resno 57 :restype 1700 :restypmod 655366 :resname oth_charge :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 57 :vartype 1700 :vartypmod 655366  :varlevelsup 0 :varnoold 1 :varoattno 57}}) :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  plan: { INDEXSCAN :startup_cost 0.00 :total_cost 8.19 :rows 1 :width 414 :qptargetlist ({ TARGETENTRY :resdom { RESDOM :resno 1 :restype 23 :restypmod -1 :resname courier_id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1}} { TARGETENTRY :resdom { RESDOM :resno 2 :restype 21 :restypmod -1 :resname pos_sender :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 2 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 2}} { TARGETENTRY :resdom { RESDOM :resno 3 :restype 23 :restypmod -1 :resname bill_no :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 3 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 3}} { TARGETENTRY :resdom { RESDOM :resno 4 :restype 1043 :restypmod 6 :resname status :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 4 :vartype 1043 :vartypmod 6  :varlevelsup 0 :varnoold 1 :varoattno 4}} { TARGETENTRY :resdom { RESDOM :resno 5 :restype 20 :restypmod -1 :resname cap_user :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 5 :vartype 20 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 5}} { TARGETENTRY :resdom { RESDOM :resno 6 :restype 1082 :restypmod -1 :resname cap_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 6 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 6}} { TARGETENTRY :resdom { RESDOM :resno 7 :restype 1083 :restypmod -1 :resname cap_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 7 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 7}} { TARGETENTRY :resdom { RESDOM :resno 8 :restype 20 :restypmod -1 :resname upd_user :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 8 :vartype 20 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 8}} { TARGETENTRY :resdom { RESDOM :resno 9 :restype 1082 :restypmod -1 :resname upd_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 9 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 9}} { TARGETENTRY :resdom { RESDOM :resno 10 :restype 1083 :restypmod -1 :resname upd_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 10 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 10}} { TARGETENTRY :resdom { RESDOM :resno 11 :restype 21 :restypmod -1 :resname packages :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 11 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 11}} { TARGETENTRY :resdom { RESDOM :resno 12 :restype 21 :restypmod -1 :resname payments :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 12 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 12}} { TARGETENTRY :resdom { RESDOM :resno 13 :restype 21 :restypmod -1 :resname pos_shipper :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 13 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 13}} { TARGETENTRY :resdom { RESDOM :resno 14 :restype 21 :restypmod -1 :resname pos_recipient :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 14 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 14}} { TARGETENTRY :resdom { RESDOM :resno 15 :restype 21 :restypmod -1 :resname pos_destination :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 15 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 15}} { TARGETENTRY :resdom { RESDOM :resno 16 :restype 23 :restypmod -1 :resname sender :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 16 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 16}} { TARGETENTRY :resdom { RESDOM :resno 17 :restype 23 :restypmod -1 :resname receiver :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 17 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 17}} { TARGETENTRY :resdom { RESDOM :resno 18 :restype 1042 :restypmod 5 :resname service_via :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 18 :vartype 1042 :vartypmod 5  :varlevelsup 0 :varnoold 1 :varoattno 18}} { TARGETENTRY :resdom { RESDOM :resno 19 :restype 700 :restypmod -1 :resname total_weight :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 19 :vartype 700 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 19}} { TARGETENTRY :resdom { RESDOM :resno 20 :restype 1043 :restypmod 1028 :resname description :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 20 :vartype 1043 :vartypmod 1028  :varlevelsup 0 :varnoold 1 :varoattno 20}} { TARGETENTRY :resdom { RESDOM :resno 21 :restype 1043 :restypmod 1028 :resname special_instruct :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 21 :vartype 1043 :vartypmod 1028  :varlevelsup 0 :varnoold 1 :varoattno 21}} { TARGETENTRY :resdom { RESDOM :resno 22 :restype 1043 :restypmod 12 :resname coupon_id :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 22 :vartype 1043 :vartypmod 12  :varlevelsup 0 :varnoold 1 :varoattno 22}} { TARGETENTRY :resdom { RESDOM :resno 23 :restype 1700 :restypmod 262150 :resname disc_perc :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 23 :vartype 1700 :vartypmod 262150  :varlevelsup 0 :varnoold 1 :varoattno 23}} { TARGETENTRY :resdom { RESDOM :resno 24 :restype 1700 :restypmod 786438 :resname serv_charge :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 24 :vartype 1700 :vartypmod 786438  :varlevelsup 0 :varnoold 1 :varoattno 24}} { TARGETENTRY :resdom { RESDOM :resno 25 :restype 1700 :restypmod 655366 :resname discount :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 25 :vartype 1700 :vartypmod 655366  :varlevelsup 0 :varnoold 1 :varoattno 25}} { TARGETENTRY :resdom { RESDOM :resno 26 :restype 1700 :restypmod 655366 :resname ctax :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 26 :vartype 1700 :vartypmod 655366  :varlevelsup 0 :varnoold 1 :varoattno 26}} { TARGETENTRY :resdom { RESDOM :resno 27 :restype 1700 :restypmod 655366 :resname insurance :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 27 :vartype 1700 :vartypmod 655366  :varlevelsup 0 :varnoold 1 :varoattno 27}} { TARGETENTRY :resdom { RESDOM :resno 28 :restype 1700 :restypmod 655366 :resname subtotal :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 28 :vartype 1700 :vartypmod 655366  :varlevelsup 0 :varnoold 1 :varoattno 28}} { TARGETENTRY :resdom { RESDOM :resno 29 :restype 1700 :restypmod 917510 :resname declared_value :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 29 :vartype 1700 :vartypmod 917510  :varlevelsup 0 :varnoold 1 :varoattno 29}} { TARGETENTRY :resdom { RESDOM :resno 30 :restype 1042 :restypmod 5 :resname total_weight_unit :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 30 :vartype 1042 :vartypmod 5  :varlevelsup 0 :varnoold 1 :varoattno 30}} { TARGETENTRY :resdom { RESDOM :resno 31 :restype 1082 :restypmod -1 :resname ho_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 31 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 31}} { TARGETENTRY :resdom { RESDOM :resno 32 :restype 1083 :restypmod -1 :resname ho_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 32 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 32}} { TARGETENTRY :resdom { RESDOM :resno 33 :restype 1082 :restypmod -1 :resname ca_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 33 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 33}} { TARGETENTRY :resdom { RESDOM :resno 34 :restype 1083 :restypmod -1 :resname ca_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 34 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 34}} { TARGETENTRY :resdom { RESDOM :resno 35 :restype 1082 :restypmod -1 :resname vo_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 35 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 35}} { TARGETENTRY :resdom { RESDOM :resno 36 :restype 1083 :restypmod -1 :resname vo_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 36 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 36}} { TARGETENTRY :resdom { RESDOM :resno 37 :restype 1082 :restypmod -1 :resname rt_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 37 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 37}} { TARGETENTRY :resdom { RESDOM :resno 38 :restype 1083 :restypmod -1 :resname rt_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 38 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 38}} { TARGETENTRY :resdom { RESDOM :resno 39 :restype 21 :restypmod -1 :resname packages_lost :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 39 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 39}} { TARGETENTRY :resdom { RESDOM :resno 40 :restype 1082 :restypmod -1 :resname dc_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 40 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 40}} { TARGETENTRY :resdom { RESDOM :resno 41 :restype 1083 :restypmod -1 :resname dc_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 41 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 41}} { TARGETENTRY :resdom { RESDOM :resno 42 :restype 1082 :restypmod -1 :resname dp_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 42 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 42}} { TARGETENTRY :resdom { RESDOM :resno 43 :restype 1083 :restypmod -1 :resname dp_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 43 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 43}} { TARGETENTRY :resdom { RESDOM :resno 44 :restype 1082 :restypmod -1 :resname dl_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 44 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 44}} { TARGETENTRY :resdom { RESDOM :resno 45 :restype 1083 :restypmod -1 :resname dl_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 45 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 45}} { TARGETENTRY :resdom { RESDOM :resno 46 :restype 1082 :restypmod -1 :resname dn_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 46 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 46}} { TARGETENTRY :resdom { RESDOM :resno 47 :restype 1083 :restypmod -1 :resname dn_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 47 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 47}} { TARGETENTRY :resdom { RESDOM :resno 48 :restype 21 :restypmod -1 :resname reason_code :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 48 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 48}} { TARGETENTRY :resdom { RESDOM :resno 49 :restype 1043 :restypmod 29 :resname dlv_name :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 49 :vartype 1043 :vartypmod 29  :varlevelsup 0 :varnoold 1 :varoattno 49}} { TARGETENTRY :resdom { RESDOM :resno 50 :restype 1043 :restypmod 24 :resname dlv_relation :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 50 :vartype 1043 :vartypmod 24  :varlevelsup 0 :varnoold 1 :varoattno 50}} { TARGETENTRY :resdom { RESDOM :resno 51 :restype 1043 :restypmod 24 :resname dlv_typedoc :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 51 :vartype 1043 :vartypmod 24  :varlevelsup 0 :varnoold 1 :varoattno 51}} { TARGETENTRY :resdom { RESDOM :resno 52 :restype 1043 :restypmod 19 :resname dlv_doc :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 52 :vartype 1043 :vartypmod 19  :varlevelsup 0 :varnoold 1 :varoattno 52}} { TARGETENTRY :resdom { RESDOM :resno 53 :restype 1043 :restypmod 1028 :resname dlv_comments :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 53 :vartype 1043 :vartypmod 1028  :varlevelsup 0 :varnoold 1 :varoattno 53}} { TARGETENTRY :resdom { RESDOM :resno 54 :restype 1082 :restypmod -1 :resname en_date :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 54 :vartype 1082 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 54}} { TARGETENTRY :resdom { RESDOM :resno 55 :restype 1083 :restypmod -1 :resname en_time :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 55 :vartype 1083 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 55}} { TARGETENTRY :resdom { RESDOM :resno 56 :restype 21 :restypmod -1 :resname ex_no_items :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 56 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 56}} { TARGETENTRY :resdom { RESDOM :resno 57 :restype 1700 :restypmod 655366 :resname oth_charge :reskey 0 :reskeyop 0 :ressortgroupref 0 :resjunk false } :expr { VAR :varno 1 :varattno 57 :vartype 1700 :vartypmod 655366  :varlevelsup 0 :varnoold 1 :varoattno 57}}) :qpqual ({ EXPR :typeOid 16  :opType op :oper { OPER :opno 94 :opid 63 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 13 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 13} { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 3 0 0 0 ] })} { EXPR :typeOid 16  :opType op :oper { OPER :opno 94 :opid 63 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 14 :vartype 21 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 14} { CONST :consttype 21 :constlen 2 :constbyval true :constisnull false :constvalue  2 [ 5 0 0 0 ] })}) :lefttree <> :righttree <> :extprm () :locprm () :initplan <> :nprm 0  :scanrelid 1 :indxid ( 1738362) :indxqual (({ EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 2 0 0 0 ] })})) :indxqualorig (({ EXPR :typeOid 16  :opType op :oper { OPER :opno 96 :opid 65 :opresulttype 16 } :args ({ VAR :varno 1 :varattno 1 :vartype 23 :vartypmod -1  :varlevelsup 0 :varnoold 1 :varoattno 1} { CONST :consttype 23 :constlen 4 :constbyval true :constisnull false :constvalue  4 [ 2 0 0 0 ] })})) :indxorderdir 1 }
DEBUG:  ProcessQuery
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','236','1','A','29','08:55:02PM','03/12/02','29','08:55:02PM','03/12/02','1','1','3','20','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','237','1','A','29','08:55:02PM','03/12/02','29','08:55:02PM','03/12/02','1','1','4','90','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: select * from dbshpawb where courier_id='2' and pos_shipper='3' and pos_recipient='5' and manifest_no='25' and container_no='1' and pos_sender='3' and bill_no='235' and pckg_no='1'
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: select * from dbbillln where courier_id='2' and pos_sender='3' and bill_no='235' and pckg_no='1'
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: select * from dbshpawb where courier_id='2' and pos_shipper='3' and pos_recipient='5' and manifest_no='25' and container_no='1' order by package_no DESC
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','234','1','A','29','08:55:01PM','03/12/02','29','08:55:01PM','03/12/02','1','1','1','10','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','235','1','A','29','08:55:01PM','03/12/02','29','08:55:01PM','03/12/02','1','1','2','4','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','236','1','A','29','08:55:02PM','03/12/02','29','08:55:02PM','03/12/02','1','1','3','20','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','237','1','A','29','08:55:02PM','03/12/02','29','08:55:02PM','03/12/02','1','1','4','90','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: select * from dbshpawb where courier_id='2' and pos_shipper='3' and pos_recipient='5' and manifest_no='25' and container_no='1' and pos_sender='3' and bill_no='236' and pckg_no='1'
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: select * from dbbillln where courier_id='2' and pos_sender='3' and bill_no='236' and pckg_no='1'
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: select * from dbshpawb where courier_id='2' and pos_shipper='3' and pos_recipient='5' and manifest_no='25' and container_no='1' order by package_no DESC
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','234','1','A','29','08:55:01PM','03/12/02','29','08:55:01PM','03/12/02','1','1','1','10','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','235','1','A','29','08:55:01PM','03/12/02','29','08:55:01PM','03/12/02','1','1','2','4','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','236','1','A','29','08:55:02PM','03/12/02','29','08:55:02PM','03/12/02','1','1','3','20','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','237','1','A','29','08:55:02PM','03/12/02','29','08:55:02PM','03/12/02','1','1','4','90','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: select * from dbshpawb where courier_id='2' and pos_shipper='3' and pos_recipient='5' and manifest_no='25' and container_no='1' and pos_sender='3' and bill_no='237' and pckg_no='1'
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: select * from dbbillln where courier_id='2' and pos_sender='3' and bill_no='237' and pckg_no='1'
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: select * from dbshpawb where courier_id='2' and pos_shipper='3' and pos_recipient='5' and manifest_no='25' and container_no='1' order by package_no DESC
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','234','1','A','29','08:55:01PM','03/12/02','29','08:55:01PM','03/12/02','1','1','1','10','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','235','1','A','29','08:55:01PM','03/12/02','29','08:55:01PM','03/12/02','1','1','2','4','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','236','1','A','29','08:55:02PM','03/12/02','29','08:55:02PM','03/12/02','1','1','3','20','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: insert into dbshpawb ("courier_id","pos_shipper","pos_recipient","manifest_no","pos_sender","bill_no","pckg_no","status","cap_user","cap_time","cap_date","upd_user","upd_time","upd_date","pckgs","container_no","package_no","real_weight","weight_units") values('2','3','5','25','3','237','1','A','29','08:55:02PM','03/12/02','29','08:55:02PM','03/12/02','1','1','4','90','P');
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: update dbshpcon set "real_weight"='0' where courier_id='2' and pos_shipper='3' and pos_recipient='5' and manifest_no='25' and container_no='1';
NOTICE:  current transaction is aborted, queries ignored until end of transaction block
DEBUG:  CommitTransactionCommand
DEBUG:  StartTransactionCommand
DEBUG:  query: COMMIT transaction;
DEBUG:  parse tree: { QUERY :command 5  :utility ?  :resultRelation 0 :into <> :isPortal false :isBinary false :isTemp false :hasAggs false :hasSubLinks false :rtable <> :jointree <> :rowMarks () :targetList <> :groupClause <> :havingQual <> :distinctClause <> :sortClause <> :limitOffset <> :limitCount <> :setOperations <> :resultRelations ()}
DEBUG:  ProcessUtility: COMMIT transaction;
DEBUG:  CommitTransactionCommand