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


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 included 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.

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


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? It
looks like the query is crashing after the query parsing is completed.
-d4 doesn't seem to provide additional useful information regarding the
Query Processing and where it is breaking. If there are any additional
flags at compile or run time that I can set to provide more useful
information, please let me know.

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

Paul-Andre Panon


--
-- Selected TOC Entries:
--
\connect - postgres

LOAD '/usr/lib/pgsql/modules/uniqid.so';

CREATE FUNCTION uniqidin(opaque)
   RETURNS opaque
   AS '/usr/lib/pgsql/modules/uniqid.so'
   LANGUAGE 'c';

CREATE FUNCTION uniqidout(opaque)
   RETURNS opaque
   AS '/usr/lib/pgsql/modules/uniqid.so'
   LANGUAGE 'c';

CREATE TYPE uniqueidentifier (
   internallength = 16,
   externallength = -1,
   input = uniqidin,
   output = uniqidout
);

CREATE FUNCTION uniqideq(uniqueidentifier,uniqueidentifier) RETURNS bool
  AS '/usr/lib/pgsql/modules/uniqid.so'
  LANGUAGE 'C';

CREATE OPERATOR = (
  leftarg = uniqueidentifier,
  rightarg = uniqueidentifier,
  procedure = uniqideq,
  negator = <>,
  commutator = =,
  restrict = eqsel,
  join = eqjoinsel,
  sort1 = <,
  sort2 = <,
  hashes
);

CREATE FUNCTION uniqidne(uniqueidentifier,uniqueidentifier) RETURNS bool
  AS '/usr/lib/pgsql/modules/uniqid.so'
  LANGUAGE 'C';

CREATE OPERATOR <> (
  leftarg = uniqueidentifier,
  rightarg = uniqueidentifier,
  procedure = uniqidne,
  negator = =,
  commutator = <>,
  restrict = neqsel,
  join = neqjoinsel
);

CREATE FUNCTION uniqidlt(uniqueidentifier,uniqueidentifier) RETURNS bool
  AS '/usr/lib/pgsql/modules/uniqid.so'
  LANGUAGE 'C';

CREATE OPERATOR < (
  leftarg = uniqueidentifier,
  rightarg = uniqueidentifier,
  procedure = uniqidlt,
  negator = >=,
  commutator = >,
  restrict = scalarltsel,
  join = scalarltjoinsel
);

CREATE FUNCTION uniqidle(uniqueidentifier,uniqueidentifier) RETURNS bool
  AS '/usr/lib/pgsql/modules/uniqid.so'
  LANGUAGE 'C';

CREATE OPERATOR <= (
  leftarg = uniqueidentifier,
  rightarg = uniqueidentifier,
  procedure = uniqidle,
  negator = <,
  commutator = <=,
  restrict = scalarltsel,
  join = scalarltjoinsel
);

CREATE FUNCTION uniqidgt(uniqueidentifier,uniqueidentifier) RETURNS bool
  AS '/usr/lib/pgsql/modules/uniqid.so'
  LANGUAGE 'C';

CREATE OPERATOR > (
  leftarg = uniqueidentifier,
  rightarg = uniqueidentifier,
  procedure = uniqidgt,
  negator = <=,
  commutator = <,
  restrict = scalargtsel,
  join = scalargtjoinsel
);

CREATE FUNCTION uniqidge(uniqueidentifier,uniqueidentifier) RETURNS bool
  as '/usr/lib/pgsql/modules/uniqid.so'
  language 'C';

CREATE OPERATOR >= (
  leftarg = uniqueidentifier,
  rightarg = uniqueidentifier,
  procedure = uniqidge,
  negator = <,
  commutator = <=,
  restrict = scalargtsel,
  join = scalargtjoinsel
);

CREATE FUNCTION uniqidcmp(uniqueidentifier,uniqueidentifier) RETURNS integer
  AS '/usr/lib/pgsql/modules/uniqid.so'
  LANGUAGE 'C';

CREATE OPERATOR <=> (
  leftarg = uniqueidentifier,
  rightarg = uniqueidentifier,
  procedure = uniqidcmp
);
/* set up the indexing infrastructure for btrees - first the operator class */

insert into pg_opclass (opcname, opcdeftype)
select 'uniqueidentifier_ops', oid from pg_type where typname = 'uniqueidentifier';

/* next the operators for particular strategies */
create table btree_opstrategy_tmp (
    oprname name,
    oprstrategy int2);

copy btree_opstrategy_tmp from stdin;
<    1
<=    2
=    3
>=    4
>    5
\.

insert into pg_amop (amopid, amopclaid, amopopr, amopstrategy)
select am.oid, opcl.oid, op.oid, bos.oprstrategy
from pg_am am, pg_opclass opcl,
    btree_opstrategy_tmp bos,
    pg_operator op, pg_type typ
where am.amname = 'btree' and
    opcl.opcname = 'uniqueidentifier_ops' and
    op.oprleft = typ.oid and op.oprright = typ.oid and
    typ.typname = 'uniqueidentifier' and
    op.oprname = bos.oprname;

drop table btree_opstrategy_tmp;

/* finally, the support routine */

insert into pg_amproc (amid, amopclaid, amproc, amprocnum)
select a.oid, b.oid, c.oid, 1
from pg_am a, pg_opclass b, pg_proc c
where a.amname = 'btree' and
    b.opcname = 'uniqueidentifier_ops' and
    c.proname = 'uniqidcmp';

CREATE FUNCTION newid() RETURNS uniqueidentifier
  AS '/usr/lib/pgsql/modules/uniqid.so'
  LANGUAGE 'C';

--
-- TOC Entry ID 7 (OID 1621509)
--
-- Name: ben_plan Type: TABLE Owner: postgres
--

CREATE TABLE "ben_plan" (
    "ben_plan_id" uniqueidentifier NOT NULL,
    "ben_plan_no" smallint NOT NULL,
    "ben_plan_halid" integer NOT NULL,
    Constraint "ben_plan_pkey" Primary Key ("ben_plan_id")
);

--
-- TOC Entry ID 8 (OID 1621524)
--
-- Name: coverage_step Type: TABLE Owner: postgres
--

CREATE TABLE "coverage_step" (
    "ben_plan_id" uniqueidentifier NOT NULL,
    "cvgstep_id" uniqueidentifier NOT NULL,
    "cvgstep_desc" character varying(150) NOT NULL,
    "cvgstep_per_emp_flat_amt" integer,
    "mdfy_dt" timestamp with time zone NOT NULL,
    Constraint "coverage_step_pkey" Primary Key ("ben_plan_id", "cvgstep_id")
);

--
-- TOC Entry ID 9 (OID 1621541)
--
-- Name: cvg_rptd Type: TABLE Owner: postgres
--

CREATE TABLE "cvg_rptd" (
    "emp_grp_id" uniqueidentifier NOT NULL,
    "ben_plan_id" uniqueidentifier NOT NULL,
    "grp_rate_id" uniqueidentifier NOT NULL,
    "rate_step_id" uniqueidentifier NOT NULL,
    "rptg_prd_end_dt" date NOT NULL,
    "rptg_seq_id" uniqueidentifier NOT NULL,
    "rptg_session_id" uniqueidentifier,
    "cvg_rptd_sts_cd" smallint,
    "cvg_rptd_except_sts_cd" smallint,
    "cvg_rptd_except_desc" character varying(150),
    "mdfy_dt" timestamp with time zone NOT NULL,
    Constraint "cvg_rptd_pkey" Primary Key ("emp_grp_id", "ben_plan_id", "grp_rate_id", "rate_step_id", "rptg_seq_id",
"rptg_prd_end_dt")
);

--
-- TOC Entry ID 10 (OID 1621564)
--
-- Name: emp_grp Type: TABLE Owner: postgres
--

CREATE TABLE "emp_grp" (
    "emp_grp_id" uniqueidentifier NOT NULL,
    "emp_grp_halid" integer NOT NULL,
    "emp_grp_nm" character varying(100) NOT NULL,
    "emp_grp_typ" smallint NOT NULL,
    "mdfy_dt" timestamp with time zone NOT NULL,
    Constraint "emp_grp_pkey" Primary Key ("emp_grp_id")
);

--
-- TOC Entry ID 11 (OID 1621581)
--
-- Name: grp_rate Type: TABLE Owner: postgres
--

CREATE TABLE "grp_rate" (
    "emp_grp_id" uniqueidentifier NOT NULL,
    "ben_plan_id" uniqueidentifier NOT NULL,
    "grp_rate_id" uniqueidentifier NOT NULL,
    "grp_rate_eff_dt" date NOT NULL,
    "grp_rate_term_dt" date,
    Constraint "grp_rate_pkey" Primary Key ("emp_grp_id", "ben_plan_id", "grp_rate_id")
);

--
-- TOC Entry ID 12 (OID 1621598)
--
-- Name: grp_rate_step Type: TABLE Owner: postgres
--

CREATE TABLE "grp_rate_step" (
    "emp_grp_id" uniqueidentifier NOT NULL,
    "ben_plan_id" uniqueidentifier NOT NULL,
    "grp_rate_id" uniqueidentifier NOT NULL,
    "rate_step_id" uniqueidentifier NOT NULL,
    "rate_fmt_flat_amt" numeric(9,2),
    "rate_fmt_salary_pct" numeric(6,4),
    "rate_fmt_dollars_per_ten_cvg" numeric(7,4),
    "rate_fmt_dollars_per_thou_cvg" numeric(7,4),
    "mdfy_dt" timestamp with time zone NOT NULL,
    Constraint "grp_rate_step_pkey" Primary Key ("emp_grp_id", "ben_plan_id", "grp_rate_id", "rate_step_id")
);

--
-- TOC Entry ID 13 (OID 1621619)
--
-- Name: mo_cvg_rptd Type: TABLE Owner: postgres
--

CREATE TABLE "mo_cvg_rptd" (
    "emp_grp_id" uniqueidentifier NOT NULL,
    "ben_plan_id" uniqueidentifier NOT NULL,
    "grp_rate_id" uniqueidentifier NOT NULL,
    "rate_step_id" uniqueidentifier NOT NULL,
    "rptg_prd_end_dt" date NOT NULL,
    "rptg_seq_id" uniqueidentifier NOT NULL,
    "mo_cvg_rptd_emp_count" integer,
    Constraint "mo_cvg_rptd_pkey" Primary Key ("emp_grp_id", "ben_plan_id", "grp_rate_id", "rate_step_id",
"rptg_seq_id","rptg_prd_end_dt") 
);

--
-- TOC Entry ID 14 (OID 1621638)
--
-- Name: pay_prd_cvg_rptd Type: TABLE Owner: postgres
--

CREATE TABLE "pay_prd_cvg_rptd" (
    "emp_grp_id" uniqueidentifier NOT NULL,
    "ben_plan_id" uniqueidentifier NOT NULL,
    "grp_rate_id" uniqueidentifier NOT NULL,
    "rate_step_id" uniqueidentifier NOT NULL,
    "rptg_seq_id" uniqueidentifier NOT NULL,
    "rptg_prd_end_dt" date NOT NULL,
    "pay_prd_rptd_contribtry_earn" numeric(9,2),
    "pay_prd_rptd_emp_count" integer,
    Constraint "pay_prd_cvg_rptd_pkey" Primary Key ("emp_grp_id", "ben_plan_id", "grp_rate_id", "rate_step_id",
"rptg_seq_id","rptg_prd_end_dt") 
);

--
-- TOC Entry ID 15 (OID 1621658)
--
-- Name: rate_step Type: TABLE Owner: postgres
--

CREATE TABLE "rate_step" (
    "rate_step_id" uniqueidentifier NOT NULL,
    "rate_step_nm" character varying(100),
    "rate_step_desc" character varying(150),
    Constraint "rate_step_pkey" Primary Key ("rate_step_id")
);

--
-- TOC Entry ID 16 (OID 1621673)
--
-- Name: rptg_seq Type: TABLE Owner: postgres
--

CREATE TABLE "rptg_seq" (
    "rptg_seq_id" uniqueidentifier NOT NULL,
    "rptg_seq_typ_id" uniqueidentifier NOT NULL,
    "rptg_seq_start_dt" date,
    "rptg_seq_semimo_2nd_start_dt" date,
    Constraint "rptg_seq_pkey" Primary Key ("rptg_seq_id")
);

--
-- TOC Entry ID 17 (OID 1621689)
--
-- Name: rptg_seq_typ Type: TABLE Owner: postgres
--

CREATE TABLE "rptg_seq_typ" (
    "rptg_seq_typ_id" uniqueidentifier NOT NULL,
    "rptg_seq_typ_nm" character varying(15) NOT NULL,
    "rptg_seq_typ_desc" character varying(150),
    "is_pay_prd_seq_ind" boolean NOT NULL,
    Constraint "rptg_seq_typ_pkey" Primary Key ("rptg_seq_typ_id")
);

--
-- TOC Entry ID 18 (OID 1621705)
--
-- Name: stepped_cvg_rptd Type: TABLE Owner: postgres
--

CREATE TABLE "stepped_cvg_rptd" (
    "cvgstep_id" uniqueidentifier NOT NULL,
    "emp_grp_id" uniqueidentifier NOT NULL,
    "grp_rate_id" uniqueidentifier NOT NULL,
    "rate_step_id" uniqueidentifier NOT NULL,
    "rptg_seq_id" uniqueidentifier NOT NULL,
    "ben_plan_id" uniqueidentifier NOT NULL,
    "rptg_prd_end_dt" date NOT NULL,
    "step_cvg_rptd_emp_count" integer NOT NULL,
    "step_cvg_rptd_cvg_amt" integer,
    Constraint "stepped_cvg_rptd_pkey" Primary Key ("emp_grp_id", "ben_plan_id", "grp_rate_id", "rate_step_id",
"rptg_seq_id","rptg_prd_end_dt", "cvgstep_id") 
);

--
-- TOC Entry ID 5 (OID 1621726)
--
-- Name: rptg_session_rptg_session_c_seq Type: SEQUENCE Owner: postgres
--

CREATE SEQUENCE "rptg_session_rptg_session_c_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1  cache 1 ;

--
-- TOC Entry ID 19 (OID 1621745)
--
-- Name: rptg_session Type: TABLE Owner: postgres
--

CREATE TABLE "rptg_session" (
    "rptg_session_id" uniqueidentifier NOT NULL,
    "rptg_session_confirm_no" integer DEFAULT nextval('"rptg_session_rptg_session_c_seq"'::text) NOT NULL,
    "rptg_mdfy_dt" timestamp with time zone NOT NULL,
    Constraint "rptg_session_pkey" Primary Key ("rptg_session_id")
);

--
-- Data for TOC Entry ID 42 (OID 1621509)
--
-- Name: ben_plan Type: TABLE DATA Owner: postgres
--


INSERT INTO "ben_plan" VALUES ('51E79587-D136-D411-B5F4-0050DA5FD075',1,3);
INSERT INTO "ben_plan" VALUES ('60E89587-D136-D411-B5F4-0050DA5FD075',3,10);
INSERT INTO "ben_plan" VALUES ('72E99587-D136-D411-B5F4-0050DA5FD075',4,12);
INSERT INTO "ben_plan" VALUES ('A0E79587-D136-D411-B5F4-0050DA5FD075',5,6);
--
-- Data for TOC Entry ID 43 (OID 1621524)
--
-- Name: coverage_step Type: TABLE DATA Owner: postgres
--


INSERT INTO "coverage_step" VALUES
('51E79587-D136-D411-B5F4-0050DA5FD075','73B7259C-3A46-D511-8A0A-00508B0E83B6','Ages:All; ',50000,'2000-05-31
16:22:18+00');
INSERT INTO "coverage_step" VALUES
('60E89587-D136-D411-B5F4-0050DA5FD075','75B7259C-3A46-D511-8A0A-00508B0E83B6','Ages:All: 2 X Basic Annual Earnings;
Min.$65000; Max. n/a',NULL,'2000-05-31 17:00:56+00'); 
INSERT INTO "coverage_step" VALUES
('72E99587-D136-D411-B5F4-0050DA5FD075','77B7259C-3A46-D511-8A0A-00508B0E83B6','Ages:Up to 64, inclusive;
',10000,'2000-05-3120:53:01+00'); 
INSERT INTO "coverage_step" VALUES
('72E99587-D136-D411-B5F4-0050DA5FD075','78B7259C-3A46-D511-8A0A-00508B0E83B6','Ages:65 to 69, inclusive;
',5000,'2000-05-3120:53:01+00'); 
INSERT INTO "coverage_step" VALUES
('A0E79587-D136-D411-B5F4-0050DA5FD075','74B7259C-3A46-D511-8A0A-00508B0E83B6','Ages:All; ',50000,'2000-05-31
16:28:43+00');
--
-- Data for TOC Entry ID 44 (OID 1621541)
--
-- Name: cvg_rptd Type: TABLE DATA Owner: postgres
--


INSERT INTO "cvg_rptd" VALUES
('DB1F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','2001-04-30','3743CB52-2D46-11D5-8A09-00508B0E83B6',NULL,0,0,NULL,'2001-05-23
14:15:45+00');
INSERT INTO "cvg_rptd" VALUES
('DB1F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','2000-12-15','53014F33-197B-11D5-AE7D-001083FD6A84','3743CC60-2D46-11D5-8A09-00508B0E83B6',1,0,'no
exception','2001-05-0207:01:00+00'); 
INSERT INTO "cvg_rptd" VALUES
('DB1F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','2001-01-31','3743CB52-2D46-11D5-8A09-00508B0E83B6','407C3A98-4A22-11D5-895B-00C04FA05897',1,0,NULL,'2001-05-16
17:38:26+00');
INSERT INTO "cvg_rptd" VALUES
('DB1F2BCA-9272-D411-B712-0008C78CB1FE','A0E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60E-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','2001-01-31','3743CB52-2D46-11D5-8A09-00508B0E83B6','407C3A98-4A22-11D5-895B-00C04FA05897',1,0,NULL,'2001-05-16
17:38:26+00');
INSERT INTO "cvg_rptd" VALUES
('DB1F2BCA-9272-D411-B712-0008C78CB1FE','A0E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60E-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','2001-04-30','3743CB52-2D46-11D5-8A09-00508B0E83B6',NULL,0,0,NULL,'2001-05-23
13:52:31+00');
INSERT INTO "cvg_rptd" VALUES
('DB1F2BCA-9272-D411-B712-0008C78CB1FE','A0E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60E-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','2000-12-15','53014F33-197B-11D5-AE7D-001083FD6A84','3743CC60-2D46-11D5-8A09-00508B0E83B6',1,0,'no
exception','2001-05-0207:01:00+00'); 
--
-- Data for TOC Entry ID 45 (OID 1621564)
--
-- Name: emp_grp Type: TABLE DATA Owner: postgres
--


INSERT INTO "emp_grp" VALUES ('D51F2BCA-9272-D411-B712-0008C78CB1FE',1133,'1133 Union 1 at Organization A (Agrmt A
4/2000)',1,'2000-08-1523:53:45+00'); 
INSERT INTO "emp_grp" VALUES ('DB1F2BCA-9272-D411-B712-0008C78CB1FE',1134,'1134 Union 2 at Organization A (Agrmt A
4/2000)',1,'2000-08-1523:54:36+00'); 
INSERT INTO "emp_grp" VALUES ('E71F2BCA-9272-D411-B712-0008C78CB1FE',1135,'1135 Union 1 at Organization B (Agrmt A
4/2000)',1,'2000-08-1523:55:44+00'); 
--
-- Data for TOC Entry ID 46 (OID 1621581)
--
-- Name: grp_rate Type: TABLE DATA Owner: postgres
--


INSERT INTO "grp_rate" VALUES
('D51F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C608-1979-11D5-AE7D-001083FD6A84','2000-04-01',NULL);
INSERT INTO "grp_rate" VALUES
('DB1F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60D-1979-11D5-AE7D-001083FD6A84','2000-04-01',NULL);
INSERT INTO "grp_rate" VALUES
('E71F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C612-1979-11D5-AE7D-001083FD6A84','2000-04-01',NULL);
INSERT INTO "grp_rate" VALUES
('DB1F2BCA-9272-D411-B712-0008C78CB1FE','A0E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60E-1979-11D5-AE7D-001083FD6A84','2000-04-01',NULL);
--
-- Data for TOC Entry ID 47 (OID 1621598)
--
-- Name: grp_rate_step Type: TABLE DATA Owner: postgres
--


INSERT INTO "grp_rate_step" VALUES
('D51F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C608-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3',NULL,NULL,NULL,'0.1025','2000-08-23
21:19:32+00');
INSERT INTO "grp_rate_step" VALUES
('DB1F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3',NULL,NULL,NULL,'0.1355','2000-08-23
21:20:16+00');
INSERT INTO "grp_rate_step" VALUES
('E71F2BCA-9272-D411-B712-0008C78CB1FE','51E79587-D136-D411-B5F4-0050DA5FD075','F7E6C612-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3',NULL,NULL,NULL,'0.1875','2000-08-23
21:19:55+00');
INSERT INTO "grp_rate_step" VALUES
('DB1F2BCA-9272-D411-B712-0008C78CB1FE','A0E79587-D136-D411-B5F4-0050DA5FD075','F7E6C60E-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3',NULL,NULL,NULL,'0.0321','2001-02-28
22:31:00+00');
--
-- Data for TOC Entry ID 48 (OID 1621619)
--
-- Name: mo_cvg_rptd Type: TABLE DATA Owner: postgres
--


--
-- Data for TOC Entry ID 49 (OID 1621638)
--
-- Name: pay_prd_cvg_rptd Type: TABLE DATA Owner: postgres
--


--
-- Data for TOC Entry ID 50 (OID 1621658)
--
-- Name: rate_step Type: TABLE DATA Owner: postgres
--


INSERT INTO "rate_step" VALUES ('CF2A393A-E0E3-11D3-A9BB-0060B06823C3','Single',NULL);
INSERT INTO "rate_step" VALUES ('CF2A393B-E0E3-11D3-A9BB-0060B06823C3','One dependant',NULL);
INSERT INTO "rate_step" VALUES ('CF2A393C-E0E3-11D3-A9BB-0060B06823C3','More than one dependant',NULL);
INSERT INTO "rate_step" VALUES ('CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','Not Applicable',NULL);
--
-- Data for TOC Entry ID 51 (OID 1621673)
--
-- Name: rptg_seq Type: TABLE DATA Owner: postgres
--


INSERT INTO "rptg_seq" VALUES
('53014F2B-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-01',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F2C-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-02',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F2D-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-03',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F2E-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-04',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F2F-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-05',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F22-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-06',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F23-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-07',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F24-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-08',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F25-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-09',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F26-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-10',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F27-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-11',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F28-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-12',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F29-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-13',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F2A-197B-11D5-AE7D-001083FD6A84','53014F20-197B-11D5-AE7D-001083FD6A84','2000-01-14',NULL);
INSERT INTO "rptg_seq" VALUES
('53014F30-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-01','2000-01-13');
INSERT INTO "rptg_seq" VALUES
('53014F31-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-01','2000-01-14');
INSERT INTO "rptg_seq" VALUES
('53014F32-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-01','2000-01-15');
INSERT INTO "rptg_seq" VALUES
('53014F33-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-01','2000-01-16');
INSERT INTO "rptg_seq" VALUES
('53014F34-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-01','2000-01-17');
INSERT INTO "rptg_seq" VALUES
('53014F35-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-02','2000-01-14');
INSERT INTO "rptg_seq" VALUES
('53014F36-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-02','2000-01-15');
INSERT INTO "rptg_seq" VALUES
('53014F37-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-02','2000-01-16');
INSERT INTO "rptg_seq" VALUES
('53014F38-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-02','2000-01-17');
INSERT INTO "rptg_seq" VALUES
('53014F39-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-02','2000-01-18');
INSERT INTO "rptg_seq" VALUES
('53014F3A-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-03','2000-01-15');
INSERT INTO "rptg_seq" VALUES
('53014F3B-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-03','2000-01-16');
INSERT INTO "rptg_seq" VALUES
('53014F3C-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-03','2000-01-17');
INSERT INTO "rptg_seq" VALUES
('53014F3D-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-03','2000-01-18');
INSERT INTO "rptg_seq" VALUES
('53014F3E-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-03','2000-01-19');
INSERT INTO "rptg_seq" VALUES
('53014F3F-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-04','2000-01-16');
INSERT INTO "rptg_seq" VALUES
('53014F40-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-04','2000-01-17');
INSERT INTO "rptg_seq" VALUES
('53014F41-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-04','2000-01-18');
INSERT INTO "rptg_seq" VALUES
('53014F42-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-04','2000-01-19');
INSERT INTO "rptg_seq" VALUES
('53014F43-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-04','2000-01-20');
INSERT INTO "rptg_seq" VALUES
('53014F44-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-05','2000-01-17');
INSERT INTO "rptg_seq" VALUES
('53014F45-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-05','2000-01-18');
INSERT INTO "rptg_seq" VALUES
('53014F46-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-05','2000-01-19');
INSERT INTO "rptg_seq" VALUES
('53014F47-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-05','2000-01-20');
INSERT INTO "rptg_seq" VALUES
('53014F48-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-05','2000-01-21');
INSERT INTO "rptg_seq" VALUES
('53014F49-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-06','2000-01-18');
INSERT INTO "rptg_seq" VALUES
('53014F4A-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-06','2000-01-19');
INSERT INTO "rptg_seq" VALUES
('53014F4B-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-06','2000-01-20');
INSERT INTO "rptg_seq" VALUES
('53014F4C-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-06','2000-01-21');
INSERT INTO "rptg_seq" VALUES
('53014F4D-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-06','2000-01-22');
INSERT INTO "rptg_seq" VALUES
('53014F4E-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-07','2000-01-19');
INSERT INTO "rptg_seq" VALUES
('53014F4F-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-07','2000-01-20');
INSERT INTO "rptg_seq" VALUES
('53014F50-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-07','2000-01-21');
INSERT INTO "rptg_seq" VALUES
('53014F51-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-07','2000-01-22');
INSERT INTO "rptg_seq" VALUES
('53014F52-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-07','2000-01-23');
INSERT INTO "rptg_seq" VALUES
('53014F53-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-08','2000-01-20');
INSERT INTO "rptg_seq" VALUES
('53014F54-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-08','2000-01-21');
INSERT INTO "rptg_seq" VALUES
('53014F55-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-08','2000-01-22');
INSERT INTO "rptg_seq" VALUES
('53014F56-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-08','2000-01-23');
INSERT INTO "rptg_seq" VALUES
('53014F57-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-08','2000-01-24');
INSERT INTO "rptg_seq" VALUES
('53014F58-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-09','2000-01-21');
INSERT INTO "rptg_seq" VALUES
('53014F59-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-09','2000-01-22');
INSERT INTO "rptg_seq" VALUES
('53014F5A-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-09','2000-01-23');
INSERT INTO "rptg_seq" VALUES
('53014F5B-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-09','2000-01-24');
INSERT INTO "rptg_seq" VALUES
('53014F5C-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-09','2000-01-25');
INSERT INTO "rptg_seq" VALUES
('53014F5D-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-10','2000-01-22');
INSERT INTO "rptg_seq" VALUES
('53014F5E-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-10','2000-01-23');
INSERT INTO "rptg_seq" VALUES
('53014F5F-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-10','2000-01-24');
INSERT INTO "rptg_seq" VALUES
('53014F60-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-10','2000-01-25');
INSERT INTO "rptg_seq" VALUES
('53014F61-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-10','2000-01-26');
INSERT INTO "rptg_seq" VALUES
('53014F62-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-11','2000-01-23');
INSERT INTO "rptg_seq" VALUES
('53014F63-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-11','2000-01-24');
INSERT INTO "rptg_seq" VALUES
('53014F64-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-11','2000-01-25');
INSERT INTO "rptg_seq" VALUES
('53014F65-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-11','2000-01-26');
INSERT INTO "rptg_seq" VALUES
('53014F66-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-11','2000-01-27');
INSERT INTO "rptg_seq" VALUES
('53014F67-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-12','2000-01-24');
INSERT INTO "rptg_seq" VALUES
('53014F68-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-12','2000-01-25');
INSERT INTO "rptg_seq" VALUES
('53014F69-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-12','2000-01-26');
INSERT INTO "rptg_seq" VALUES
('53014F6A-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-12','2000-01-27');
INSERT INTO "rptg_seq" VALUES
('53014F6B-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-12','2000-01-28');
INSERT INTO "rptg_seq" VALUES
('53014F6C-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-13','2000-01-25');
INSERT INTO "rptg_seq" VALUES
('53014F6D-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-13','2000-01-26');
INSERT INTO "rptg_seq" VALUES
('53014F6E-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-13','2000-01-27');
INSERT INTO "rptg_seq" VALUES
('53014F6F-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-13','2000-01-28');
INSERT INTO "rptg_seq" VALUES
('53014F70-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-14','2000-01-26');
INSERT INTO "rptg_seq" VALUES
('53014F71-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-14','2000-01-27');
INSERT INTO "rptg_seq" VALUES
('53014F72-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-14','2000-01-28');
INSERT INTO "rptg_seq" VALUES
('53014F73-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-15','2000-01-27');
INSERT INTO "rptg_seq" VALUES
('53014F74-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-15','2000-01-28');
INSERT INTO "rptg_seq" VALUES
('53014F75-197B-11D5-AE7D-001083FD6A84','53014F21-197B-11D5-AE7D-001083FD6A84','2000-01-16','2000-01-28');
INSERT INTO "rptg_seq" VALUES
('3743CB52-2D46-11D5-8A09-00508B0E83B6','3743CB51-2D46-11D5-8A09-00508B0E83B6','2000-01-01',NULL);
--
-- Data for TOC Entry ID 52 (OID 1621689)
--
-- Name: rptg_seq_typ Type: TABLE DATA Owner: postgres
--


INSERT INTO "rptg_seq_typ" VALUES ('53014F21-197B-11D5-AE7D-001083FD6A84','Semi-monthly','pay semi-monthly','t');
INSERT INTO "rptg_seq_typ" VALUES ('53014F20-197B-11D5-AE7D-001083FD6A84','Bi-weekly','pay bi-weekly','t');
INSERT INTO "rptg_seq_typ" VALUES ('3743CB51-2D46-11D5-8A09-00508B0E83B6','Monthly','Coverage Month','f');
--
-- Data for TOC Entry ID 53 (OID 1621705)
--
-- Name: stepped_cvg_rptd Type: TABLE DATA Owner: postgres
--


INSERT INTO "stepped_cvg_rptd" VALUES
('73B7259C-3A46-D511-8A0A-00508B0E83B6','DB1F2BCA-9272-D411-B712-0008C78CB1FE','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','53014F33-197B-11D5-AE7D-001083FD6A84','51E79587-D136-D411-B5F4-0050DA5FD075','2000-12-15',10,NULL);
INSERT INTO "stepped_cvg_rptd" VALUES
('73B7259C-3A46-D511-8A0A-00508B0E83B6','DB1F2BCA-9272-D411-B712-0008C78CB1FE','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','3743CB52-2D46-11D5-8A09-00508B0E83B6','51E79587-D136-D411-B5F4-0050DA5FD075','2001-01-31',10,NULL);
INSERT INTO "stepped_cvg_rptd" VALUES
('73B7259C-3A46-D511-8A0A-00508B0E83B6','DB1F2BCA-9272-D411-B712-0008C78CB1FE','F7E6C60D-1979-11D5-AE7D-001083FD6A84','CF2A3EC7-E0E3-11D3-A9BB-0060B06823C3','3743CB52-2D46-11D5-8A09-00508B0E83B6','51E79587-D136-D411-B5F4-0050DA5FD075','2001-04-30',44,NULL);
--
-- Data for TOC Entry ID 54 (OID 1621745)
--
-- Name: rptg_session Type: TABLE DATA Owner: postgres
--


INSERT INTO "rptg_session" VALUES ('3743CC60-2D46-11D5-8A09-00508B0E83B6',1,'2001-05-01 07:01:00+00');
INSERT INTO "rptg_session" VALUES ('407C3A98-4A22-11D5-895B-00C04FA05897',2,'2001-05-16 17:38:26+00');
--
-- TOC Entry ID 20 (OID 1621509)
--
-- Name: "idx_ben_plan_ak1" Type: INDEX Owner: postgres
--

CREATE UNIQUE INDEX "idx_ben_plan_ak1" on "ben_plan" using btree ( "ben_plan_halid" "int4_ops" );

--
-- TOC Entry ID 21 (OID 1621564)
--
-- Name: "idx_emp_grp_ak1" Type: INDEX Owner: postgres
--

CREATE UNIQUE INDEX "idx_emp_grp_ak1" on "emp_grp" using btree ( "emp_grp_halid" "int4_ops" );

--
-- TOC Entry ID 22 (OID 1621564)
--
-- Name: "idx_emp_grp_ak2" Type: INDEX Owner: postgres
--

CREATE UNIQUE INDEX "idx_emp_grp_ak2" on "emp_grp" using btree ( "emp_grp_nm" "varchar_ops", "emp_grp_typ" "int2_ops"
);

--
-- TOC Entry ID 23 (OID 1621581)
--
-- Name: "idx_grp_rate_ak1" Type: INDEX Owner: postgres
--

CREATE UNIQUE INDEX "idx_grp_rate_ak1" on "grp_rate" using btree ( "emp_grp_id" "uniqueidentifier_ops", "ben_plan_id"
"uniqueidentifier_ops","grp_rate_eff_dt" "date_ops" ); 

--
-- TOC Entry ID 24 (OID 1621658)
--
-- Name: "idx_rate_step_ak1" Type: INDEX Owner: postgres
--

CREATE UNIQUE INDEX "idx_rate_step_ak1" on "rate_step" using btree ( "rate_step_nm" "varchar_ops" );

--
-- TOC Entry ID 25 (OID 1621689)
--
-- Name: "idx_rptg_seq_typ_ak1" Type: INDEX Owner: postgres
--

CREATE UNIQUE INDEX "idx_rptg_seq_typ_ak1" on "rptg_seq_typ" using btree ( "rptg_seq_typ_nm" "varchar_ops" );

--
-- TOC Entry ID 26 (OID 1621745)
--
-- Name: "rptg_session_rptg_session_c_key" Type: INDEX Owner: postgres
--

CREATE UNIQUE INDEX "rptg_session_rptg_session_c_key" on "rptg_session" using btree ( "rptg_session_confirm_no"
"int4_ops"); 

--
-- TOC Entry ID 85 (OID 1621919)
--
-- Name: "RI_ConstraintTrigger_1621918" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_rptgseq_rptgseqtyp" AFTER INSERT OR UPDATE ON "rptg_seq"  FROM "rptg_seq_typ" NOT
DEFERRABLEINITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_rptgseq_rptgseqtyp', 'rptg_seq',
'rptg_seq_typ','UNSPECIFIED', 'rptg_seq_typ_id', 'rptg_seq_typ_id'); 

--
-- TOC Entry ID 88 (OID 1621921)
--
-- Name: "RI_ConstraintTrigger_1621920" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_rptgseq_rptgseqtyp" AFTER DELETE ON "rptg_seq_typ"  FROM "rptg_seq" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_rptgseq_rptgseqtyp', 'rptg_seq',
'rptg_seq_typ','UNSPECIFIED', 'rptg_seq_typ_id', 'rptg_seq_typ_id'); 

--
-- TOC Entry ID 89 (OID 1621923)
--
-- Name: "RI_ConstraintTrigger_1621922" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_rptgseq_rptgseqtyp" AFTER UPDATE ON "rptg_seq_typ"  FROM "rptg_seq" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_rptgseq_rptgseqtyp', 'rptg_seq',
'rptg_seq_typ','UNSPECIFIED', 'rptg_seq_typ_id', 'rptg_seq_typ_id'); 

--
-- TOC Entry ID 62 (OID 1621925)
--
-- Name: "RI_ConstraintTrigger_1621924" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_rptgseq" AFTER INSERT OR UPDATE ON "cvg_rptd"  FROM "rptg_seq" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_cvgrptd_rptgseq', 'cvg_rptd', 'rptg_seq',
'UNSPECIFIED','rptg_seq_id', 'rptg_seq_id'); 

--
-- TOC Entry ID 86 (OID 1621927)
--
-- Name: "RI_ConstraintTrigger_1621926" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_rptgseq" AFTER DELETE ON "rptg_seq"  FROM "cvg_rptd" NOT DEFERRABLE INITIALLY
IMMEDIATEFOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_cvgrptd_rptgseq', 'cvg_rptd', 'rptg_seq',
'UNSPECIFIED','rptg_seq_id', 'rptg_seq_id'); 

--
-- TOC Entry ID 87 (OID 1621929)
--
-- Name: "RI_ConstraintTrigger_1621928" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_rptgseq" AFTER UPDATE ON "rptg_seq"  FROM "cvg_rptd" NOT DEFERRABLE INITIALLY
IMMEDIATEFOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_cvgrptd_rptgseq', 'cvg_rptd', 'rptg_seq',
'UNSPECIFIED','rptg_seq_id', 'rptg_seq_id'); 

--
-- TOC Entry ID 63 (OID 1621931)
--
-- Name: "RI_ConstraintTrigger_1621930" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_grpratestep" AFTER INSERT OR UPDATE ON "cvg_rptd"  FROM "grp_rate_step" NOT
DEFERRABLEINITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_cvgrptd_grpratestep', 'cvg_rptd',
'grp_rate_step','UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id',
'rate_step_id','rate_step_id'); 

--
-- TOC Entry ID 77 (OID 1621933)
--
-- Name: "RI_ConstraintTrigger_1621932" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_grpratestep" AFTER DELETE ON "grp_rate_step"  FROM "cvg_rptd" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_cvgrptd_grpratestep', 'cvg_rptd',
'grp_rate_step','UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id',
'rate_step_id','rate_step_id'); 

--
-- TOC Entry ID 78 (OID 1621935)
--
-- Name: "RI_ConstraintTrigger_1621934" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_grpratestep" AFTER UPDATE ON "grp_rate_step"  FROM "cvg_rptd" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_cvgrptd_grpratestep', 'cvg_rptd',
'grp_rate_step','UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id',
'rate_step_id','rate_step_id'); 

--
-- TOC Entry ID 73 (OID 1621937)
--
-- Name: "RI_ConstraintTrigger_1621936" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_benplan_grprate" AFTER INSERT OR UPDATE ON "grp_rate"  FROM "ben_plan" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_benplan_grprate', 'grp_rate', 'ben_plan',
'UNSPECIFIED','ben_plan_id', 'ben_plan_id'); 

--
-- TOC Entry ID 55 (OID 1621939)
--
-- Name: "RI_ConstraintTrigger_1621938" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_benplan_grprate" AFTER DELETE ON "ben_plan"  FROM "grp_rate" NOT DEFERRABLE INITIALLY
IMMEDIATEFOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_benplan_grprate', 'grp_rate', 'ben_plan',
'UNSPECIFIED','ben_plan_id', 'ben_plan_id'); 

--
-- TOC Entry ID 56 (OID 1621941)
--
-- Name: "RI_ConstraintTrigger_1621940" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_benplan_grprate" AFTER UPDATE ON "ben_plan"  FROM "grp_rate" NOT DEFERRABLE INITIALLY
IMMEDIATEFOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_benplan_grprate', 'grp_rate', 'ben_plan',
'UNSPECIFIED','ben_plan_id', 'ben_plan_id'); 

--
-- TOC Entry ID 74 (OID 1621943)
--
-- Name: "RI_ConstraintTrigger_1621942" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_empgrp_grprate" AFTER INSERT OR UPDATE ON "grp_rate"  FROM "emp_grp" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_empgrp_grprate', 'grp_rate', 'emp_grp',
'UNSPECIFIED','emp_grp_id', 'emp_grp_id'); 

--
-- TOC Entry ID 71 (OID 1621945)
--
-- Name: "RI_ConstraintTrigger_1621944" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_empgrp_grprate" AFTER DELETE ON "emp_grp"  FROM "grp_rate" NOT DEFERRABLE INITIALLY
IMMEDIATEFOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_empgrp_grprate', 'grp_rate', 'emp_grp',
'UNSPECIFIED','emp_grp_id', 'emp_grp_id'); 

--
-- TOC Entry ID 72 (OID 1621947)
--
-- Name: "RI_ConstraintTrigger_1621946" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_empgrp_grprate" AFTER UPDATE ON "emp_grp"  FROM "grp_rate" NOT DEFERRABLE INITIALLY
IMMEDIATEFOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_empgrp_grprate', 'grp_rate', 'emp_grp',
'UNSPECIFIED','emp_grp_id', 'emp_grp_id'); 

--
-- TOC Entry ID 81 (OID 1621949)
--
-- Name: "RI_ConstraintTrigger_1621948" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_mocvgrptd" AFTER INSERT OR UPDATE ON "mo_cvg_rptd"  FROM "cvg_rptd" NOT
DEFERRABLEINITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_cvgrptd_mocvgrptd',
'mo_cvg_rptd','cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id',
'grp_rate_id','rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); 

--
-- TOC Entry ID 64 (OID 1621951)
--
-- Name: "RI_ConstraintTrigger_1621950" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_mocvgrptd" AFTER DELETE ON "cvg_rptd"  FROM "mo_cvg_rptd" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_cvgrptd_mocvgrptd', 'mo_cvg_rptd',
'cvg_rptd','UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id',
'rate_step_id','rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); 

--
-- TOC Entry ID 65 (OID 1621953)
--
-- Name: "RI_ConstraintTrigger_1621952" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_mocvgrptd" AFTER UPDATE ON "cvg_rptd"  FROM "mo_cvg_rptd" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_cvgrptd_mocvgrptd', 'mo_cvg_rptd',
'cvg_rptd','UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id',
'rate_step_id','rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); 

--
-- TOC Entry ID 79 (OID 1621955)
--
-- Name: "RI_ConstraintTrigger_1621954" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_ratestep_grpratestep" AFTER INSERT OR UPDATE ON "grp_rate_step"  FROM "rate_step" NOT
DEFERRABLEINITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_ratestep_grpratestep',
'grp_rate_step','rate_step', 'UNSPECIFIED', 'rate_step_id', 'rate_step_id'); 

--
-- TOC Entry ID 83 (OID 1621957)
--
-- Name: "RI_ConstraintTrigger_1621956" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_ratestep_grpratestep" AFTER DELETE ON "rate_step"  FROM "grp_rate_step" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_ratestep_grpratestep', 'grp_rate_step',
'rate_step','UNSPECIFIED', 'rate_step_id', 'rate_step_id'); 

--
-- TOC Entry ID 84 (OID 1621959)
--
-- Name: "RI_ConstraintTrigger_1621958" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_ratestep_grpratestep" AFTER UPDATE ON "rate_step"  FROM "grp_rate_step" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_ratestep_grpratestep', 'grp_rate_step',
'rate_step','UNSPECIFIED', 'rate_step_id', 'rate_step_id'); 

--
-- TOC Entry ID 80 (OID 1621961)
--
-- Name: "RI_ConstraintTrigger_1621960" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_grprate_grpratestep" AFTER INSERT OR UPDATE ON "grp_rate_step"  FROM "grp_rate" NOT
DEFERRABLEINITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_grprate_grpratestep',
'grp_rate_step','grp_rate', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id',
'grp_rate_id');

--
-- TOC Entry ID 75 (OID 1621963)
--
-- Name: "RI_ConstraintTrigger_1621962" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_grprate_grpratestep" AFTER DELETE ON "grp_rate"  FROM "grp_rate_step" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_grprate_grpratestep', 'grp_rate_step',
'grp_rate','UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id'); 

--
-- TOC Entry ID 76 (OID 1621965)
--
-- Name: "RI_ConstraintTrigger_1621964" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_grprate_grpratestep" AFTER UPDATE ON "grp_rate"  FROM "grp_rate_step" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_grprate_grpratestep', 'grp_rate_step',
'grp_rate','UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id', 'grp_rate_id'); 

--
-- TOC Entry ID 59 (OID 1621967)
--
-- Name: "RI_ConstraintTrigger_1621966" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_benplan_cvgstep" AFTER INSERT OR UPDATE ON "coverage_step"  FROM "ben_plan" NOT
DEFERRABLEINITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_benplan_cvgstep',
'coverage_step','ben_plan', 'UNSPECIFIED', 'ben_plan_id', 'ben_plan_id'); 

--
-- TOC Entry ID 57 (OID 1621969)
--
-- Name: "RI_ConstraintTrigger_1621968" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_benplan_cvgstep" AFTER DELETE ON "ben_plan"  FROM "coverage_step" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_benplan_cvgstep', 'coverage_step',
'ben_plan','UNSPECIFIED', 'ben_plan_id', 'ben_plan_id'); 

--
-- TOC Entry ID 58 (OID 1621971)
--
-- Name: "RI_ConstraintTrigger_1621970" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_benplan_cvgstep" AFTER UPDATE ON "ben_plan"  FROM "coverage_step" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_benplan_cvgstep', 'coverage_step',
'ben_plan','UNSPECIFIED', 'ben_plan_id', 'ben_plan_id'); 

--
-- TOC Entry ID 90 (OID 1621973)
--
-- Name: "RI_ConstraintTrigger_1621972" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_steppedcvgrptd" AFTER INSERT OR UPDATE ON "stepped_cvg_rptd"  FROM "cvg_rptd" NOT
DEFERRABLEINITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_cvgrptd_steppedcvgrptd',
'stepped_cvg_rptd','cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id',
'grp_rate_id','rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); 

--
-- TOC Entry ID 66 (OID 1621975)
--
-- Name: "RI_ConstraintTrigger_1621974" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_steppedcvgrptd" AFTER DELETE ON "cvg_rptd"  FROM "stepped_cvg_rptd" NOT
DEFERRABLEINITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_cvgrptd_steppedcvgrptd',
'stepped_cvg_rptd','cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id',
'grp_rate_id','rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); 

--
-- TOC Entry ID 67 (OID 1621977)
--
-- Name: "RI_ConstraintTrigger_1621976" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_steppedcvgrptd" AFTER UPDATE ON "cvg_rptd"  FROM "stepped_cvg_rptd" NOT
DEFERRABLEINITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_cvgrptd_steppedcvgrptd',
'stepped_cvg_rptd','cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id',
'grp_rate_id','rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); 

--
-- TOC Entry ID 91 (OID 1621979)
--
-- Name: "RI_ConstraintTrigger_1621978" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_steppedcvgrptg_cvgstep" AFTER INSERT OR UPDATE ON "stepped_cvg_rptd"  FROM
"coverage_step"NOT DEFERRABLE INITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins"
('fk_steppedcvgrptg_cvgstep','stepped_cvg_rptd', 'coverage_step', 'UNSPECIFIED', 'ben_plan_id', 'ben_plan_id',
'cvgstep_id','cvgstep_id'); 

--
-- TOC Entry ID 60 (OID 1621981)
--
-- Name: "RI_ConstraintTrigger_1621980" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_steppedcvgrptg_cvgstep" AFTER DELETE ON "coverage_step"  FROM "stepped_cvg_rptd" NOT
DEFERRABLEINITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_steppedcvgrptg_cvgstep',
'stepped_cvg_rptd','coverage_step', 'UNSPECIFIED', 'ben_plan_id', 'ben_plan_id', 'cvgstep_id', 'cvgstep_id'); 

--
-- TOC Entry ID 61 (OID 1621983)
--
-- Name: "RI_ConstraintTrigger_1621982" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_steppedcvgrptg_cvgstep" AFTER UPDATE ON "coverage_step"  FROM "stepped_cvg_rptd" NOT
DEFERRABLEINITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_steppedcvgrptg_cvgstep',
'stepped_cvg_rptd','coverage_step', 'UNSPECIFIED', 'ben_plan_id', 'ben_plan_id', 'cvgstep_id', 'cvgstep_id'); 

--
-- TOC Entry ID 82 (OID 1621985)
--
-- Name: "RI_ConstraintTrigger_1621984" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_payprdcvgrptd" AFTER INSERT OR UPDATE ON "pay_prd_cvg_rptd"  FROM "cvg_rptd" NOT
DEFERRABLEINITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_cvgrptd_payprdcvgrptd',
'pay_prd_cvg_rptd','cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id',
'grp_rate_id','rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); 

--
-- TOC Entry ID 68 (OID 1621987)
--
-- Name: "RI_ConstraintTrigger_1621986" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_payprdcvgrptd" AFTER DELETE ON "cvg_rptd"  FROM "pay_prd_cvg_rptd" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_cvgrptd_payprdcvgrptd',
'pay_prd_cvg_rptd','cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id',
'grp_rate_id','rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); 

--
-- TOC Entry ID 69 (OID 1621989)
--
-- Name: "RI_ConstraintTrigger_1621988" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_cvgrptd_payprdcvgrptd" AFTER UPDATE ON "cvg_rptd"  FROM "pay_prd_cvg_rptd" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_cvgrptd_payprdcvgrptd',
'pay_prd_cvg_rptd','cvg_rptd', 'UNSPECIFIED', 'emp_grp_id', 'emp_grp_id', 'ben_plan_id', 'ben_plan_id', 'grp_rate_id',
'grp_rate_id','rate_step_id', 'rate_step_id', 'rptg_seq_id', 'rptg_seq_id', 'rptg_prd_end_dt', 'rptg_prd_end_dt'); 

--
-- TOC Entry ID 70 (OID 1621991)
--
-- Name: "RI_ConstraintTrigger_1621990" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_rptgsession_cvgrptd" AFTER INSERT OR UPDATE ON "cvg_rptd"  FROM "rptg_session" NOT
DEFERRABLEINITIALLY IMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_check_ins" ('fk_rptgsession_cvgrptd', 'cvg_rptd',
'rptg_session','UNSPECIFIED', 'rptg_session_id', 'rptg_session_id'); 

--
-- TOC Entry ID 92 (OID 1621993)
--
-- Name: "RI_ConstraintTrigger_1621992" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_rptgsession_cvgrptd" AFTER DELETE ON "rptg_session"  FROM "cvg_rptd" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_del" ('fk_rptgsession_cvgrptd', 'cvg_rptd',
'rptg_session','UNSPECIFIED', 'rptg_session_id', 'rptg_session_id'); 

--
-- TOC Entry ID 93 (OID 1621995)
--
-- Name: "RI_ConstraintTrigger_1621994" Type: TRIGGER Owner: postgres
--

CREATE CONSTRAINT TRIGGER "fk_rptgsession_cvgrptd" AFTER UPDATE ON "rptg_session"  FROM "cvg_rptd" NOT DEFERRABLE
INITIALLYIMMEDIATE FOR EACH ROW EXECUTE PROCEDURE "RI_FKey_noaction_upd" ('fk_rptgsession_cvgrptd', 'cvg_rptd',
'rptg_session','UNSPECIFIED', 'rptg_session_id', 'rptg_session_id'); 

--
-- TOC Entry ID 6 (OID 1621726)
--
-- Name: rptg_session_rptg_session_c_seq Type: SEQUENCE SET Owner:
--

SELECT setval ('"rptg_session_rptg_session_c_seq"', 2, 't');

/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