===========================================================
                                      .___ __  __   
          _________________  __ __  __| _/|__|/  |_ 
         / ___\_` __ \__  \ |  |  \/ __ | | \\_  __\
        / /_/  >  | \// __ \|  |  / /_/ | |  ||  |  
        \___  /|__|  (____  /____/\____ | |__||__|  
       /_____/            \/           \/           
              grep rough audit - static analysis tool
                  v2.8 written by @Wireghoul
=================================[justanotherhacker.com]===
pgtap-1.1.0/Changes-363---------------------------
pgtap-1.1.0/Changes:364:* Got `sql/artap.sql` tests passing again when building with `$TAPSCHEMA` set.
pgtap-1.1.0/Changes-365-* Changed to saner source URL in `contrib/pgtap.spec`.
##############################################
pgtap-1.1.0/Changes-386-  directory of the PostgreSQL distribution. If `pg_config` isn't in the
pgtap-1.1.0/Changes:387:  `$PATH` environment variable, one can simply set `PG_CONFIG` to point to it.
pgtap-1.1.0/Changes-388-  If building inside the contrib directory, set `NO_PGXS=1`.
##############################################
pgtap-1.1.0/Changes-593-* Updated the `Makefile` to fix the shebang line in `pg_prove` if
pgtap-1.1.0/Changes:594:  Perl is found, and to emit a warning if the `$PERL` variable is not
pgtap-1.1.0/Changes:595:  set. - Updated the `Makefile` so that if `$PERL` is set and
pgtap-1.1.0/Changes-596-  TAP::Harness is not installed, it warns the user to install it in
##############################################
pgtap-1.1.0/Changes-786-* Added support for schema qualification of test functions. Just set the
pgtap-1.1.0/Changes:787:  `$TAPSCHEMA` environment variable when running `make`.
pgtap-1.1.0/Changes-788-* Added support for standard PostgreSQL-type regression testing by just
##############################################
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-16--              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch:17:-             WHERE n.nspname = $1
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-18--               AND c.relname = $2
##############################################
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-30--              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch:31:-             WHERE n.nspname = $1
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-32--               AND c.relname = $2
##############################################
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-53--              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch:54:-             WHERE c.relname = $1
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-55--               AND n.nspname NOT IN ('pg_catalog', 'information_schema')
##############################################
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-90--              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch:91:-             WHERE pn.nspname = $1
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-92--               AND pc.relname = $2
##############################################
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-106--              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch:107:-             WHERE pn.nspname = $1
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-108--               AND pc.relname = $2
##############################################
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-131--              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch:132:-             WHERE pc.relname = $1
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-133--               AND pp.polname = $2
##############################################
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-147--              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch:148:-             WHERE pc.relname = $1
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-149--               AND pp.polname = $2
##############################################
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-177--      JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch:178:-     WHERE pn.nspname = $1
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-179--       AND pc.relname = $2
##############################################
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-213--      JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch:214:-     WHERE pc.relname = $1
pgtap-1.1.0/compat/9.4/pgtap--0.99.0--1.0.0.patch-215--       AND pp.polname = $2
##############################################
pgtap-1.1.0/compat/9.6/pgtap--0.97.0--0.98.0.patch-17--          JOIN pg_catalog.pg_namespace pn ON pc.relnamespace = pn.oid
pgtap-1.1.0/compat/9.6/pgtap--0.97.0--0.98.0.patch:18:-         WHERE cn.nspname = $1
pgtap-1.1.0/compat/9.6/pgtap--0.97.0--0.98.0.patch-19--           AND cc.relname = $2
##############################################
pgtap-1.1.0/compat/9.6/pgtap--0.97.0--0.98.0.patch-34--          JOIN pg_catalog.pg_class pc ON i.inhparent = pc.oid
pgtap-1.1.0/compat/9.6/pgtap--0.97.0--0.98.0.patch:35:-         WHERE cc.relname = $1
pgtap-1.1.0/compat/9.6/pgtap--0.97.0--0.98.0.patch-36--           AND cc.relispartition
##############################################
pgtap-1.1.0/compat/9.6/pgtap--0.97.0--0.98.0.patch-81--      JOIN pg_catalog.pg_inherits i ON c.oid = i.inhparent
pgtap-1.1.0/compat/9.6/pgtap--0.97.0--0.98.0.patch:82:-     WHERE n.nspname = $1
pgtap-1.1.0/compat/9.6/pgtap--0.97.0--0.98.0.patch-83--       AND c.relname = $2
##############################################
pgtap-1.1.0/compat/9.6/pgtap--0.97.0--0.98.0.patch-92--      JOIN pg_catalog.pg_inherits i ON c.oid = i.inhparent
pgtap-1.1.0/compat/9.6/pgtap--0.97.0--0.98.0.patch:93:-     WHERE c.relname = $1
pgtap-1.1.0/compat/9.6/pgtap--0.97.0--0.98.0.patch-94--       AND c.relkind = 'p'
##############################################
pgtap-1.1.0/compat/install-9.4.patch-34--              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/compat/install-9.4.patch:35:-             WHERE n.nspname = $1
pgtap-1.1.0/compat/install-9.4.patch-36--               AND c.relname = $2
##############################################
pgtap-1.1.0/compat/install-9.4.patch-48--              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/compat/install-9.4.patch:49:-             WHERE n.nspname = $1
pgtap-1.1.0/compat/install-9.4.patch-50--               AND c.relname = $2
##############################################
pgtap-1.1.0/compat/install-9.4.patch-71--              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/compat/install-9.4.patch:72:-             WHERE c.relname = $1
pgtap-1.1.0/compat/install-9.4.patch-73--               AND n.nspname NOT IN ('pg_catalog', 'information_schema')
##############################################
pgtap-1.1.0/compat/install-9.4.patch-108--              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/compat/install-9.4.patch:109:-             WHERE pn.nspname = $1
pgtap-1.1.0/compat/install-9.4.patch-110--               AND pc.relname = $2
##############################################
pgtap-1.1.0/compat/install-9.4.patch-124--              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/compat/install-9.4.patch:125:-             WHERE pn.nspname = $1
pgtap-1.1.0/compat/install-9.4.patch-126--               AND pc.relname = $2
##############################################
pgtap-1.1.0/compat/install-9.4.patch-149--              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/compat/install-9.4.patch:150:-             WHERE pc.relname = $1
pgtap-1.1.0/compat/install-9.4.patch-151--               AND pp.polname = $2
##############################################
pgtap-1.1.0/compat/install-9.4.patch-165--              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/compat/install-9.4.patch:166:-             WHERE pc.relname = $1
pgtap-1.1.0/compat/install-9.4.patch-167--               AND pp.polname = $2
##############################################
pgtap-1.1.0/compat/install-9.4.patch-195--      JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/compat/install-9.4.patch:196:-     WHERE pn.nspname = $1
pgtap-1.1.0/compat/install-9.4.patch-197--       AND pc.relname = $2
##############################################
pgtap-1.1.0/compat/install-9.4.patch-231--      JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/compat/install-9.4.patch:232:-     WHERE pc.relname = $1
pgtap-1.1.0/compat/install-9.4.patch-233--       AND pp.polname = $2
##############################################
pgtap-1.1.0/compat/install-9.6.patch-16--          JOIN pg_catalog.pg_namespace pn ON pc.relnamespace = pn.oid
pgtap-1.1.0/compat/install-9.6.patch:17:-         WHERE cn.nspname = $1
pgtap-1.1.0/compat/install-9.6.patch-18--           AND cc.relname = $2
##############################################
pgtap-1.1.0/compat/install-9.6.patch-33--          JOIN pg_catalog.pg_class pc ON i.inhparent = pc.oid
pgtap-1.1.0/compat/install-9.6.patch:34:-         WHERE cc.relname = $1
pgtap-1.1.0/compat/install-9.6.patch-35--           AND cc.relispartition
##############################################
pgtap-1.1.0/compat/install-9.6.patch-80--      JOIN pg_catalog.pg_inherits i ON c.oid = i.inhparent
pgtap-1.1.0/compat/install-9.6.patch:81:-     WHERE n.nspname = $1
pgtap-1.1.0/compat/install-9.6.patch-82--       AND c.relname = $2
##############################################
pgtap-1.1.0/compat/install-9.6.patch-91--      JOIN pg_catalog.pg_inherits i ON c.oid = i.inhparent
pgtap-1.1.0/compat/install-9.6.patch:92:-     WHERE c.relname = $1
pgtap-1.1.0/compat/install-9.6.patch-93--       AND c.relkind = 'p'
##############################################
pgtap-1.1.0/doc/pgtap.mmd-112-
pgtap-1.1.0/doc/pgtap.mmd:113:* `$PGDATABASE`
pgtap-1.1.0/doc/pgtap.mmd:114:* `$PGHOST`
pgtap-1.1.0/doc/pgtap.mmd:115:* `$PGPORT`
pgtap-1.1.0/doc/pgtap.mmd:116:* `$PGUSER`
pgtap-1.1.0/doc/pgtap.mmd-117-
##############################################
pgtap-1.1.0/doc/pgtap.mmd-165-
pgtap-1.1.0/doc/pgtap.mmd:166:But do be aware that, if you've specified a schema using `$TAPSCHEMA`, that
pgtap-1.1.0/doc/pgtap.mmd-167-schema will always be created and the pgTAP functions placed in it.
##############################################
pgtap-1.1.0/doc/pgtap.mmd-769-    PREPARE "my test" AS SELECT * FROM active_users() WHERE name LIKE 'A%';
pgtap-1.1.0/doc/pgtap.mmd:770:    PREPARE expect AS SELECT * FROM users WHERE active = $1 AND name LIKE $2;
pgtap-1.1.0/doc/pgtap.mmd-771-
##############################################
pgtap-1.1.0/sql/pgtap--0.90.0--0.91.0.sql-12-                  FROM pg_catalog.pg_tablespace
pgtap-1.1.0/sql/pgtap--0.90.0--0.91.0.sql:13:                 WHERE spcname = $1
pgtap-1.1.0/sql/pgtap--0.90.0--0.91.0.sql-14-                   AND pg_tablespace_location(oid) = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.90.0--0.91.0.sql-21-                  FROM pg_catalog.pg_tablespace
pgtap-1.1.0/sql/pgtap--0.90.0--0.91.0.sql:22:                 WHERE spcname = $1
pgtap-1.1.0/sql/pgtap--0.90.0--0.91.0.sql-23-                   AND spclocation = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-10-          JOIN pg_catalog.pg_attribute a ON c.oid = a.attrelid
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:11:         WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-12-           AND pg_catalog.pg_table_is_visible(c.oid)
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-96-      JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:97:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-98-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-104-      FROM pg_catalog.pg_class c
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:105:     WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-106-       AND pg_catalog.pg_table_is_visible(c.oid)
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-165-      JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:166:     WHERE c.relkind = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-167-       AND n.nspname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-174-      FROM pg_catalog.pg_class c
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:175:     WHERE c.relkind = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-176-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-445-          JOIN pg_catalog.pg_class c ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:446:         WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-447-           AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-520-      FROM tap_funky
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:521:     WHERE schema = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-522-       AND name   = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-529-      FROM tap_funky
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:530:     WHERE name = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-531-       AND args = array_to_string($2, ',')
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-611-          JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:612:         WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-613-           AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-624-          JOIN pg_catalog.pg_class c     ON c.oid = t.tgrelid
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:625:         WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-626-           AND t.tgname  = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-640-              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:641:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-642-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-655-              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:656:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-657-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-673-              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:674:             WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-675-               AND n.nspname NOT IN ('pg_catalog', 'information_schema')
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-777-            ON x.indkey[s.i] IS NOT NULL
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:778:         WHERE ct.relname = $2
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-779-           AND ci.relname = $3
##############################################
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-793-            ON x.indkey[s.i] IS NOT NULL
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql:794:         WHERE ct.relname = $1
pgtap-1.1.0/sql/pgtap--0.91.0--0.92.0.sql-795-           AND ci.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-9-      FROM pg_catalog.pg_namespace
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:10:     WHERE nspname = $1;
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-11-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-95-      FROM pg_all_foreign_keys
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:96:     WHERE fk_table_name = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-97-       AND fk_columns    = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-130-          JOIN pg_catalog.pg_class c     ON c.oid = t.tgrelid
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:131:         WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-132-           AND t.tgname  = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-141-           FROM pg_all_foreign_keys
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:142:          WHERE quote_ident(fk_table_name)     = quote_ident($1)
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-143-            AND pg_catalog.pg_table_is_visible(fk_table_oid)
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-156-      JOIN pg_catalog.pg_attribute a ON c.oid = a.attrelid
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:157:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-158-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-187-      JOIN pg_catalog.pg_namespace tn ON t.typnamespace = tn.oid
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:188:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-189-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-326-      FROM pg_catalog.pg_tablespace
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:327:     WHERE spcname = $1;
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-328-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-363-      JOIN pg_catalog.pg_namespace n ON n.oid = ct.relnamespace
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:364:     WHERE n.nspname  = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-365-       AND ct.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-376-      JOIN pg_catalog.pg_class ci    ON ci.oid = x.indexrelid
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:377:     WHERE ct.relname = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-378-       AND ci.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-389-      JOIN pg_catalog.pg_namespace n ON n.oid = ct.relnamespace
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:390:     WHERE n.nspname  = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-391-       AND ct.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-400-      JOIN pg_catalog.pg_class ci    ON ci.oid = x.indexrelid
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:401:     WHERE ct.relname = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-402-       AND ci.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-466-      FROM pg_catalog.pg_language
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:467:     WHERE lanname = $1;
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-468-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-500-      JOIN pg_catalog.pg_namespace n ON oc.opcnamespace = n.oid
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:501:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-502-       AND opcname   = $2;
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-508-      FROM pg_catalog.pg_opclass
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:509:     WHERE opcname = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-510-       AND pg_catalog.pg_opclass_is_visible(oid);
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-572-          JOIN pg_catalog.pg_namespace n ON oc.opcnamespace = n.oid
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:573:         WHERE n.nspname  = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-574-           AND oc.opcname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-582-          FROM pg_catalog.pg_opclass oc
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:583:         WHERE oc.opcname = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-584-           AND pg_opclass_is_visible(oid)
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-616-      JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:617:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-618-       AND t.typname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-624-      FROM pg_catalog.pg_type
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql:625:     WHERE typname = $1
pgtap-1.1.0/sql/pgtap--0.92.0--0.93.0.sql-626-       AND pg_catalog.pg_type_is_visible(oid)
##############################################
pgtap-1.1.0/sql/pgtap--0.95.0--0.96.0.sql.in-10-          JOIN pg_catalog.pg_namespace n ON p.pronamespace = n.oid
pgtap-1.1.0/sql/pgtap--0.95.0--0.96.0.sql.in:11:         WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.95.0--0.96.0.sql.in-12-           AND p.proname ~ $2
##############################################
pgtap-1.1.0/sql/pgtap--0.95.0--0.96.0.sql.in-161-      JOIN pg_catalog.pg_extension e ON n.oid = e.extnamespace
pgtap-1.1.0/sql/pgtap--0.95.0--0.96.0.sql.in:162:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.95.0--0.96.0.sql.in-163-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap--0.96.0--0.97.0.sql.in-23-          JOIN pg_catalog.pg_namespace n ON n.oid = ct.relnamespace
pgtap-1.1.0/sql/pgtap--0.96.0--0.97.0.sql.in:24:         WHERE ($1 IS NULL OR n.nspname  = $1)
pgtap-1.1.0/sql/pgtap--0.96.0--0.97.0.sql.in-25-           AND ct.relname = $2
pgtap-1.1.0/sql/pgtap--0.96.0--0.97.0.sql.in-26-    ) icols
pgtap-1.1.0/sql/pgtap--0.96.0--0.97.0.sql.in:27:    WHERE cols = $3 )
pgtap-1.1.0/sql/pgtap--0.96.0--0.97.0.sql.in-28-$$ LANGUAGE sql;
##############################################
pgtap-1.1.0/sql/pgtap--0.96.0--0.97.0.sql.in-227-          JOIN pg_catalog.pg_namespace n ON ex.extnamespace = n.oid
pgtap-1.1.0/sql/pgtap--0.96.0--0.97.0.sql.in:228:         WHERE n.nspname  = $1
pgtap-1.1.0/sql/pgtap--0.96.0--0.97.0.sql.in-229-           AND ex.extname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.96.0--0.97.0.sql.in-238-          FROM pg_catalog.pg_extension ex
pgtap-1.1.0/sql/pgtap--0.96.0--0.97.0.sql.in:239:         WHERE ex.extname = $1
pgtap-1.1.0/sql/pgtap--0.96.0--0.97.0.sql.in-240-    );
##############################################
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-10-          JOIN pg_catalog.pg_class c ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in:11:         WHERE c.relkind = ANY($1)
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-12-           AND n.nspname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-21-          FROM pg_catalog.pg_class c
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in:22:         WHERE c.relkind = ANY($1)
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-23-           AND pg_catalog.pg_table_is_visible(c.oid)
##############################################
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-85-          JOIN pg_catalog.pg_class c ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in:86:         WHERE c.relkind = ANY($1)
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-87-           AND n.nspname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-129-          JOIN pg_catalog.pg_class c ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in:130:         WHERE c.relkind = ANY($1)
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-131-           AND n.nspname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-194-      JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in:195:     WHERE c.relkind = ANY($1)
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-196-       AND n.nspname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-203-      FROM pg_catalog.pg_class c
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in:204:     WHERE c.relkind = ANY($1)
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-205-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-322-          JOIN pg_catalog.pg_namespace pn ON pc.relnamespace = pn.oid
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in:323:         WHERE cn.nspname = $1
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-324-           AND cc.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-339-          JOIN pg_catalog.pg_class pc ON i.inhparent = pc.oid
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in:340:         WHERE cc.relname = $1
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-341-           AND cc.relispartition
##############################################
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-386-      JOIN pg_catalog.pg_inherits i ON c.oid = i.inhparent
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in:387:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-388-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-397-      JOIN pg_catalog.pg_inherits i ON c.oid = i.inhparent
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in:398:     WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap--0.97.0--0.98.0.sql.in-399-       AND c.relkind = 'p'
##############################################
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in-159-      FROM tap_funky
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in:160:     WHERE schema = $1
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in-161-       AND name   = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in-166-RETURNS BOOLEAN AS $$
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in:167:    SELECT kind = 'a' FROM tap_funky WHERE schema = $1 AND name = $2
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in-168-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in-173-      FROM tap_funky
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in:174:     WHERE name = $1
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in-175-       AND args = array_to_string($2, ',')
##############################################
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in-180-RETURNS BOOLEAN AS $$
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in:181:    SELECT kind = 'a' FROM tap_funky WHERE name = $1 AND is_visible;
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in-182-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in-191-              JOIN pg_catalog.pg_constraint x ON c.oid = x.conrelid
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in:192:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.98.0--0.99.0.sql.in-193-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-23-              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:24:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-25-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-37-              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:38:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-39-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-60-              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:61:             WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-62-               AND n.nspname NOT IN ('pg_catalog', 'information_schema')
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-97-              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:98:             WHERE pn.nspname = $1
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-99-               AND pc.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-113-              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:114:             WHERE pn.nspname = $1
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-115-               AND pc.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-138-              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:139:             WHERE pc.relname = $1
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-140-               AND pp.polname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-154-              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:155:             WHERE pc.relname = $1
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-156-               AND pp.polname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-184-      JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:185:     WHERE pn.nspname = $1
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-186-       AND pc.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-220-      JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:221:     WHERE pc.relname = $1
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-222-       AND pp.polname = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-254-          FROM tap_funky
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:255:         WHERE schema = $1
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-256-           AND name   = $2
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-265-          FROM tap_funky
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:266:         WHERE name = $1
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-267-           AND args = _funkargs($2)
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-380-                ON c1.relnamespace = n1.oid
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:381:             WHERE c1.relname = $2
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-382-               AND n1.nspname = $1
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-395-                ON c1.relnamespace = n1.oid
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:396:             WHERE c1.relname = $4
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-397-               AND n1.nspname = $3
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-402-          FROM inheritance_chain
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:403:         WHERE inheritance_level = COALESCE($5, inheritance_level)
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-404-           AND descendent_id = (
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-408-                    ON c1.relnamespace = n1.oid
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:409:                 WHERE c1.relname = $4
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-410-                   AND n1.nspname = $3
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-429-                ON c1.relnamespace = n1.oid
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:430:             WHERE c1.relname = $1
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-431-               AND pg_catalog.pg_table_is_visible( c1.oid )
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-444-                ON c1.relnamespace = n1.oid
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:445:             WHERE c1.relname = $2
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-446-               AND pg_catalog.pg_table_is_visible( c1.oid )
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-451-          FROM inheritance_chain
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:452:         WHERE inheritance_level = COALESCE($3, inheritance_level)
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-453-           AND descendent_id = (
##############################################
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-457-                    ON c1.relnamespace = n1.oid
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in:458:                 WHERE c1.relname = $2
pgtap-1.1.0/sql/pgtap--0.99.0--1.0.0.sql.in-459-                   AND pg_catalog.pg_table_is_visible( c1.oid )
##############################################
pgtap-1.1.0/sql/pgtap--1.0.0--1.1.0.sql-31-              JOIN pg_catalog.pg_attribute a ON c.oid = a.attrelid
pgtap-1.1.0/sql/pgtap--1.0.0--1.1.0.sql:32:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--1.0.0--1.1.0.sql-33-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap--1.0.0--1.1.0.sql-112-      JOIN pg_catalog.pg_constraint x  ON c.oid = x.conrelid
pgtap-1.1.0/sql/pgtap--1.0.0--1.1.0.sql:113:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap--1.0.0--1.1.0.sql-114-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-75-BEGIN
pgtap-1.1.0/sql/pgtap.sql.in:76:    EXECUTE 'SELECT value FROM __tcache__ WHERE label = ' || quote_literal($1) || ' LIMIT 1' INTO ret;
pgtap-1.1.0/sql/pgtap.sql.in-77-    RETURN ret;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-110-BEGIN
pgtap-1.1.0/sql/pgtap.sql.in:111:    EXECUTE 'SELECT note FROM __tcache__ WHERE label = ' || quote_literal($1) || ' LIMIT 1' INTO ret;
pgtap-1.1.0/sql/pgtap.sql.in-112-    RETURN ret;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-120-BEGIN
pgtap-1.1.0/sql/pgtap.sql.in:121:    EXECUTE 'SELECT note FROM __tcache__ WHERE id = ' || $1 || ' LIMIT 1' INTO ret;
pgtap-1.1.0/sql/pgtap.sql.in-122-    RETURN ret;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-132-        || CASE WHEN $3 IS NULL THEN '' ELSE ', note = ' || quote_literal($3) END
pgtap-1.1.0/sql/pgtap.sql.in:133:        || ' WHERE label = ' || quote_literal($1);
pgtap-1.1.0/sql/pgtap.sql.in-134-    GET DIAGNOSTICS rcount = ROW_COUNT;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-150-    EXECUTE 'UPDATE __tcache__ SET value = ' || $2
pgtap-1.1.0/sql/pgtap.sql.in:151:        || ' WHERE id = ' || $1;
pgtap-1.1.0/sql/pgtap.sql.in-152-    RETURN $2;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-928-          JOIN pg_catalog.pg_class c ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:929:         WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-930-           AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-985-          JOIN pg_catalog.pg_class c ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:986:         WHERE c.relkind = ANY($1)
pgtap-1.1.0/sql/pgtap.sql.in-987-           AND n.nspname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-996-          FROM pg_catalog.pg_class c
pgtap-1.1.0/sql/pgtap.sql.in:997:         WHERE c.relkind = ANY($1)
pgtap-1.1.0/sql/pgtap.sql.in-998-           AND pg_catalog.pg_table_is_visible(c.oid)
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-1244-          JOIN pg_catalog.pg_attribute a ON c.oid = a.attrelid
pgtap-1.1.0/sql/pgtap.sql.in:1245:         WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-1246-           AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-1258-          JOIN pg_catalog.pg_attribute a ON c.oid = a.attrelid
pgtap-1.1.0/sql/pgtap.sql.in:1259:         WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-1260-           AND pg_catalog.pg_table_is_visible(c.oid)
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-1323-              JOIN pg_catalog.pg_attribute a ON c.oid = a.attrelid
pgtap-1.1.0/sql/pgtap.sql.in:1324:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-1325-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-1404-      JOIN pg_catalog.pg_attribute a ON c.oid = a.attrelid
pgtap-1.1.0/sql/pgtap.sql.in:1405:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-1406-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-1435-      JOIN pg_catalog.pg_namespace tn ON t.typnamespace = tn.oid
pgtap-1.1.0/sql/pgtap.sql.in:1436:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-1437-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-1559-      JOIN pg_catalog.pg_attribute a ON c.oid = a.attrelid
pgtap-1.1.0/sql/pgtap.sql.in:1560:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-1561-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-1571-      JOIN pg_catalog.pg_attribute a ON c.oid = a.attrelid
pgtap-1.1.0/sql/pgtap.sql.in:1572:     WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-1573-       AND a.attnum > 0
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-1777-              JOIN pg_catalog.pg_constraint x ON c.oid = x.conrelid
pgtap-1.1.0/sql/pgtap.sql.in:1778:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-1779-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-1848-          JOIN generate_series(1, array_upper($2, 1)) s(i) ON a.attnum = $2[i]
pgtap-1.1.0/sql/pgtap.sql.in:1849:         WHERE attrelid = $1
pgtap-1.1.0/sql/pgtap.sql.in-1850-         ORDER BY i
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-1941-      JOIN pg_catalog.pg_constraint x  ON c.oid = x.conrelid
pgtap-1.1.0/sql/pgtap.sql.in:1942:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-1943-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2084-           FROM pg_all_foreign_keys
pgtap-1.1.0/sql/pgtap.sql.in:2085:          WHERE fk_schema_name    = $1
pgtap-1.1.0/sql/pgtap.sql.in-2086-            AND quote_ident(fk_table_name)     = quote_ident($2)
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2095-           FROM pg_all_foreign_keys
pgtap-1.1.0/sql/pgtap.sql.in:2096:          WHERE quote_ident(fk_table_name)     = quote_ident($1)
pgtap-1.1.0/sql/pgtap.sql.in-2097-            AND pg_catalog.pg_table_is_visible(fk_table_oid)
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2115-          FROM pg_all_foreign_keys
pgtap-1.1.0/sql/pgtap.sql.in:2116:         WHERE fk_schema_name = $1
pgtap-1.1.0/sql/pgtap.sql.in-2117-           AND fk_table_name  = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2148-          FROM pg_all_foreign_keys
pgtap-1.1.0/sql/pgtap.sql.in:2149:         WHERE fk_table_name  = $1
pgtap-1.1.0/sql/pgtap.sql.in-2150-         ORDER BY fk_columns
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2404-      FROM pg_all_foreign_keys
pgtap-1.1.0/sql/pgtap.sql.in:2405:      WHERE fk_schema_name = $1
pgtap-1.1.0/sql/pgtap.sql.in-2406-        AND fk_table_name  = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2431-      FROM pg_all_foreign_keys
pgtap-1.1.0/sql/pgtap.sql.in:2432:     WHERE fk_table_name = $1
pgtap-1.1.0/sql/pgtap.sql.in-2433-       AND fk_columns    = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2546-          FROM tap_funky
pgtap-1.1.0/sql/pgtap.sql.in:2547:         WHERE schema = $1
pgtap-1.1.0/sql/pgtap.sql.in-2548-           AND name   = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2554-RETURNS BOOLEAN AS $$
pgtap-1.1.0/sql/pgtap.sql.in:2555:    SELECT EXISTS( SELECT TRUE FROM tap_funky WHERE schema = $1 AND name = $2 );
pgtap-1.1.0/sql/pgtap.sql.in-2556-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2562-          FROM tap_funky
pgtap-1.1.0/sql/pgtap.sql.in:2563:         WHERE name = $1
pgtap-1.1.0/sql/pgtap.sql.in-2564-           AND args = _funkargs($2)
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2570-RETURNS BOOLEAN AS $$
pgtap-1.1.0/sql/pgtap.sql.in:2571:    SELECT EXISTS( SELECT TRUE FROM tap_funky WHERE name = $1 AND is_visible);
pgtap-1.1.0/sql/pgtap.sql.in-2572-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2774-            ON x.indkey[s.i] IS NOT NULL
pgtap-1.1.0/sql/pgtap.sql.in:2775:         WHERE ct.relname = $2
pgtap-1.1.0/sql/pgtap.sql.in-2776-           AND ci.relname = $3
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2790-            ON x.indkey[s.i] IS NOT NULL
pgtap-1.1.0/sql/pgtap.sql.in:2791:         WHERE ct.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-2792-           AND ci.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2805-      JOIN pg_catalog.pg_namespace n ON n.oid = ct.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:2806:     WHERE n.nspname  = $1
pgtap-1.1.0/sql/pgtap.sql.in-2807-       AND ct.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2818-      JOIN pg_catalog.pg_class ci    ON ci.oid = x.indexrelid
pgtap-1.1.0/sql/pgtap.sql.in:2819:     WHERE ct.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-2820-       AND ci.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2896-          FROM pg_catalog.pg_namespace
pgtap-1.1.0/sql/pgtap.sql.in:2897:          WHERE nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-2898-    );
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-2983-          JOIN pg_catalog.pg_namespace n ON n.oid = ct.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:2984:         WHERE ($1 IS NULL OR n.nspname  = $1)
pgtap-1.1.0/sql/pgtap.sql.in-2985-           AND ct.relname = $2
pgtap-1.1.0/sql/pgtap.sql.in-2986-    ) icols
pgtap-1.1.0/sql/pgtap.sql.in:2987:    WHERE cols = $3 )
pgtap-1.1.0/sql/pgtap.sql.in-2988-$$ LANGUAGE sql;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3055-      JOIN pg_catalog.pg_namespace n ON n.oid = ct.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:3056:     WHERE ct.relname = $2
pgtap-1.1.0/sql/pgtap.sql.in-3057-       AND ci.relname = $3
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3083-      JOIN pg_catalog.pg_class ci ON ci.oid = x.indexrelid
pgtap-1.1.0/sql/pgtap.sql.in:3084:     WHERE ct.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3085-       AND ci.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3105-      JOIN pg_catalog.pg_class ct ON ct.oid = x.indrelid
pgtap-1.1.0/sql/pgtap.sql.in:3106:     WHERE ci.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3107-       AND pg_catalog.pg_table_is_visible(ct.oid)
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3127-      JOIN pg_catalog.pg_namespace n ON n.oid = ct.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:3128:     WHERE ct.relname = $2
pgtap-1.1.0/sql/pgtap.sql.in-3129-       AND ci.relname = $3
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3155-      JOIN pg_catalog.pg_class ci ON ci.oid = x.indexrelid
pgtap-1.1.0/sql/pgtap.sql.in:3156:     WHERE ct.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3157-       AND ci.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3177-      JOIN pg_catalog.pg_class ct ON ct.oid = x.indrelid
pgtap-1.1.0/sql/pgtap.sql.in:3178:     WHERE ci.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3179-       AND pg_catalog.pg_table_is_visible(ct.oid)
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3199-      JOIN pg_catalog.pg_namespace n ON n.oid = ct.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:3200:     WHERE ct.relname = $2
pgtap-1.1.0/sql/pgtap.sql.in-3201-       AND ci.relname = $3
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3228-      JOIN pg_catalog.pg_class ci ON ci.oid = x.indexrelid
pgtap-1.1.0/sql/pgtap.sql.in:3229:     WHERE ct.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3230-       AND ci.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3248-      JOIN pg_catalog.pg_class ci ON ci.oid = x.indexrelid
pgtap-1.1.0/sql/pgtap.sql.in:3249:     WHERE ci.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3250-      INTO res;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3270-      JOIN pg_catalog.pg_am am       ON ci.relam = am.oid
pgtap-1.1.0/sql/pgtap.sql.in:3271:     WHERE ct.relname = $2
pgtap-1.1.0/sql/pgtap.sql.in-3272-       AND ci.relname = $3
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3299-      JOIN pg_catalog.pg_am am    ON ci.relam = am.oid
pgtap-1.1.0/sql/pgtap.sql.in:3300:     WHERE ct.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3301-       AND ci.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3320-      JOIN pg_catalog.pg_am am    ON ci.relam = am.oid
pgtap-1.1.0/sql/pgtap.sql.in:3321:     WHERE ci.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3322-      INTO aname;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3337-          JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:3338:         WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3339-           AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3349-          JOIN pg_catalog.pg_class c     ON c.oid = t.tgrelid
pgtap-1.1.0/sql/pgtap.sql.in:3350:         WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3351-           AND t.tgname  = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3421-      JOIN pg_catalog.pg_namespace ni ON ni.oid = p.pronamespace
pgtap-1.1.0/sql/pgtap.sql.in:3422:     WHERE nt.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3423-       AND ct.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3449-      JOIN pg_catalog.pg_proc p   ON p.oid = t.tgfoid
pgtap-1.1.0/sql/pgtap.sql.in:3450:     WHERE ct.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3451-       AND t.tgname   = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3474-              FROM pg_catalog.pg_namespace
pgtap-1.1.0/sql/pgtap.sql.in:3475:             WHERE nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3476-        ), $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3492-              FROM pg_catalog.pg_namespace
pgtap-1.1.0/sql/pgtap.sql.in:3493:             WHERE nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3494-        ), $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3512-                  FROM pg_catalog.pg_tablespace
pgtap-1.1.0/sql/pgtap.sql.in:3513:                 WHERE spcname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3514-                   AND pg_tablespace_location(oid) = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3521-                  FROM pg_catalog.pg_tablespace
pgtap-1.1.0/sql/pgtap.sql.in:3522:                 WHERE spcname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3523-                   AND spclocation = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3536-              FROM pg_catalog.pg_tablespace
pgtap-1.1.0/sql/pgtap.sql.in:3537:             WHERE spcname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3538-        ), $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3554-              FROM pg_catalog.pg_tablespace
pgtap-1.1.0/sql/pgtap.sql.in:3555:             WHERE spcname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3556-        ), $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3796-          FROM pg_catalog.pg_roles
pgtap-1.1.0/sql/pgtap.sql.in:3797:         WHERE rolname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3798-    );
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3826-RETURNS BOOLEAN AS $$
pgtap-1.1.0/sql/pgtap.sql.in:3827:    SELECT EXISTS( SELECT true FROM pg_catalog.pg_user WHERE usename = $1);
pgtap-1.1.0/sql/pgtap.sql.in-3828-$$ LANGUAGE sql STRICT;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3857-      FROM pg_catalog.pg_roles
pgtap-1.1.0/sql/pgtap.sql.in:3858:     WHERE rolname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3859-$$ LANGUAGE sql STRICT;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3903-          FROM pg_catalog.pg_group
pgtap-1.1.0/sql/pgtap.sql.in:3904:         WHERE groname = $1
pgtap-1.1.0/sql/pgtap.sql.in-3905-    );
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-3937-          JOIN pg_catalog.pg_roles r ON m.roleid = r.oid
pgtap-1.1.0/sql/pgtap.sql.in:3938:         WHERE r.rolname =  $1
pgtap-1.1.0/sql/pgtap.sql.in-3939-    );
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4183-         JOIN pg_catalog.pg_namespace n ON o.oprnamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:4184:        WHERE n.nspname = $2
pgtap-1.1.0/sql/pgtap.sql.in-4185-          AND o.oprname = $3
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4460-          JOIN pg_catalog.pg_class c ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:4461:         WHERE c.relkind = ANY($1)
pgtap-1.1.0/sql/pgtap.sql.in-4462-           AND n.nspname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4504-          JOIN pg_catalog.pg_class c ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:4505:         WHERE c.relkind = ANY($1)
pgtap-1.1.0/sql/pgtap.sql.in-4506-           AND n.nspname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4630-        ARRAY(
pgtap-1.1.0/sql/pgtap.sql.in:4631:            SELECT name FROM tap_funky WHERE schema = $1
pgtap-1.1.0/sql/pgtap.sql.in-4632-            EXCEPT
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4639-            EXCEPT
pgtap-1.1.0/sql/pgtap.sql.in:4640:            SELECT name FROM tap_funky WHERE schema = $1
pgtap-1.1.0/sql/pgtap.sql.in-4641-        ),
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4691-              JOIN pg_catalog.pg_namespace n ON n.oid = ct.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:4692:             WHERE ct.relname = $2
pgtap-1.1.0/sql/pgtap.sql.in-4693-               AND n.nspname  = $1
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4706-              JOIN pg_catalog.pg_namespace n ON n.oid = ct.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:4707:             WHERE ct.relname = $2
pgtap-1.1.0/sql/pgtap.sql.in-4708-               AND n.nspname  = $1
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4730-              JOIN pg_catalog.pg_namespace n ON n.oid = ct.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:4731:             WHERE ct.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-4732-               AND pg_catalog.pg_table_is_visible(ct.oid)
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4746-              JOIN pg_catalog.pg_namespace n ON n.oid = ct.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:4747:             WHERE ct.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-4748-               AND pg_catalog.pg_table_is_visible(ct.oid)
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4851-RETURNS BOOLEAN AS $$
pgtap-1.1.0/sql/pgtap.sql.in:4852:    SELECT lanpltrusted FROM pg_catalog.pg_language WHERE lanname = $1;
pgtap-1.1.0/sql/pgtap.sql.in-4853-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4903-          JOIN pg_catalog.pg_namespace n ON oc.opcnamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:4904:         WHERE n.nspname  = $1
pgtap-1.1.0/sql/pgtap.sql.in-4905-           AND oc.opcname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4913-          FROM pg_catalog.pg_opclass oc
pgtap-1.1.0/sql/pgtap.sql.in:4914:         WHERE oc.opcname = $1
pgtap-1.1.0/sql/pgtap.sql.in-4915-           AND pg_opclass_is_visible(oid)
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4975-              JOIN pg_catalog.pg_namespace n ON oc.opcnamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:4976:             WHERE n.nspname  = $1
pgtap-1.1.0/sql/pgtap.sql.in-4977-            EXCEPT
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-4987-              JOIN pg_catalog.pg_namespace n ON oc.opcnamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:4988:             WHERE n.nspname  = $1
pgtap-1.1.0/sql/pgtap.sql.in-4989-        ),
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5044-              JOIN pg_catalog.pg_namespace n ON c.relnamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:5045:             WHERE c.relname = $2
pgtap-1.1.0/sql/pgtap.sql.in-5046-               AND n.nspname = $1
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5058-              JOIN pg_catalog.pg_namespace n ON c.relnamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:5059:             WHERE c.relname = $2
pgtap-1.1.0/sql/pgtap.sql.in-5060-               AND n.nspname = $1
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5081-              JOIN pg_catalog.pg_namespace n ON c.relnamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:5082:             WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-5083-               AND n.nspname NOT IN ('pg_catalog', 'information_schema')
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5116-      JOIN pg_catalog.pg_namespace n ON c.relnamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:5117:     WHERE r.rulename = $3
pgtap-1.1.0/sql/pgtap.sql.in-5118-       AND c.relname  = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5126-      JOIN pg_catalog.pg_class c     ON c.oid = r.ev_class
pgtap-1.1.0/sql/pgtap.sql.in:5127:     WHERE r.rulename = $2
pgtap-1.1.0/sql/pgtap.sql.in-5128-       AND c.relname  = $1
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5243-      JOIN pg_catalog.pg_namespace n ON c.relnamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:5244:     WHERE r.rulename = $3
pgtap-1.1.0/sql/pgtap.sql.in-5245-       AND c.relname  = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5253-      JOIN pg_catalog.pg_class c     ON c.oid = r.ev_class
pgtap-1.1.0/sql/pgtap.sql.in:5254:     WHERE r.rulename = $2
pgtap-1.1.0/sql/pgtap.sql.in-5255-       AND c.relname  = $1
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5360-      JOIN pg_catalog.pg_language l ON f.langoid = l.oid
pgtap-1.1.0/sql/pgtap.sql.in:5361:     WHERE f.schema = $1
pgtap-1.1.0/sql/pgtap.sql.in-5362-       and f.name   = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5370-      JOIN pg_catalog.pg_language l ON f.langoid = l.oid
pgtap-1.1.0/sql/pgtap.sql.in:5371:     WHERE f.schema = $1
pgtap-1.1.0/sql/pgtap.sql.in-5372-       and f.name   = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5379-      JOIN pg_catalog.pg_language l ON f.langoid = l.oid
pgtap-1.1.0/sql/pgtap.sql.in:5380:     WHERE f.name = $1
pgtap-1.1.0/sql/pgtap.sql.in-5381-       AND f.args = array_to_string($2, ',')
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5389-      JOIN pg_catalog.pg_language l ON f.langoid = l.oid
pgtap-1.1.0/sql/pgtap.sql.in:5390:     WHERE f.name = $1
pgtap-1.1.0/sql/pgtap.sql.in-5391-       AND f.is_visible;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5461-      FROM tap_funky
pgtap-1.1.0/sql/pgtap.sql.in:5462:     WHERE schema = $1
pgtap-1.1.0/sql/pgtap.sql.in-5463-       AND name   = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5468-RETURNS TEXT AS $$
pgtap-1.1.0/sql/pgtap.sql.in:5469:    SELECT returns FROM tap_funky WHERE schema = $1 AND name = $2
pgtap-1.1.0/sql/pgtap.sql.in-5470-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5475-      FROM tap_funky
pgtap-1.1.0/sql/pgtap.sql.in:5476:     WHERE name = $1
pgtap-1.1.0/sql/pgtap.sql.in-5477-       AND args = array_to_string($2, ',')
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5482-RETURNS TEXT AS $$
pgtap-1.1.0/sql/pgtap.sql.in:5483:    SELECT returns FROM tap_funky WHERE name = $1 AND is_visible;
pgtap-1.1.0/sql/pgtap.sql.in-5484-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5552-      FROM tap_funky
pgtap-1.1.0/sql/pgtap.sql.in:5553:     WHERE schema = $1
pgtap-1.1.0/sql/pgtap.sql.in-5554-       AND name   = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5559-RETURNS BOOLEAN AS $$
pgtap-1.1.0/sql/pgtap.sql.in:5560:    SELECT is_definer FROM tap_funky WHERE schema = $1 AND name = $2
pgtap-1.1.0/sql/pgtap.sql.in-5561-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5566-      FROM tap_funky
pgtap-1.1.0/sql/pgtap.sql.in:5567:     WHERE name = $1
pgtap-1.1.0/sql/pgtap.sql.in-5568-       AND args = array_to_string($2, ',')
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5573-RETURNS BOOLEAN AS $$
pgtap-1.1.0/sql/pgtap.sql.in:5574:    SELECT is_definer FROM tap_funky WHERE name = $1 AND is_visible;
pgtap-1.1.0/sql/pgtap.sql.in-5575-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5698-      FROM tap_funky
pgtap-1.1.0/sql/pgtap.sql.in:5699:     WHERE schema = $1
pgtap-1.1.0/sql/pgtap.sql.in-5700-       AND name   = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5705-RETURNS BOOLEAN AS $$
pgtap-1.1.0/sql/pgtap.sql.in:5706:    SELECT kind = 'a' FROM tap_funky WHERE schema = $1 AND name = $2
pgtap-1.1.0/sql/pgtap.sql.in-5707-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5712-      FROM tap_funky
pgtap-1.1.0/sql/pgtap.sql.in:5713:     WHERE name = $1
pgtap-1.1.0/sql/pgtap.sql.in-5714-       AND args = array_to_string($2, ',')
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5719-RETURNS BOOLEAN AS $$
pgtap-1.1.0/sql/pgtap.sql.in:5720:    SELECT kind = 'a' FROM tap_funky WHERE name = $1 AND is_visible;
pgtap-1.1.0/sql/pgtap.sql.in-5721-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5844-      FROM tap_funky
pgtap-1.1.0/sql/pgtap.sql.in:5845:     WHERE schema = $1
pgtap-1.1.0/sql/pgtap.sql.in-5846-       AND name   = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5851-RETURNS BOOLEAN AS $$
pgtap-1.1.0/sql/pgtap.sql.in:5852:    SELECT is_strict FROM tap_funky WHERE schema = $1 AND name = $2
pgtap-1.1.0/sql/pgtap.sql.in-5853-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5858-      FROM tap_funky
pgtap-1.1.0/sql/pgtap.sql.in:5859:     WHERE name = $1
pgtap-1.1.0/sql/pgtap.sql.in-5860-       AND args = array_to_string($2, ',')
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-5865-RETURNS BOOLEAN AS $$
pgtap-1.1.0/sql/pgtap.sql.in:5866:    SELECT is_strict FROM tap_funky WHERE name = $1 AND is_visible;
pgtap-1.1.0/sql/pgtap.sql.in-5867-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-6004-      FROM tap_funky f
pgtap-1.1.0/sql/pgtap.sql.in:6005:     WHERE f.schema = $1
pgtap-1.1.0/sql/pgtap.sql.in-6006-       and f.name   = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-6012-    SELECT _expand_vol(volatility) FROM tap_funky f
pgtap-1.1.0/sql/pgtap.sql.in:6013:     WHERE f.schema = $1 and f.name = $2
pgtap-1.1.0/sql/pgtap.sql.in-6014-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-6019-      FROM tap_funky f
pgtap-1.1.0/sql/pgtap.sql.in:6020:     WHERE f.name = $1
pgtap-1.1.0/sql/pgtap.sql.in-6021-       AND f.args = array_to_string($2, ',')
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-6027-    SELECT _expand_vol(volatility) FROM tap_funky f
pgtap-1.1.0/sql/pgtap.sql.in:6028:     WHERE f.name = $1 AND f.is_visible;
pgtap-1.1.0/sql/pgtap.sql.in-6029-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-6222-          JOIN pg_catalog.pg_namespace n ON p.pronamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:6223:         WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-6224-           AND p.proname ~ $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-6530-          JOIN pg_catalog.pg_class c ON a.attrelid = c.oid
pgtap-1.1.0/sql/pgtap.sql.in:6531:         WHERE c.oid = ('pg_temp.' || $1)::pg_catalog.regclass
pgtap-1.1.0/sql/pgtap.sql.in-6532-           AND attnum > 0
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-7518-         JOIN pg_catalog.pg_type t on n.oid = t.typnamespace
pgtap-1.1.0/sql/pgtap.sql.in:7519:        WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-7520-          AND t.typname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-7528-         FROM pg_catalog.pg_type t
pgtap-1.1.0/sql/pgtap.sql.in:7529:        WHERE t.typname = $1
pgtap-1.1.0/sql/pgtap.sql.in-7530-          AND pg_catalog.pg_type_is_visible(t.oid)
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-7749-              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:7750:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-7751-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-7764-              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:7765:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-7766-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-7788-              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:7789:             WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-7790-               AND n.nspname NOT IN ('pg_catalog', 'information_schema')
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-7891-              JOIN pg_catalog.pg_namespace n ON o.oprnamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:7892:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-7893-            EXCEPT
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-7903-              JOIN pg_catalog.pg_namespace n ON o.oprnamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:7904:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-7905-        ),
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-7960-              JOIN pg_catalog.pg_attribute a ON c.oid = a.attrelid
pgtap-1.1.0/sql/pgtap.sql.in:7961:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-7962-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-7976-              JOIN pg_catalog.pg_attribute a ON c.oid = a.attrelid
pgtap-1.1.0/sql/pgtap.sql.in:7977:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-7978-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8039-      FROM pg_catalog.pg_database
pgtap-1.1.0/sql/pgtap.sql.in:8040:     WHERE datname = $1;
pgtap-1.1.0/sql/pgtap.sql.in-8041-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8073-      FROM pg_catalog.pg_namespace
pgtap-1.1.0/sql/pgtap.sql.in:8074:     WHERE nspname = $1;
pgtap-1.1.0/sql/pgtap.sql.in-8075-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8107-      JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:8108:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-8109-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8115-      FROM pg_catalog.pg_class c
pgtap-1.1.0/sql/pgtap.sql.in:8116:     WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-8117-       AND pg_catalog.pg_table_is_visible(c.oid)
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8176-      JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:8177:     WHERE c.relkind = ANY($1)
pgtap-1.1.0/sql/pgtap.sql.in-8178-       AND n.nspname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8185-      FROM pg_catalog.pg_class c
pgtap-1.1.0/sql/pgtap.sql.in:8186:     WHERE c.relkind = ANY($1)
pgtap-1.1.0/sql/pgtap.sql.in-8187-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8464-      FROM tap_funky
pgtap-1.1.0/sql/pgtap.sql.in:8465:     WHERE schema = $1
pgtap-1.1.0/sql/pgtap.sql.in-8466-       AND name   = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8473-      FROM tap_funky
pgtap-1.1.0/sql/pgtap.sql.in:8474:     WHERE name = $1
pgtap-1.1.0/sql/pgtap.sql.in-8475-       AND args = array_to_string($2, ',')
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8539-      FROM pg_catalog.pg_tablespace
pgtap-1.1.0/sql/pgtap.sql.in:8540:     WHERE spcname = $1;
pgtap-1.1.0/sql/pgtap.sql.in-8541-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8575-      JOIN pg_catalog.pg_namespace n ON n.oid = ct.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:8576:     WHERE n.nspname  = $1
pgtap-1.1.0/sql/pgtap.sql.in-8577-       AND ct.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8586-      JOIN pg_catalog.pg_class ci    ON ci.oid = x.indexrelid
pgtap-1.1.0/sql/pgtap.sql.in:8587:     WHERE ct.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-8588-       AND ci.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8652-      FROM pg_catalog.pg_language
pgtap-1.1.0/sql/pgtap.sql.in:8653:     WHERE lanname = $1;
pgtap-1.1.0/sql/pgtap.sql.in-8654-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8686-      JOIN pg_catalog.pg_namespace n ON oc.opcnamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:8687:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-8688-       AND opcname   = $2;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8694-      FROM pg_catalog.pg_opclass
pgtap-1.1.0/sql/pgtap.sql.in:8695:     WHERE opcname = $1
pgtap-1.1.0/sql/pgtap.sql.in-8696-       AND pg_catalog.pg_opclass_is_visible(oid);
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8757-      JOIN pg_catalog.pg_namespace n ON n.oid = t.typnamespace
pgtap-1.1.0/sql/pgtap.sql.in:8758:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-8759-       AND t.typname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-8765-      FROM pg_catalog.pg_type
pgtap-1.1.0/sql/pgtap.sql.in:8766:     WHERE typname = $1
pgtap-1.1.0/sql/pgtap.sql.in-8767-       AND pg_catalog.pg_type_is_visible(oid)
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-9753-      JOIN pg_catalog.pg_extension e ON n.oid = e.extnamespace
pgtap-1.1.0/sql/pgtap.sql.in:9754:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-9755-$$ LANGUAGE SQL;
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-9805-          JOIN pg_catalog.pg_namespace n ON ex.extnamespace = n.oid
pgtap-1.1.0/sql/pgtap.sql.in:9806:         WHERE n.nspname  = $1
pgtap-1.1.0/sql/pgtap.sql.in-9807-           AND ex.extname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-9816-          FROM pg_catalog.pg_extension ex
pgtap-1.1.0/sql/pgtap.sql.in:9817:         WHERE ex.extname = $1
pgtap-1.1.0/sql/pgtap.sql.in-9818-    );
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-9948-          JOIN pg_catalog.pg_namespace pn ON pc.relnamespace = pn.oid
pgtap-1.1.0/sql/pgtap.sql.in:9949:         WHERE cn.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-9950-           AND cc.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-9965-          JOIN pg_catalog.pg_class pc ON i.inhparent = pc.oid
pgtap-1.1.0/sql/pgtap.sql.in:9966:         WHERE cc.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-9967-           AND cc.relispartition
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10012-      JOIN pg_catalog.pg_inherits i ON c.oid = i.inhparent
pgtap-1.1.0/sql/pgtap.sql.in:10013:     WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-10014-       AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10023-      JOIN pg_catalog.pg_inherits i ON c.oid = i.inhparent
pgtap-1.1.0/sql/pgtap.sql.in:10024:     WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-10025-       AND c.relkind = 'p'
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10096-              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:10097:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-10098-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10110-              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:10111:             WHERE n.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-10112-               AND c.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10133-              JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:10134:             WHERE c.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-10135-               AND n.nspname NOT IN ('pg_catalog', 'information_schema')
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10170-              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:10171:             WHERE pn.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-10172-               AND pc.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10186-              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:10187:             WHERE pn.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-10188-               AND pc.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10211-              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:10212:             WHERE pc.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-10213-               AND pp.polname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10227-              JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:10228:             WHERE pc.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-10229-               AND pp.polname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10257-      JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:10258:     WHERE pn.nspname = $1
pgtap-1.1.0/sql/pgtap.sql.in-10259-       AND pc.relname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10293-      JOIN pg_catalog.pg_namespace AS pn ON pn.oid = pc.relnamespace
pgtap-1.1.0/sql/pgtap.sql.in:10294:     WHERE pc.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-10295-       AND pp.polname = $2
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10423-                ON c1.relnamespace = n1.oid
pgtap-1.1.0/sql/pgtap.sql.in:10424:             WHERE c1.relname = $2
pgtap-1.1.0/sql/pgtap.sql.in-10425-               AND n1.nspname = $1
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10438-                ON c1.relnamespace = n1.oid
pgtap-1.1.0/sql/pgtap.sql.in:10439:             WHERE c1.relname = $4
pgtap-1.1.0/sql/pgtap.sql.in-10440-               AND n1.nspname = $3
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10445-          FROM inheritance_chain
pgtap-1.1.0/sql/pgtap.sql.in:10446:         WHERE inheritance_level = COALESCE($5, inheritance_level)
pgtap-1.1.0/sql/pgtap.sql.in-10447-           AND descendent_id = (
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10451-                    ON c1.relnamespace = n1.oid
pgtap-1.1.0/sql/pgtap.sql.in:10452:                 WHERE c1.relname = $4
pgtap-1.1.0/sql/pgtap.sql.in-10453-                   AND n1.nspname = $3
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10472-                ON c1.relnamespace = n1.oid
pgtap-1.1.0/sql/pgtap.sql.in:10473:             WHERE c1.relname = $1
pgtap-1.1.0/sql/pgtap.sql.in-10474-               AND pg_catalog.pg_table_is_visible( c1.oid )
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10487-                ON c1.relnamespace = n1.oid
pgtap-1.1.0/sql/pgtap.sql.in:10488:             WHERE c1.relname = $2
pgtap-1.1.0/sql/pgtap.sql.in-10489-               AND pg_catalog.pg_table_is_visible( c1.oid )
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10494-          FROM inheritance_chain
pgtap-1.1.0/sql/pgtap.sql.in:10495:         WHERE inheritance_level = COALESCE($3, inheritance_level)
pgtap-1.1.0/sql/pgtap.sql.in-10496-           AND descendent_id = (
##############################################
pgtap-1.1.0/sql/pgtap.sql.in-10500-                    ON c1.relnamespace = n1.oid
pgtap-1.1.0/sql/pgtap.sql.in:10501:                 WHERE c1.relname = $2
pgtap-1.1.0/sql/pgtap.sql.in-10502-                   AND pg_catalog.pg_table_is_visible( c1.oid )
##############################################
pgtap-1.1.0/test/test_MVU.sh-10-
pgtap-1.1.0/test/test_MVU.sh:11:BASEDIR=`dirname $0`
pgtap-1.1.0/test/test_MVU.sh-12-if ! . $BASEDIR/../tools/util.sh; then
##############################################
pgtap-1.1.0/tools/getos.sh-50-
pgtap-1.1.0/tools/getos.sh:51:myuname=`$uname -a 2>/dev/null`
pgtap-1.1.0/tools/getos.sh-52-$test -z "$myuname" && myuname=`hostname 2>/dev/null`
##############################################
pgtap-1.1.0/tools/getos.sh-66-$test -f /lynx.os && osname=lynxos
pgtap-1.1.0/tools/getos.sh:67:$test -f /unicos && osname=unicos && osvers=`$uname -r`
pgtap-1.1.0/tools/getos.sh:68:$test -f /unicosmk && osname=unicosmk && osvers=`$uname -r`
pgtap-1.1.0/tools/getos.sh:69:$test -f /unicosmk.ar && osname=unicosmk && osvers=`$uname -r`
pgtap-1.1.0/tools/getos.sh-70-$test -f /bin/mips && /bin/mips && osname=mips
##############################################
pgtap-1.1.0/tools/getos.sh-110-	i386*)
pgtap-1.1.0/tools/getos.sh:111:		tmp=`/bin/uname -X 2>/dev/null|awk '/3\.2v[45]/{ print $(NF) }'`
pgtap-1.1.0/tools/getos.sh-112-		if $test "$tmp" != "" -a "$3" = "3.2" -a -f '/etc/systemid'; then
##############################################
pgtap-1.1.0/tools/getos.sh-148-	bsd386) osname=bsd386
pgtap-1.1.0/tools/getos.sh:149:		osvers=`$uname -r`
pgtap-1.1.0/tools/getos.sh-150-		;;
##############################################
pgtap-1.1.0/tools/getos.sh-169-	dynixptx*) osname=dynixptx
pgtap-1.1.0/tools/getos.sh:170:		osvers=`echo "$4"|sed 's/^v//'`
pgtap-1.1.0/tools/getos.sh-171-		;;
##############################################
pgtap-1.1.0/tools/getos.sh-177-	hp*)	osname=hpux
pgtap-1.1.0/tools/getos.sh:178:		osvers=`echo "$3" | $sed 's,.*\.\([0-9]*\.[0-9]*\),\1,'`
pgtap-1.1.0/tools/getos.sh-179-		;;
##############################################
pgtap-1.1.0/tools/getos.sh-222-		case "$3" in
pgtap-1.1.0/tools/getos.sh:223:		5*) osvers=`echo $3 | $sed 's/^5/2/g'` ;;
pgtap-1.1.0/tools/getos.sh-224-		*)	osvers="$3" ;;
##############################################
pgtap-1.1.0/tools/getos.sh-229-		5*) osname=solaris
pgtap-1.1.0/tools/getos.sh:230:			osvers=`echo $3 | $sed 's/^5/2/g'` ;;
pgtap-1.1.0/tools/getos.sh-231-		*)	osvers="$3" ;;
##############################################
pgtap-1.1.0/tools/getos.sh-248-				osname=dec_osf
pgtap-1.1.0/tools/getos.sh:249:				osvers=`sizer -v | awk -FUNIX '{print $2}' | awk '{print $1}' |  tr '[A-Z]' '[a-z]' | sed 's/^[xvt]//'`
pgtap-1.1.0/tools/getos.sh-250-				case "$osvers" in
pgtap-1.1.0/tools/getos.sh-251-				[1-9].[0-9]*) ;;
pgtap-1.1.0/tools/getos.sh:252:				*) osvers=`echo "$3" | sed 's/^[xvt]//'` ;;
pgtap-1.1.0/tools/getos.sh-253-				esac
##############################################
pgtap-1.1.0/tools/getos.sh-282-				if test -f /stand/boot ; then
pgtap-1.1.0/tools/getos.sh:283:					eval `grep '^INITPROG=[a-z/0-9]*$' /stand/boot`
pgtap-1.1.0/tools/getos.sh-284-					if test -n "$INITPROG" -a -f "$INITPROG"; then
pgtap-1.1.0/tools/getos.sh:285:		isesix=`strings -a $INITPROG|grep 'ESIX SYSTEM V/386 Release 4.0'`
pgtap-1.1.0/tools/getos.sh-286-						if test -n "$isesix"; then
##############################################
pgtap-1.1.0/tools/getos.sh-295-				osname=sco
pgtap-1.1.0/tools/getos.sh:296:				set `echo $3 | $sed 's/\./ /g'` $4
pgtap-1.1.0/tools/getos.sh-297-				if $test -f $src/hints/sco_$1_$2_$3.sh; then
##############################################
pgtap-1.1.0/tools/getos.sh-339-    *)  hostarch=$osname
pgtap-1.1.0/tools/getos.sh:340:        osname=`echo $targetarch|sed 's,^[^-]*-,,'`
pgtap-1.1.0/tools/getos.sh-341-        osvers=''
##############################################
pgtap-1.1.0/tools/getos.sh-348-''|' ')
pgtap-1.1.0/tools/getos.sh:349:	file=`echo "${osname}_${osvers}" | $sed -e 's%\.%_%g' -e 's%_$%%'`
pgtap-1.1.0/tools/getos.sh-350-	: Also try without trailing minor version numbers.
pgtap-1.1.0/tools/getos.sh:351:	xfile=`echo $file | $sed -e 's%_[^_]*$%%'`
pgtap-1.1.0/tools/getos.sh:352:	xxfile=`echo $xfile | $sed -e 's%_[^_]*$%%'`
pgtap-1.1.0/tools/getos.sh:353:	xxxfile=`echo $xxfile | $sed -e 's%_[^_]*$%%'`
pgtap-1.1.0/tools/getos.sh:354:	xxxxfile=`echo $xxxfile | $sed -e 's%_[^_]*$%%'`
pgtap-1.1.0/tools/getos.sh-355-	case "$file" in
##############################################
pgtap-1.1.0/tools/getos.sh-387-*)
pgtap-1.1.0/tools/getos.sh:388:	dflt=`echo $hintfile | $sed 's/\.sh$//'`
pgtap-1.1.0/tools/getos.sh-389-	;;
##############################################
pgtap-1.1.0/tools/parallel_conn.sh-24-
pgtap-1.1.0/tools/parallel_conn.sh:25:if PARALLEL_CONN=`psql -d ${PGDATABASE:-postgres} -qtc "$COMMAND" 2> /dev/null`; then
pgtap-1.1.0/tools/parallel_conn.sh-26-    if [ $PARALLEL_CONN -ge 1 ] 2>/dev/null; then
##############################################
pgtap-1.1.0/tools/pg-travis-test.sh-15-
pgtap-1.1.0/tools/pg-travis-test.sh:16:BASEDIR=`dirname $0`
pgtap-1.1.0/tools/pg-travis-test.sh-17-if ! . $BASEDIR/util.sh; then
##############################################
pgtap-1.1.0/tools/util.sh-2-
pgtap-1.1.0/tools/util.sh:3:ME=`basename $0`
pgtap-1.1.0/tools/util.sh-4-
##############################################
pgtap-1.1.0/tools/util.sh-121-    local exists
pgtap-1.1.0/tools/util.sh:122:    exists=`psql -qtc "SELECT EXISTS( SELECT 1 FROM pg_database WHERE datname = '$dbname' )" postgres $@ | tr -d ' '`
pgtap-1.1.0/tools/util.sh-123-    if [ "$exists" == "t" ]; then
##############################################
pgtap-1.1.0/.pc/Makefile-doc/Makefile-82-$(info )
pgtap-1.1.0/.pc/Makefile-doc/Makefile:83:$(info GNUmake running against Postgres version $(VERSION), with pg_config located at $(shell dirname `which "$(PG_CONFIG)"`))
pgtap-1.1.0/.pc/Makefile-doc/Makefile-84-$(info )
##############################################
pgtap-1.1.0/.pc/Makefile-doc/Makefile-374-	@[ -n "$(SCHEDULE)" ]
pgtap-1.1.0/.pc/Makefile-doc/Makefile:375:	@[ "`cat $@ 2>/dev/null`" = "$(SCHEDULE)" ] || (echo "Schedule changed to $(SCHEDULE)"; echo "$(SCHEDULE)" > $@)
pgtap-1.1.0/.pc/Makefile-doc/Makefile-376-
##############################################
pgtap-1.1.0/.pc/Makefile-doc/Makefile-379-$(TB_DIR)/all_tests: $(TB_DIR)/
pgtap-1.1.0/.pc/Makefile-doc/Makefile:380:	@[ "`cat $@ 2>/dev/null`" = "$(ALL_TESTS)" ] || (echo "Rebuilding $@"; echo "$(ALL_TESTS)" > $@)
pgtap-1.1.0/.pc/Makefile-doc/Makefile-381-
##############################################
pgtap-1.1.0/.pc/Makefile-doc/Makefile-383-$(TB_DIR)/exclude_tests: $(TB_DIR)/ $(TB_DIR)/all_tests
pgtap-1.1.0/.pc/Makefile-doc/Makefile:384:	@[ "`cat $@ 2>/dev/null`" = "$(EXCLUDE_TEST)" ] || (echo "Rebuilding $@"; echo "$(EXCLUDE_TEST)" > $@)
pgtap-1.1.0/.pc/Makefile-doc/Makefile-385-
##############################################
pgtap-1.1.0/.pc/Makefile-doc/Makefile-396-$(TB_DIR)/run.sch: $(TB_DIR)/which_schedule $(GENERATED_SCHEDULES)
pgtap-1.1.0/.pc/Makefile-doc/Makefile:397:	cp `cat $<` $@
pgtap-1.1.0/.pc/Makefile-doc/Makefile-398-
##############################################
pgtap-1.1.0/.pc/pg13/Makefile-82-$(info )
pgtap-1.1.0/.pc/pg13/Makefile:83:$(info GNUmake running against Postgres version $(VERSION), with pg_config located at $(shell dirname `which "$(PG_CONFIG)"`))
pgtap-1.1.0/.pc/pg13/Makefile-84-$(info )
##############################################
pgtap-1.1.0/.pc/pg13/Makefile-372-	@[ -n "$(SCHEDULE)" ]
pgtap-1.1.0/.pc/pg13/Makefile:373:	@[ "`cat $@ 2>/dev/null`" = "$(SCHEDULE)" ] || (echo "Schedule changed to $(SCHEDULE)"; echo "$(SCHEDULE)" > $@)
pgtap-1.1.0/.pc/pg13/Makefile-374-
##############################################
pgtap-1.1.0/.pc/pg13/Makefile-377-$(TB_DIR)/all_tests: $(TB_DIR)/
pgtap-1.1.0/.pc/pg13/Makefile:378:	@[ "`cat $@ 2>/dev/null`" = "$(ALL_TESTS)" ] || (echo "Rebuilding $@"; echo "$(ALL_TESTS)" > $@)
pgtap-1.1.0/.pc/pg13/Makefile-379-
##############################################
pgtap-1.1.0/.pc/pg13/Makefile-381-$(TB_DIR)/exclude_tests: $(TB_DIR)/ $(TB_DIR)/all_tests
pgtap-1.1.0/.pc/pg13/Makefile:382:	@[ "`cat $@ 2>/dev/null`" = "$(EXCLUDE_TEST)" ] || (echo "Rebuilding $@"; echo "$(EXCLUDE_TEST)" > $@)
pgtap-1.1.0/.pc/pg13/Makefile-383-
##############################################
pgtap-1.1.0/.pc/pg13/Makefile-394-$(TB_DIR)/run.sch: $(TB_DIR)/which_schedule $(GENERATED_SCHEDULES)
pgtap-1.1.0/.pc/pg13/Makefile:395:	cp `cat $<` $@
pgtap-1.1.0/.pc/pg13/Makefile-396-
##############################################
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile-82-$(info )
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile:83:$(info GNUmake running against Postgres version $(VERSION), with pg_config located at $(shell dirname `which "$(PG_CONFIG)"`))
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile-84-$(info )
##############################################
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile-372-	@[ -n "$(SCHEDULE)" ]
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile:373:	@[ "`cat $@ 2>/dev/null`" = "$(SCHEDULE)" ] || (echo "Schedule changed to $(SCHEDULE)"; echo "$(SCHEDULE)" > $@)
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile-374-
##############################################
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile-377-$(TB_DIR)/all_tests: $(TB_DIR)/
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile:378:	@[ "`cat $@ 2>/dev/null`" = "$(ALL_TESTS)" ] || (echo "Rebuilding $@"; echo "$(ALL_TESTS)" > $@)
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile-379-
##############################################
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile-381-$(TB_DIR)/exclude_tests: $(TB_DIR)/ $(TB_DIR)/all_tests
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile:382:	@[ "`cat $@ 2>/dev/null`" = "$(EXCLUDE_TEST)" ] || (echo "Rebuilding $@"; echo "$(EXCLUDE_TEST)" > $@)
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile-383-
##############################################
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile-394-$(TB_DIR)/run.sch: $(TB_DIR)/which_schedule $(GENERATED_SCHEDULES)
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile:395:	cp `cat $<` $@
pgtap-1.1.0/.pc/no-destdir-for-installcheck/Makefile-396-
##############################################
pgtap-1.1.0/Makefile-82-$(info )
pgtap-1.1.0/Makefile:83:$(info GNUmake running against Postgres version $(VERSION), with pg_config located at $(shell dirname `which "$(PG_CONFIG)"`))
pgtap-1.1.0/Makefile-84-$(info )
##############################################
pgtap-1.1.0/Makefile-373-	@[ -n "$(SCHEDULE)" ]
pgtap-1.1.0/Makefile:374:	@[ "`cat $@ 2>/dev/null`" = "$(SCHEDULE)" ] || (echo "Schedule changed to $(SCHEDULE)"; echo "$(SCHEDULE)" > $@)
pgtap-1.1.0/Makefile-375-
##############################################
pgtap-1.1.0/Makefile-378-$(TB_DIR)/all_tests: $(TB_DIR)/
pgtap-1.1.0/Makefile:379:	@[ "`cat $@ 2>/dev/null`" = "$(ALL_TESTS)" ] || (echo "Rebuilding $@"; echo "$(ALL_TESTS)" > $@)
pgtap-1.1.0/Makefile-380-
##############################################
pgtap-1.1.0/Makefile-382-$(TB_DIR)/exclude_tests: $(TB_DIR)/ $(TB_DIR)/all_tests
pgtap-1.1.0/Makefile:383:	@[ "`cat $@ 2>/dev/null`" = "$(EXCLUDE_TEST)" ] || (echo "Rebuilding $@"; echo "$(EXCLUDE_TEST)" > $@)
pgtap-1.1.0/Makefile-384-
##############################################
pgtap-1.1.0/Makefile-395-$(TB_DIR)/run.sch: $(TB_DIR)/which_schedule $(GENERATED_SCHEDULES)
pgtap-1.1.0/Makefile:396:	cp `cat $<` $@
pgtap-1.1.0/Makefile-397-