2024-11-17 21:35:13.782 GMT postmaster[5140] LOG: starting PostgreSQL 18devel on x86_64-windows, compiled by msvc-19.29.30157, 64-bit 2024-11-17 21:35:13.785 GMT postmaster[5140] LOG: listening on Unix socket "c:/cirrus/.s.PGSQL.40042" 2024-11-17 21:35:13.817 GMT startup[2656] LOG: database system was shut down at 2024-11-17 21:30:50 GMT 2024-11-17 21:35:13.843 GMT client backend[2316] [unknown] FATAL: the database system is starting up 2024-11-17 21:35:13.863 GMT postmaster[5140] LOG: database system is ready to accept connections 2024-11-17 21:35:14.501 GMT client backend[5272] pg_regress/tablefunc ERROR: number of rows cannot be negative 2024-11-17 21:35:14.501 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT avg(normal_rand)::int, count(*) FROM normal_rand(-1, 250, 0.2); 2024-11-17 21:35:14.524 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid crosstab source data query 2024-11-17 21:35:14.524 GMT client backend[5272] pg_regress/tablefunc DETAIL: The query must return 3 columns: row_name, category, and value. 2024-11-17 21:35:14.524 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM crosstab('SELECT rowid, val FROM ct where rowclass = ''group1'' and (attribute = ''att2'' or attribute = ''att3'') ORDER BY 1,2;') AS ct(row_name text, category_1 text, category_2 text); 2024-11-17 21:35:14.525 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid crosstab return type 2024-11-17 21:35:14.525 GMT client backend[5272] pg_regress/tablefunc DETAIL: Return row must have at least two columns. 2024-11-17 21:35:14.525 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM crosstab('SELECT rowid, attribute, val FROM ct where rowclass = ''group1'' and (attribute = ''att2'' or attribute = ''att3'') ORDER BY 1,2;') AS ct(row_name text); 2024-11-17 21:35:14.526 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid crosstab return type 2024-11-17 21:35:14.526 GMT client backend[5272] pg_regress/tablefunc DETAIL: Source row_name datatype text does not match return row_name datatype integer. 2024-11-17 21:35:14.526 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM crosstab('SELECT rowid, attribute, val FROM ct where rowclass = ''group1'' and (attribute = ''att2'' or attribute = ''att3'') ORDER BY 1,2;') AS ct(row_name int, category_1 text, category_2 text); 2024-11-17 21:35:14.526 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid crosstab return type 2024-11-17 21:35:14.526 GMT client backend[5272] pg_regress/tablefunc DETAIL: Source value datatype text does not match return value datatype integer in column 3. 2024-11-17 21:35:14.526 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM crosstab('SELECT rowid, attribute, val FROM ct where rowclass = ''group1'' and (attribute = ''att2'' or attribute = ''att3'') ORDER BY 1,2;') AS ct(row_name text, category_1 text, category_2 int); 2024-11-17 21:35:14.595 GMT client backend[5272] pg_regress/tablefunc ERROR: crosstab categories query must return at least one row 2024-11-17 21:35:14.595 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM crosstab( 'SELECT rowid, rowdt, attribute, val FROM cth ORDER BY 1', 'SELECT DISTINCT attribute FROM cth WHERE attribute = ''a'' ORDER BY 1') AS c(rowid text, rowdt timestamp, temperature int4, test_result text, test_startdate timestamp, volts float8); 2024-11-17 21:35:14.596 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid crosstab categories query 2024-11-17 21:35:14.596 GMT client backend[5272] pg_regress/tablefunc DETAIL: The query must return one column. 2024-11-17 21:35:14.596 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM crosstab( 'SELECT rowid, rowdt, attribute, val FROM cth ORDER BY 1', 'SELECT DISTINCT rowdt, attribute FROM cth ORDER BY 2') AS c(rowid text, rowdt timestamp, temperature int4, test_result text, test_startdate timestamp, volts float8); 2024-11-17 21:35:14.597 GMT client backend[5272] pg_regress/tablefunc ERROR: crosstab category value must not be null 2024-11-17 21:35:14.597 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM crosstab( 'SELECT rowid, rowdt, attribute, val FROM cth ORDER BY 1', 'SELECT NULL::text') AS c(rowid text, rowdt timestamp, temperature int4, test_result text, test_startdate timestamp, volts float8); 2024-11-17 21:35:14.599 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid crosstab source data query 2024-11-17 21:35:14.599 GMT client backend[5272] pg_regress/tablefunc DETAIL: The query must return at least 3 columns: row_name, category, and value. 2024-11-17 21:35:14.599 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM crosstab( 'SELECT rowid, attribute FROM cth ORDER BY 1', 'SELECT DISTINCT attribute FROM cth ORDER BY 1') AS c(rowid text, temperature text, test_result text, test_startdate text, volts text); 2024-11-17 21:35:14.600 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid crosstab return type 2024-11-17 21:35:14.600 GMT client backend[5272] pg_regress/tablefunc DETAIL: Return row must have 7 columns, not 6. 2024-11-17 21:35:14.600 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM crosstab( 'SELECT rowid, rowdt, rowdt, attribute, val FROM cth ORDER BY 1', 'SELECT DISTINCT attribute FROM cth ORDER BY 1') AS c(rowid text, rowdt timestamp, temperature int4, test_result text, test_startdate timestamp, volts float8); 2024-11-17 21:35:14.600 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid crosstab return type 2024-11-17 21:35:14.600 GMT client backend[5272] pg_regress/tablefunc DETAIL: Return row must have at least two columns. 2024-11-17 21:35:14.600 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM crosstab( 'SELECT rowid, attribute, val FROM cth ORDER BY 1', 'SELECT DISTINCT attribute FROM cth ORDER BY 1') AS c(rowid text); 2024-11-17 21:35:14.629 GMT client backend[5272] pg_regress/tablefunc ERROR: infinite recursion detected 2024-11-17 21:35:14.629 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid int, parent_keyid int, level int, branch text); 2024-11-17 21:35:14.636 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid connectby return type 2024-11-17 21:35:14.636 GMT client backend[5272] pg_regress/tablefunc DETAIL: Source key type integer does not match return key type text. 2024-11-17 21:35:14.636 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid text, parent_keyid int, level int, branch text); 2024-11-17 21:35:14.637 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid connectby return type 2024-11-17 21:35:14.637 GMT client backend[5272] pg_regress/tablefunc DETAIL: Source key type integer does not match return key type double precision. 2024-11-17 21:35:14.637 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid float8, parent_keyid float8, level int, branch text); 2024-11-17 21:35:14.638 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid connectby return type 2024-11-17 21:35:14.638 GMT client backend[5272] pg_regress/tablefunc DETAIL: Source parent key type integer does not match return parent key type double precision. 2024-11-17 21:35:14.638 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid int, parent_keyid float8, level int, branch text); 2024-11-17 21:35:14.639 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid connectby return type 2024-11-17 21:35:14.639 GMT client backend[5272] pg_regress/tablefunc DETAIL: Return row must have 3 columns, not 4. 2024-11-17 21:35:14.639 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0) AS t(keyid int, parent_keyid int, level int, branch text); 2024-11-17 21:35:14.639 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid connectby return type 2024-11-17 21:35:14.639 GMT client backend[5272] pg_regress/tablefunc DETAIL: Return row must have 4 columns, not 3. 2024-11-17 21:35:14.639 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid int, parent_keyid int, level int); 2024-11-17 21:35:14.640 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid connectby return type 2024-11-17 21:35:14.640 GMT client backend[5272] pg_regress/tablefunc DETAIL: Source parent key type integer does not match return parent key type text. 2024-11-17 21:35:14.640 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0) AS t(keyid int, parent_keyid text, level int); 2024-11-17 21:35:14.641 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid connectby return type 2024-11-17 21:35:14.641 GMT client backend[5272] pg_regress/tablefunc DETAIL: Third return column (depth) must be type integer. 2024-11-17 21:35:14.641 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid int, parent_keyid int, level float, branch float); 2024-11-17 21:35:14.642 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid connectby return type 2024-11-17 21:35:14.642 GMT client backend[5272] pg_regress/tablefunc DETAIL: Fourth return column (branch) must be type text. 2024-11-17 21:35:14.642 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM connectby('connectby_int', 'keyid', 'parent_keyid', '2', 0, '~') AS t(keyid int, parent_keyid int, level int, branch float); 2024-11-17 21:35:14.642 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid connectby return type 2024-11-17 21:35:14.642 GMT client backend[5272] pg_regress/tablefunc DETAIL: Fifth return column (serial) must be type integer. 2024-11-17 21:35:14.642 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM connectby('connectby_text', 'keyid', 'parent_keyid', 'pos', 'row2', 0, '~') AS t(keyid text, parent_keyid text, level int, branch text, pos text); 2024-11-17 21:35:14.643 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid connectby return type 2024-11-17 21:35:14.643 GMT client backend[5272] pg_regress/tablefunc DETAIL: Fourth return column (serial) must be type integer. 2024-11-17 21:35:14.643 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM connectby('connectby_text', 'keyid', 'parent_keyid', 'pos', 'row2', 0) AS t(keyid text, parent_keyid text, level int, pos text); 2024-11-17 21:35:14.643 GMT client backend[5272] pg_regress/tablefunc ERROR: invalid connectby source data query 2024-11-17 21:35:14.643 GMT client backend[5272] pg_regress/tablefunc DETAIL: The query must return at least two columns. 2024-11-17 21:35:14.643 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM connectby('connectby_int', '1; --', 'parent_keyid', '2', 0) AS t(keyid int, parent_keyid int, level int); 2024-11-17 21:35:14.645 GMT client backend[5272] pg_regress/tablefunc ERROR: infinite recursion detected 2024-11-17 21:35:14.645 GMT client backend[5272] pg_regress/tablefunc STATEMENT: SELECT * FROM connectby('connectby_int', '1::int, NULL::int; --', 'parent_keyid', '2', 0) AS t(keyid int, parent_keyid int, level int); 2024-11-17 21:35:15.038 GMT postmaster[5140] LOG: received fast shutdown request 2024-11-17 21:35:15.038 GMT postmaster[5140] LOG: aborting any active transactions TRAP: failed Assert("(remainMask.mask | targetMask.mask) == BTYPE_MASK_ALL.mask"), File: "../src/backend/postmaster/postmaster.c", Line: 2887, PID: 5140 abort() has been called