--

-- temporarily disable fancy output, so view changes create less diff noise

\a\t

SELECT viewname, definition FROM pg_views WHERE schemaname <> 'information_schema' ORDER BY viewname;

SELECT viewname, definition FROM pg_views

WHERE schemaname IN ('pg_catalog', 'public')

ORDER BY viewname;

iexit| SELECT ih.name,

ih.thepath,

interpt_pp(ih.thepath, r.thepath) AS exit

(12 * emp.salary) AS annualsal

FROM emp;

SELECT tablename, rulename, definition FROM pg_rules

ORDER BY tablename, rulename;

WHERE schemaname IN ('pg_catalog', 'public')

ORDER BY tablename, rulename;

pg_settings|pg_settings_n|CREATE RULE pg_settings_n AS

ON UPDATE TO pg_catalog.pg_settings DO INSTEAD NOTHING;

pg_settings|pg_settings_u|CREATE RULE pg_settings_u AS

timestamp_tbl|f

timestamptz_tbl|f

timetz_tbl|f

tmp|f

varchar_tbl|f

view_base_table|t

-- restore normal output mode

ALTER SEQUENCE INSERT_SEQ RESTART WITH 4;

CREATE TABLE tmp (xd INT, yd TEXT, zd INT);

CREATETEMPTABLE tmp (xd INT, yd TEXT, zd INT);

INSERT INTO tmp VALUES (null, 'Y', null);

INSERT INTO tmp VALUES (5, '!check failed', null);

--

DELETE FROM INSERT_TBL;

ALTER SEQUENCE INSERT_SEQ RESTART WITH 4;

CREATE TABLE tmp (xd INT, yd TEXT, zd INT);

CREATETEMPTABLE tmp (xd INT, yd TEXT, zd INT);

INSERT INTO tmp VALUES (null, 'Y', null);

INSERT INTO tmp VALUES (5, '!check failed', null);

INSERT INTO tmp VALUES (null, 'try again', null);

# ----------

test: boolean char name varchar text int2 int4 int8 oid float4 float8 bit numeric txid uuid enum money rangetypes pg_lsn regproc

# Depends on things setup during char, varchar and text

test: strings

# Depends on int2, int4, int8, float4, float8

test: numerology

# ----------

# The second group of parallel tests

# strings depends on char, varchar and text

# numerology depends on int2, int4, int8, float4, float8

# ----------

test: point lseg line box path polygon circle date time timetz timestamp timestamptz interval inet macaddr macaddr8 tstypes fsm

test:strings numerologypoint lseg line box path polygon circle date time timetz timestamp timestamptz interval inet macaddr macaddr8 tstypes fsm

# ----------

# Another group of parallel tests

# ----------

# These four each depend on the previous one

# ----------

test: insert

test: insert_conflict

test: create_function_1

test: create_type

test: create_table

# execute two copy tests parallel, to check that copy itself

# is concurrent safe.

# ----------

test: copy copyselect copydml

test: copy copyselect copydml insert insert_conflict

# ----------

# More groups of parallel tests

# ----------

test: create_misc create_operator create_procedure

# These depend onthe above two

# These depend oncreate_misc and create_operator

test: create_index create_index_spgist create_view index_including index_including_gist

# ----------

# Another group of parallel tests

# ----------

test: create_aggregate create_function_3 create_cast constraints triggers inherit typed_table vacuum drop_if_exists updatable_views rolenames roleattributes create_am hash_func

test: create_aggregate create_function_3 create_cast constraints triggersselectinherit typed_table vacuum drop_if_exists updatable_views rolenames roleattributes create_am hash_func errors

# ----------

# sanity_check does a vacuum, affecting the sort order of SELECT *

# results. So it should not run parallel to other tests.

# ----------

test: sanity_check

# ----------

# Believe it or not, select creates a table, subsequent

# tests need.

# ----------

test: errors

test: select

ignore: random

# ----------

# Another group of parallel tests

# Note: the ignore: line does not run random, just mark it as ignorable

# ----------

test: select_into select_distinct select_distinct_on select_implicit select_having subselect union case join aggregates transactions random portals arrays btree_index hash_index update namespace prepared_xacts delete

ignore: random

test: select_into select_distinct select_distinct_on select_implicit select_having subselect union case join aggregates transactions random portals arrays btree_index hash_index update delete namespace prepared_xacts

# ----------

# Another group of parallel tests

# ----------

# Another group of parallel tests

# ----------

test: create_table_like alter_generic alter_operator miscpsqlasync dbsize misc_functions sysviews tsrf tidscan stats_ext

test: create_table_like alter_generic alter_operator misc async dbsize misc_functions sysviews tsrf tidscan

# rules cannot run concurrently with any test that creates a view

test: rules psql_crosstab amutils

# rules cannot run concurrently with any test that creates

# a view or rule in the public schema

test: rules psql psql_crosstab amutils stats_ext

# run by itself so it can run parallel workers

test: select_parallel

test: misc_sanity

test: comments

test: expressions

test: insert

test: insert_conflict

test: create_function_1

test: create_type

test: create_table

test: create_function_2

test: copy

test: copyselect

test: copydml

test: insert

test: insert_conflict

test: create_misc

test: create_operator

test: create_procedure

test: create_index

test: create_index_spgist

test: create_view

test: index_including

test: index_including_gist

test: create_view

test: create_aggregate

test: create_function_3

test: create_cast

test: constraints

test: triggers

test: select

test: inherit

test: typed_table

test: vacuum

test: roleattributes

test: create_am

test: hash_func

test: sanity_check

test: errors

test:select

test:sanity_check

test: select_into

test: select_distinct

test: select_distinct_on

test: alter_generic

test: alter_operator

test: misc

test: psql

test: async

test: dbsize

test: misc_functions

test: sysviews

test: tsrf

test: tidscan

test: stats_ext

test: rules

test: psql

test: psql_crosstab

test: amutils

test: stats_ext

test: select_parallel

test: write_parallel

test: publication

test: subscription

test: amutils

test: select_views

test: portals_p2

test: foreign_key

test: xmlmap

test: functional_deps

test: advisory_lock

test: indirect_toast

test: equivclass

test: json

test: jsonb

test: json_encoding

test: jsonpath

test: jsonpath_encoding

test: jsonb_jsonpath

test: indirect_toast

test: equivclass

test: plancache

test: limit

test: plpgsql

\a\t

SELECT viewname, definitionFROM pg_viewsWHERE schemaname<>'information_schema'ORDER BY viewname;

SELECT viewname, definitionFROM pg_views

WHERE schemanameIN ('pg_catalog','public')

ORDER BY viewname;

SELECT tablename, rulename, definitionFROM pg_rules

ORDER BY tablename, rulename;

WHERE schemanameIN ('pg_catalog','public')

ORDER BY tablename, rulename;

\a\t