Архив рассылок [pgsql-bugs]
Re: BUG #19728: A logical replication apply worker segfaults dereferencing a NULL `MyLogicalRepWorker->stream_filese Ajin Cherian
Re: autovacuum: automatically propagate updated parameters Masahiko Sawada
Re: autovacuum: automatically propagate updated parameters Bharath Rupireddy
Re: autovacuum: automatically propagate updated parameters Masahiko Sawada
Re: autovacuum: automatically propagate updated parameters Daniel Gustafsson
Re: PostgreSQL 18.6/17.11: standby PANIC on restart after VM truncation rahul@rhyadav.dev
Re: PG18: use-after-free in exec partition pruning after an EPQ recheck in LockRows Andrey Rachitskiy
Wrong results: hashed SubPlan referenced twice after OR-qual extraction reuses a stale hash table (13 to 19beta4) Samuel Olaoye
Re: autovacuum: automatically propagate updated parameters Masahiko Sawada
Re: BUG #19730: PostgreSQL `pg_backup_start` accepts newlines in the backup label, producing an unrestorable `backup shihao zhong
Backend crash (signal 11) in pg_trgm makesign() after ALTER TABLE ... SET STORAGE on a column with a gist_trgm_ops index Thiago Bonfante
Re: BUG #19730: PostgreSQL `pg_backup_start` accepts newlines in the backup label, producing an unrestorable `backup David G. Johnston
Re: BUG #19730: PostgreSQL `pg_backup_start` accepts newlines in the backup label, producing an unrestorable `backup Michael Paquier
Re: BUG #19730: PostgreSQL `pg_backup_start` accepts newlines in the backup label, producing an unrestorable `backup shihao zhong
Re: BUG #19730: PostgreSQL `pg_backup_start` accepts newlines in the backup label, producing an unrestorable `backup Michael Paquier
Re: PostgreSQL 18.6/17.11: standby PANIC on restart after VM truncation rahul@rhyadav.dev
Re: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641) Hayato Kuroda (Fujitsu)
Re: Wrong results: hashed SubPlan referenced twice after OR-qual extraction reuses a stale hash table (13 to 19beta4) rahul@rhyadav.dev
Re: Backend crash (signal 11) in pg_trgm makesign() after ALTER TABLE ... SET STORAGE on a column with a gist_trgm_ops index Andrey Rachitskiy
Re: PG18: use-after-free in exec partition pruning after an EPQ recheck in LockRows Andrey Rachitskiy
Re: BUG #19628: Uninterruptible vacuum during hash index processing Heikki Linnakangas
BUG #19735: `jsonb_object_agg_unique_strict` drops a JSONB `null` value as if it were SQL NULL PG Bug reporting form
BUG #19736: `JSON_OBJECT ... ABSENT ON NULL` accepts invalid keys when the value is NULL PG Bug reporting form
BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses PG Bug reporting form
BUG #19738: `uuidv7(interval)` rejects sub-millisecond timestamps within the final 48-bit millisecond PG Bug reporting form
BUG #19739: Parameterized first autocommit statement can have different `transaction_timestamp()` and `statement PG Bug reporting form
BUG #19740: `has_language_privilege` returns TRUE for a nonexistent language OID when the user is a superuser PG Bug reporting form
BUG #19741: `avg(double precision)` overflows on cancelling finite inputs whose mean is representable PG Bug reporting form
BUG #19743: pgcrypto crypt(): sha-crypt rounds= silently wraps modulo 2^32 PG Bug reporting form
BUG #19744: contrib/seg output truncates to 6 significant digits, breaking dump/restore PG Bug reporting form
BUG #19745: tsquery input: 33 nested "!" raise XX000 via elog(), escaping pg_input_is_valid() PG Bug reporting form
BUG #19746: interval with INT64_MIN microseconds prints a value interval_in rejects PG Bug reporting form
BUG #19747: pg_dump does not pin array_nulls, so restore mangles NULL array elements PG Bug reporting form
BUG #19748: tsvectorrecv accepts duplicate lexemes and position 0 that tsvectorin rejects PG Bug reporting form
BUG #19749: bpchar_ops declares equalimage although bpchar equality ignores trailing spaces PG Bug reporting form
Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" shihao zhong
BUG #19750: tsquery output omits parentheses, so the text reparses to a different value PG Bug reporting form
Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" David Rowley
Re: BUG #19725: PostgreSQL 18.6: pg_restore read failure with io_uring, not observed with worker weijie JL
Re: Backend crash (signal 11) in pg_trgm makesign() after ALTER TABLE ... SET STORAGE on a column with a gist_trgm_ops index Kirill Reshke
Re: BUG #19740: `has_language_privilege` returns TRUE for a nonexistent language OID when the user is a superuser Laurenz Albe
Re: BUG #19738: `uuidv7(interval)` rejects sub-millisecond timestamps within the final 48-bit millisecond Laurenz Albe
Issue Installing PostGIS via Stack Builder on MacBook (Apple Silicon / ARM64) – Application Buffers/Freezes Hariharan Murugesan
Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" shihao zhong
Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" shihao zhong
Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" shihao zhong
Re: BUG #19731: `first_value` returns an excluded peer for a nonempty `EXCLUDE TIES` frame shihao zhong
Re: BUG #19732: first_value/last_value/nth_value return NULL with EXCLUDE TIES when the current row is outside its f shihao zhong
Re: BUG #19730: PostgreSQL `pg_backup_start` accepts newlines in the backup label, producing an unrestorable `backup Michael Paquier
Re: BUG #19738: `uuidv7(interval)` rejects sub-millisecond timestamps within the final 48-bit millisecond Andrey Borodin
Re: BUG #19628: Uninterruptible vacuum during hash index processing Heikki Linnakangas
Re: BUG #19732: first_value/last_value/nth_value return NULL with EXCLUDE TIES when the current row is outside its f Andrey Rachitskiy
BUG #19751: MIN aggregate + FETCH FIRST 1 ROW WITH TIES causes false 21000 error when index scan is forced PG Bug reporting form
Re: Issue Installing PostGIS via Stack Builder on MacBook (Apple Silicon / ARM64) – Application Buffers/Freezes Andrew Dunstan
Re: BUG #19750: tsquery output omits parentheses, so the text reparses to a different value Tom Lane
Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" shihao zhong
Re: BUG #19744: contrib/seg output truncates to 6 significant digits, breaking dump/restore Tom Lane
Re: BUG #19749: bpchar_ops declares equalimage although bpchar equality ignores trailing spaces Peter Geoghegan
Re: 42P16 error when dropping and adding column Fujii Masao
Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses Narayanan Venkateswaran
RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641) Hayato Kuroda (Fujitsu)
Re: autovacuum: automatically propagate updated parameters Masahiko Sawada
Re: BUG #19748: tsvectorrecv accepts duplicate lexemes and position 0 that tsvectorin rejects Tom Lane
Re: BUG #19732: first_value/last_value/nth_value return NULL with EXCLUDE TIES when the current row is outside its f shihao zhong
Re: BUG #19698: IMPORT FOREIGN SCHEMA treats a NOT VALID NOT NULL constraint as validated Etsuro Fujita
Re: BUG #19698: IMPORT FOREIGN SCHEMA treats a NOT VALID NOT NULL constraint as validated Etsuro Fujita
Re: BUG #19747: pg_dump does not pin array_nulls, so restore mangles NULL array elements Laurenz Albe
Re: BUG #19735: `jsonb_object_agg_unique_strict` drops a JSONB `null` value as if it were SQL NULL shihao zhong
RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641) Hayato Kuroda (Fujitsu)
Re: BUG #19735: `jsonb_object_agg_unique_strict` drops a JSONB `null` value as if it were SQL NULL Dmitry Dolgov
Re: PG18: use-after-free in exec partition pruning after an EPQ recheck in LockRows Andrey Rachitskiy
BUG #19752: GROUP BY on a constant and a cast to a length-limited array type crashes the server while planning PG Bug reporting form
Re: Assertion failure in _bt_pagedel (leafblkno == scanblkno) after interrupted VACUUM Peter Geoghegan
Re: BUG #19752: GROUP BY on a constant and a cast to a length-limited array type crashes the server while planning Andrey Rachitskiy
RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641) Hayato Kuroda (Fujitsu)
Re: BUG #19735: `jsonb_object_agg_unique_strict` drops a JSONB `null` value as if it were SQL NULL shihao zhong
Re: BUG #19488: Standby connection fails after dropping on login event trigger enabled always Alexander Lakhin
Re: BUG #19488: Standby connection fails after dropping on login event trigger enabled always Ayush Tiwari
Re: BUG #19519: REPACK can fail due to missing chunk for toast value Matthias van de Meent
Static libpq and ecpglib clash with PThreads4W on Windows expl0it3r@my-gate.net
Re: BUG #19736: `JSON_OBJECT ... ABSENT ON NULL` accepts invalid keys when the value is NULL QQ Mail
BUG #19754: pg_restore + zlib 1.3.2: intact files rejected, truncated files accepted PG Bug reporting form
Re: BUG #19519: REPACK can fail due to missing chunk for toast value Matthias van de Meent
BUG #19755: Server-wide hang: DROP DATABASE waits forever for ProcSignalBarrier while VACUUM waits on pg_databas PG Bug reporting form
Re: BUG #19732: first_value/last_value/nth_value return NULL with EXCLUDE TIES when the current row is outside its f Andrey Rachitskiy
postgres_fdw: semi-join pushdown generates invalid remote SQL ("missing FROM-clause entry") with a nested correlated subquery Kelly Morrison
BUG #19756: ALTER COLUMN TYPE USING gives wrong values on partitions with IS NULL PG Bug reporting form
VACUUM/ANALYZE double-count the backend's own pending table stats (n_live_tup = 2*N after INSERT + ANALYZE) Staroverov Ilja
Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses Narayanan Venkateswaran
BUG #19757: attname in pg_attribute not strictly updated when renaming a column PG Bug reporting form
Re: BUG #19756: ALTER COLUMN TYPE USING gives wrong values on partitions with IS NULL Sebastian Webber
BUG #19758: Nested BETWEEN grows time and space exponentially in parse analysis PG Bug reporting form
use-after-free in jsonb_set_lax() John Naylor
Re: BUG #19488: Standby connection fails after dropping on login event trigger enabled always Fujii Masao
Re: BUG #19755: Server-wide hang: DROP DATABASE waits forever for ProcSignalBarrier while VACUUM waits on pg_databas shihao zhong
Re: use-after-free in jsonb_set_lax() John Naylor
Re: use-after-free in jsonb_set_lax() Laurenz Albe
BUG #19759: Hashed SetOp / RecursiveUnion pre-allocate up to 64 GB from the row estimate since 8f29467c57f PG Bug reporting form
BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction PG Bug reporting form
BUG #19761: btree_gist: "cannot subtract infinite dates" when inserting 'infinity' into a GiST index on date PG Bug reporting form
Re: BUG #19759: Hashed SetOp / RecursiveUnion pre-allocate up to 64 GB from the row estimate since 8f29467c57f Sebastian Webber
BUG #19762: ManualBug1 tcn: NULL pointer dereference in triggered_change_notification() via strcpy_quoted PG Bug reporting form
BUG #19763: ManualBug2 NULL pointer dereference in make_build_data via examine_expression bypass of lookup_var_a PG Bug reporting form
BUG #19764: ManualBug3 Assert failure in pgstat_setup_shared_refs crashes initdb post-bootstrap subprocess PG Bug reporting form
Re: BUG #19762: ManualBug1 tcn: NULL pointer dereference in triggered_change_notification() via strcpy_quoted Tomas Vondra
Re: BUG #19764: ManualBug3 Assert failure in pgstat_setup_shared_refs crashes initdb post-bootstrap subprocess Tomas Vondra
Re: BUG #19763: ManualBug2 NULL pointer dereference in make_build_data via examine_expression bypass of lookup_var_a Tomas Vondra
Re: BUG #19382: Server crash at __nss_database_lookup surya poondla
Re: BUG #19759: Hashed SetOp / RecursiveUnion pre-allocate up to 64 GB from the row estimate since 8f29467c57f David Rowley
Re: use-after-free in jsonb_set_lax() John Naylor
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Takeshi Ideriha
Re: use-after-free in jsonb_set_lax() Manuel Reyes Bravo
Re: BUG #19764: ManualBug3 Assert failure in pgstat_setup_shared_refs crashes initdb post-bootstrap subprocess Michael Paquier
BUG #19765: Wrong result from a chain of LEFT JOINs since v16 PG Bug reporting form
SQL/JSON PASSING fails for char(n), name and domains over text Staroverov Ilja
Cached plan can stay stale indefinitely when an invalidation for a planner-added dependency arrives during planning Clemenza Zhang
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Ayush Tiwari
Re: BUG #19761: btree_gist: "cannot subtract infinite dates" when inserting 'infinity' into a GiST index on date Nitin Motiani
Volatile expressions in SQL/JSON functions are evaluated twice Staroverov Ilja
Re: [***DKIM violation***] Re: BUG #19418: SQL/JSON JSON_VALUE() does not conform to ISO/IEC 9075-2:2023(E) 6.34 <JSON value constructor> Staroverov Ilja
Re: [MASSMAIL] pg_stat_statements replaces SQL/JSON ON EMPTY / ON ERROR keywords with parameters Staroverov Ilja
Inconsistency in psql output with \d+x PATTERN George MacKerron
Re: BUG #19488: Standby connection fails after dropping on login event trigger enabled always Fujii Masao
BUG #19766: Assert in shm_toc_insert: EXPLAIN ANALYZE of a SubPlan shared by Parallel Append children PG Bug reporting form
BUG #19767: pg_get_viewdef prints ORDER BY (- '3'::int4) as (- 3), which reparses as column position -3 PG Bug reporting form
BUG #19768: JSON_TABLE: row/text comparisons in context item or PASSING give wrong results or spurious collation PG Bug reporting form
Re: BUG #19766: Assert in shm_toc_insert: EXPLAIN ANALYZE of a SubPlan shared by Parallel Append children BHUVAN CHILUKUTI
Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses Nitin Motiani
BUG #19769: int8range() raises an error for an inclusive upper bound at BIGINT_MAX PG Bug reporting form
BUG #19770: CREATE TABLE (LIKE ...) PARTITION BY copies a NO INHERIT not-null constraint; NULLs then go into par PG Bug reporting form
BUG #19772: ERROR: corrupt MVNDistinct entry for GROUP BY c0, ROLLUP (abs(c0)) with ndistinct statistics PG Bug reporting form
Re: BUG #19763: ManualBug2 NULL pointer dereference in make_build_data via examine_expression bypass of lookup_var_a shihao zhong
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction shihao zhong
Re: use-after-free in jsonb_set_lax() John Naylor
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Takeshi Ideriha
Re: pg_stat_statements replaces SQL/JSON ON EMPTY / ON ERROR keywords with parameters Staroverov Ilja
Re: BUG #19759: Hashed SetOp / RecursiveUnion pre-allocate up to 64 GB from the row estimate since 8f29467c57f David Rowley
Re: BUG #19767: pg_get_viewdef prints ORDER BY (- '3'::int4) as (- 3), which reparses as column position -3 Nitin Motiani
Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses Narayanan Venkateswaran
Re: Inconsistency in psql output with \d+x PATTERN George MacKerron
Re: BUG #19644: byteaout, float8out and float4out are marked IMMUTABLE but depend on GUCs Peter Eisentraut
Timing issue in pg_basebackup Jesper St John
Re: BUG #19767: pg_get_viewdef prints ORDER BY (- '3'::int4) as (- 3), which reparses as column position -3 Henson Choi
Re: Inconsistency in psql output with \d+x PATTERN shihao zhong
Re: Inconsistency in psql output with \d+x PATTERN shihao zhong
Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses Narayanan Venkateswaran
Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses Narayanan Venkateswaran
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction shihao zhong
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Takeshi Ideriha
BUG #19773: pg_dump omits a different generation expression of an inherited column in a child table PG Bug reporting form
BUG #19774: Incremental backup loses re-extended blocks when WAL summaries are merged out of LSN order PG Bug reporting form
BUG #19775: Incremental backup without data checksums restores a stale visibility map page after VACUUM truncati PG Bug reporting form
BUG #19776: pg_combinebackup ignores the truncation_block_length of an intermediate incremental backup PG Bug reporting form
Re: BUG #19644: byteaout, float8out and float4out are marked IMMUTABLE but depend on GUCs Fujii Masao
Re: BUG #19763: ManualBug2 NULL pointer dereference in make_build_data via examine_expression bypass of lookup_var_a Michael Paquier
RE: START_REPLICATION silently truncates an overlong LSN component Hayato Kuroda (Fujitsu)
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Michael Paquier
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Michael Paquier
BUG #19777: PERIOD foreign key rejects an empty referencing range even though the referenced period covers it PG Bug reporting form
RE: START_REPLICATION silently truncates an overlong LSN component Hayato Kuroda (Fujitsu)
Re: BUG #19644: byteaout, float8out and float4out are marked IMMUTABLE but depend on GUCs Staroverov Ilja
Re: BUG #19644: byteaout, float8out and float4out are marked IMMUTABLE but depend on GUCs Fujii Masao
Re: BUG #19771: to_char(): NUL byte in result for formats with a trailing decimal point (regression from ec352b37d) Gowtham Reddy
BUG #19778: Empty tsquery cannot roundtrip through binary input PG Bug reporting form
Re: Timing issue in pg_basebackup Kirill Reshke
Re: BUG #19763: ManualBug2 NULL pointer dereference in make_build_data via examine_expression bypass of lookup_var_a shihao zhong
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction shihao zhong
Re: BUG #19644: byteaout, float8out and float4out are marked IMMUTABLE but depend on GUCs Fujii Masao
Re: BUG #19644: byteaout, float8out and float4out are marked IMMUTABLE but depend on GUCs Staroverov Ilja
Re: BUG #19763: ManualBug2 NULL pointer dereference in make_build_data via examine_expression bypass of lookup_var_a Michael Paquier
Re: pg_stat_statements replaces SQL/JSON ON EMPTY / ON ERROR keywords with parameters Michael Paquier
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Michael Paquier
Re: BUG #19774: Incremental backup loses re-extended blocks when WAL summaries are merged out of LSN order Fujii Masao
Re: BUG #19770: CREATE TABLE (LIKE ...) PARTITION BY copies a NO INHERIT not-null constraint; NULLs then go into par Nitin Motiani
Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses Nitin Motiani
Re: pg_stat_statements replaces SQL/JSON ON EMPTY / ON ERROR keywords with parameters Staroverov Ilja
RE: START_REPLICATION silently truncates an overlong LSN component Hayato Kuroda (Fujitsu)
Re: BUG #19774: Incremental backup loses re-extended blocks when WAL summaries are merged out of LSN order Ayush Tiwari
BUG #19779: Backend SIGSEGV in UPDATE with FOR UPDATE CTE joined to UNION ALL subquery PG Bug reporting form
data race in libpq process-global variables (static_client_encoding / static_std_strings) when connections are established concurrently Yuriy Osadchyy
Re: Timing issue in pg_basebackup Jesper St John
Re: BUG #19725: PostgreSQL 18.6: pg_restore read failure with io_uring, not observed with worker Dmytro Astapov
BUG #19780: gtsvector_picksplit() reads uninitialized data when called with three entries PG Bug reporting form
BUG #19781: UPDATE moving a row of a self-referencing partitioned table fails with 23503 although ON UPDATE CASC PG Bug reporting form
BUG #19782: SET CONSTRAINTS in a released savepoint survives ROLLBACK TO an enclosing savepoint PG Bug reporting form
BUG #19784: "no relation entry for relid 1" when costing = ANY (<array expr over max(col)>) in a MinMaxAggPath PG Bug reporting form
BUG #19785: Sorted GROUPING SETS return a grouping column's value in a set that leaves it out PG Bug reporting form
BUG #19786: JSON_TABLE: subquery in PASSING gives "unexpected non-SELECT command in SubLink" PG Bug reporting form
Re: BUG #19785: Sorted GROUPING SETS return a grouping column's value in a set that leaves it out Alperen Keleş
BUG #19787: "could not find pathkey item to sort" for Gather Merge over a merge join below reordered LEFT JOINs PG Bug reporting form
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Michael Paquier
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Takeshi Ideriha
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Michael Paquier
Re: BUG #19763: ManualBug2 NULL pointer dereference in make_build_data via examine_expression bypass of lookup_var_a shihao zhong
Re: BUG #19763: ManualBug2 NULL pointer dereference in make_build_data via examine_expression bypass of lookup_var_a Michael Paquier
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Takeshi Ideriha
BUG #19788: Chinese translation uses incorrect term for “transaction” in “no transaction is in progress” PG Bug reporting form
Re: Timing issue in pg_basebackup Kirill Reshke
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Takeshi Ideriha
Re: pg_stat_statements replaces SQL/JSON ON EMPTY / ON ERROR keywords with parameters Michael Paquier
Re: BUG #19774: Incremental backup loses re-extended blocks when WAL summaries are merged out of LSN order Fujii Masao
Re: pg_stat_statements replaces SQL/JSON ON EMPTY / ON ERROR keywords with parameters Staroverov Ilja
Re: BUG #19767: pg_get_viewdef prints ORDER BY (- '3'::int4) as (- 3), which reparses as column position -3 Nitin Motiani
BUG #19789: "expression not found in statistics object" for a boolean domain column in an MCV statistics object PG Bug reporting form
BUG #19790: "cannot start a subtransaction ... inval messages" after "ALTER DOMAIN ... DROP CONSTRAINT" PG Bug reporting form
BUG #19791: ALTER COLUMN TYPE fails on an INCLUDE column of an index used by a foreign key PG Bug reporting form
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Michael Paquier
Re: BUG #19763: ManualBug2 NULL pointer dereference in make_build_data via examine_expression bypass of lookup_var_a shihao zhong
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction shihao zhong
Re: BUG #19784: "no relation entry for relid 1" when costing = ANY (<array expr over max(col)>) in a MinMaxAggPath shihao zhong
Re: BUG #19775: Incremental backup without data checksums restores a stale visibility map page after VACUUM truncati shihao zhong
RE: START_REPLICATION silently truncates an overlong LSN component Hayato Kuroda (Fujitsu)
Re: BUG #19752: GROUP BY on a constant and a cast to a length-limited array type crashes the server while planning Andrey Rachitskiy
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Ayush Tiwari
Re: BUG #19725: PostgreSQL 18.6: pg_restore read failure with io_uring, not observed with worker weijie JL
Re: pg_stat_statements replaces SQL/JSON ON EMPTY / ON ERROR keywords with parameters Michael Paquier
Re: BUG #19761: btree_gist: "cannot subtract infinite dates" when inserting 'infinity' into a GiST index on date Nitin Motiani
BUG #19792: BUG: Deadlock between WaitIO and read-stream look-ahead under io_method=io_uring (18.6) PG Bug reporting form
Re: BUG #19789: "expression not found in statistics object" for a boolean domain column in an MCV statistics object Matheus Alcantara
Re: BUG #19752: GROUP BY on a constant and a cast to a length-limited array type crashes the server while planning Matheus Alcantara
Incorrect NOT IN results with implicit casts returning NULL after anti-join optimization BHUVAN CHILUKUTI
Re: BUG #19784: "no relation entry for relid 1" when costing = ANY (<array expr over max(col)>) in a MinMaxAggPath shihao zhong
first_value()/nth_value() with IGNORE NULLS loop forever (EXCLUDE GROUP/TIES, frame past partition end, no ORDER BY) BHUVAN CHILUKUTI
Re: BUG #19759: Hashed SetOp / RecursiveUnion pre-allocate up to 64 GB from the row estimate since 8f29467c57f shihao zhong
Re: BUG #19725: PostgreSQL 18.6: pg_restore read failure with io_uring, not observed with worker Dmytro Astapov
BUG #19794: Assert in btvacuumcleanup() fails when page counted in pages_free twice PG Bug reporting form
BUG #19795: pgoutput: walsender crashes on START_REPLICATION option without a value PG Bug reporting form
Re: BUG #19794: Assert in btvacuumcleanup() fails when page counted in pages_free twice Andrey Borodin
BUG #19796: io_uring crashes with specific kernel/liburing versions + io_max_concurrency due to rings overlap PG Bug reporting form
ORCE ROW LEVEL SECURITY makes ADD/VALIDATE FOREIGN KEY skip rows hidden from the owner (RI_Initial_Check) Ludwig Kannicht
Re: BUG #19761: btree_gist: "cannot subtract infinite dates" when inserting 'infinity' into a GiST index on date Nitin Motiani
Re: BUG #19767: pg_get_viewdef prints ORDER BY (- '3'::int4) as (- 3), which reparses as column position -3 Nitin Motiani
Re: BUG #19783: Sorted GROUPING SETS return a grouping column's value in a set that leaves it out Ayush Tiwari
Re: BUG #19794: Assert in btvacuumcleanup() fails when page counted in pages_free twice shihao zhong
Re: BUG #19783: Sorted GROUPING SETS return a grouping column's value in a set that leaves it out David Rowley
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Michael Paquier
RE: BUG #19795: pgoutput: walsender crashes on START_REPLICATION option without a value Hayato Kuroda (Fujitsu)
Re: BUG #19784: "no relation entry for relid 1" when costing = ANY (<array expr over max(col)>) in a MinMaxAggPath shihao zhong
Re: BUG #19767: pg_get_viewdef prints ORDER BY (- '3'::int4) as (- 3), which reparses as column position -3 Henson Choi
RE: START_REPLICATION silently truncates an overlong LSN component Hayato Kuroda (Fujitsu)
Re: BUG #19796: io_uring crashes with specific kernel/liburing versions + io_max_concurrency due to rings overlap Andrey Rachitskiy
Re: BUG #19752: GROUP BY on a constant and a cast to a length-limited array type crashes the server while planning Andrey Rachitskiy
BUG #19797: Wrong results: HAVING pushdown past GROUP BY on composite column with nondeterministic collation PG Bug reporting form
Re: BUG #19779: Backend SIGSEGV in UPDATE with FOR UPDATE CTE joined to UNION ALL subquery Dilip Kumar
Query jumbling ignores XML names, ROLLUP/CUBE, VARIADIC and more Staroverov Ilja
Re: BUG #19761: btree_gist: "cannot subtract infinite dates" when inserting 'infinity' into a GiST index on date Nitin Motiani
BUG #19798: "failed to build any 4-way joins" with ROLLUP over a LATERAL subquery that references the nullable s PG Bug reporting form
RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641) Hayato Kuroda (Fujitsu)
Re: BUG #19796: io_uring crashes with specific kernel/liburing versions + io_max_concurrency due to rings overlap Andres Freund
Re: BUG #19796: io_uring crashes with specific kernel/liburing versions + io_max_concurrency due to rings overlap Andres Freund
BUG #19799: Self-join elimination: "failed to build any 3-way joins" with LATERAL PG Bug reporting form
Re: pg_stat_statements replaces SQL/JSON ON EMPTY / ON ERROR keywords with parameters Michael Paquier
Re: BUG #19760: CLUSTER loses a row the transaction inserted and then updated in a rolled-back subtransaction Michael Paquier
crash in ltree_compare_distance() in 14.24 Chris St Denis
Re: BUG #19761: btree_gist: "cannot subtract infinite dates" when inserting 'infinity' into a GiST index on date Nitin Motiani
Re: BUG #19777: PERIOD foreign key rejects an empty referencing range even though the referenced period covers it Takeshi Ideriha
Re: pg_stat_statements replaces SQL/JSON ON EMPTY / ON ERROR keywords with parameters Staroverov Ilja
RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641) Hayato Kuroda (Fujitsu)
Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses Narayanan Venkateswaran
BUG #19800: Wrong results: self-join elimination drops an ORDER BY sort key with GROUPING SETS / CUBE / ROLLUP PG Bug reporting form
Re: crash in ltree_compare_distance() in 14.24 David Geier
Re: BUG #19795: pgoutput: walsender crashes on START_REPLICATION option without a value Kirill Reshke
Re: crash in ltree_compare_distance() in 14.24 Chris St Denis
RE: START_REPLICATION silently truncates an overlong LSN component Hayato Kuroda (Fujitsu)
Re: BUG #19783: Sorted GROUPING SETS return a grouping column's value in a set that leaves it out Ayush Tiwari
Re: BUG #19792: BUG: Deadlock between WaitIO and read-stream look-ahead under io_method=io_uring (18.6) Tomas Barton
BUG #19801: atan2d underflow causes equivalent queries to return different results PG Bug reporting form
Re: BUG #19786: JSON_TABLE: subquery in PASSING gives "unexpected non-SELECT command in SubLink" Amit Langote
Re: BUG #19752: GROUP BY on a constant and a cast to a length-limited array type crashes the server while planning Matheus Alcantara
BUG #19802: MERGE into a partitioned table fails with "SubPlan found with no parent plan" PG Bug reporting form
BUG #19803: Assertion "!parallel_aware || pathnode->path.parallel_safe" in create_append_path PG Bug reporting form
Re: BUG #19776: pg_combinebackup ignores the truncation_block_length of an intermediate incremental backup Rajesh Kumar Thandapani
Re: BUG #19776: pg_combinebackup ignores the truncation_block_length of an intermediate incremental backup Rajesh Kumar Thandapani
Re: BUG #19792: BUG: Deadlock between WaitIO and read-stream look-ahead under io_method=io_uring (18.6) shihao zhong
Re: BUG #19786: JSON_TABLE: subquery in PASSING gives "unexpected non-SELECT command in SubLink" Ayush Tiwari
Re: BUG #19752: GROUP BY on a constant and a cast to a length-limited array type crashes the server while planning Andrey Rachitskiy
BUG #19804: "variable not found in subplan target list", DISTINCT agg over Gather` PG Bug reporting form
Re: crash in ltree_compare_distance() in 14.24 David Geier
Re: pg_rewind and hint bits leads to visibility corruption Sebastian Webber
Re: BUG #19803: Assertion "!parallel_aware || pathnode->path.parallel_safe" in create_append_path David Rowley
Re: BUG #19802: MERGE into a partitioned table fails with "SubPlan found with no parent plan" Gowtham Reddy
Re: BUG #19803: Assertion "!parallel_aware || pathnode->path.parallel_safe" in create_append_path Gowtham Reddy
Re: BUG #19786: JSON_TABLE: subquery in PASSING gives "unexpected non-SELECT command in SubLink" Amit Langote
RE: START_REPLICATION silently truncates an overlong LSN component Hayato Kuroda (Fujitsu)
Re: BUG #19803: Assertion "!parallel_aware || pathnode->path.parallel_safe" in create_append_path David Rowley
BUG #19805: Wrong results: self-join elimination drops an ORDER BY sort key with GROUPING SETS / CUBE / ROLLUP PG Bug reporting form
RE: Streaming decoding fails with "unexpected table_index_fetch_tuple call during logical decoding" when a relation has a TOASTed conbin (follow-up to BUG #18641) Hayato Kuroda (Fujitsu)
BUG #19806: Wrong results: HAVING pushed into WHERE for GROUP BY on composite column (nondeterministic field) PG Bug reporting form
BUG #19807: CHECK constraint not enforced on partitioned table when partition overrides a virtual generated colu PG Bug reporting form
BUG #19808: NOT NULL NO INHERIT copied by CREATE TABLE (LIKE) not enforced on partitioned table PG Bug reporting form
BUG #19809: oidvector index dedup still returns wrong results on 18.6; CTAS persists the corrupted rows PG Bug reporting form
BUG #19810: to_char(): float V-format overflow yields 'Infinity' or NaN; format after decimal point dropped PG Bug reporting form
BUG #19811: numeric log(base, x): wrong sign of Infinity result when base < 1; base 1 accepted with x = Infinity PG Bug reporting form
Re: BUG #19800: Wrong results: self-join elimination drops an ORDER BY sort key with GROUPING SETS / CUBE / ROLLUP Narayanan Venkateswaran
BUG #19812: Multiple wrong-result and data-integrity issues with virtual generated columns (v18) PG Bug reporting form
BUG #19813: jsonpath: datetime errors bypass silent/ON ERROR; boolean() inconsistent; PASSING rejects bpchar/nam PG Bug reporting form
BUG #19814: pg_restore_attribute_stats: MCV accepted without eq operator; ANALYZE range slot rejected PG Bug reporting form
Re: BUG #19384: Server crash at textout Jeevan Chalke
Re: BUG #19791: ALTER COLUMN TYPE fails on an INCLUDE column of an index used by a foreign key Dilip Kumar
Re: BUG #19644: byteaout, float8out and float4out are marked IMMUTABLE but depend on GUCs Fujii Masao
BUG #19815: 004_sni.pl fails deterministically with OpenSSL 1.1.1 (tests 75 and 86) PG Bug reporting form
RE: BUG #19411: libpq 16.x exhibits a memory leak when connections are repeatedly created and destroyed Matt Carter
Re: Timing issue in pg_basebackup Jesper St John
RE: BUG #19411: libpq 16.x exhibits a memory leak when connections are repeatedly created and destroyed Matt Carter
BUG #19816: PL/Python SD dictionary is split by input collation in 19rc1 PG Bug reporting form
Re: Assertion failure in dependencies_clauselist_selectivity with two clauses on the same statistics expression David Rowley
Re: crash in ltree_compare_distance() in 14.24 Chris St Denis
BUG #19817: CREATE UNIQUE INDEX on a partitioned table can silently attach an invalid, not-ready child index, le PG Bug reporting form
BUG #19818: ATTACH PARTITION / CREATE INDEX accept a child index whose deferrable property differs from the pare PG Bug reporting form
BUG #19819: Foreign key DDL can fail with internal errors (XX000) from elog(): "key columns are not both collata PG Bug reporting form
BUG #19820: ANALYZE can store empty (0-dimensional) stavalues that the statistics import functions refuse to res PG Bug reporting form
BUG #19821: pg_restore_attribute_stats() accepts an unsorted scalar histogram_bounds, producing badly wrong row PG Bug reporting form
Re: BUG #19763: ManualBug2 NULL pointer dereference in make_build_data via examine_expression bypass of lookup_var_a Michael Paquier
RE: BUG #19411: libpq 16.x exhibits a memory leak when connections are repeatedly created and destroyed Matt Carter
Re: BUG #19411: libpq 16.x exhibits a memory leak when connections are repeatedly created and destroyed Jacob Champion
Re: BUG #19815: 004_sni.pl fails deterministically with OpenSSL 1.1.1 (tests 75 and 86) Andrey Rachitskiy
Re: BUG #19815: 004_sni.pl fails deterministically with OpenSSL 1.1.1 (tests 75 and 86) Jacob Champion
Re: BUG #19815: 004_sni.pl fails deterministically with OpenSSL 1.1.1 (tests 75 and 86) Andrey Rachitskiy
Re: BUG #19810: to_char(): float V-format overflow yields 'Infinity' or NaN; format after decimal point dropped Andrey Rachitskiy
Re: BUG #19815: 004_sni.pl fails deterministically with OpenSSL 1.1.1 (tests 75 and 86) Andrey Rachitskiy
Re: BUG #19821: pg_restore_attribute_stats() accepts an unsorted scalar histogram_bounds, producing badly wrong row Michael Paquier
Re: BUG #19814: pg_restore_attribute_stats: MCV accepted without eq operator; ANALYZE range slot rejected Michael Paquier
Re: BUG #19815: 004_sni.pl fails deterministically with OpenSSL 1.1.1 (tests 75 and 86) Michael Paquier