Mailing lists [pgsql-bugs]

4 October

• 00:34   Re: BUG #19741: `avg(double precision)` overflows on cancelling finite inputs whose mean is representable Tom Lane
• 00:53   Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" Tom Lane
• 00:58   Re: BUG #19739: Parameterized first autocommit statement can have different `transaction_timestamp()` and `statement Tom Lane
• 04:00   Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" Tom Lane
• 08:10   BUG #19743: pgcrypto crypt(): sha-crypt rounds= silently wraps modulo 2^32 PG Bug reporting form
• 08:16   BUG #19744: contrib/seg output truncates to 6 significant digits, breaking dump/restore PG Bug reporting form
• 08:17   BUG #19745: tsquery input: 33 nested "!" raise XX000 via elog(), escaping pg_input_is_valid() PG Bug reporting form
• 08:18   BUG #19746: interval with INT64_MIN microseconds prints a value interval_in rejects PG Bug reporting form
• 08:19   BUG #19747: pg_dump does not pin array_nulls, so restore mangles NULL array elements PG Bug reporting form
• 08:19   BUG #19748: tsvectorrecv accepts duplicate lexemes and position 0 that tsvectorin rejects PG Bug reporting form
• 08:20   BUG #19749: bpchar_ops declares equalimage although bpchar equality ignores trailing spaces PG Bug reporting form
• 08:23   Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" shihao zhong
• 08:33   BUG #19750: tsquery output omits parentheses, so the text reparses to a different value PG Bug reporting form
• 08:37   Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" David Rowley
• 08:42   Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" Tom Lane
• 12:51   Re: BUG #19725: PostgreSQL 18.6: pg_restore read failure with io_uring, not observed with worker weijie JL
• 16:12   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
• 16:39   Re: BUG #19740: `has_language_privilege` returns TRUE for a nonexistent language OID when the user is a superuser Laurenz Albe
• 16:54   Re: BUG #19738: `uuidv7(interval)` rejects sub-millisecond timestamps within the final 48-bit millisecond Laurenz Albe
• 18:04   Issue Installing PostGIS via Stack Builder on MacBook (Apple Silicon / ARM64) – Application Buffers/Freezes Hariharan Murugesan
• 19:03   Re: BUG #19738: `uuidv7(interval)` rejects sub-millisecond timestamps within the final 48-bit millisecond Tom Lane
• 19:14   Re: BUG #19737: Empty `JSON_OBJECT` cannot use documented `ON NULL` or unique-key clauses jian he
• 20:01   Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" Tom Lane
• 21:41   Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" shihao zhong
• 22:38   Re: BUG #19735: `jsonb_object_agg_unique_strict` drops a JSONB `null` value as if it were SQL NULL shihao zhong
• 22:39   Re: BUG #19742: `INTERSECT` under a `UNION ALL` with an empty arm fails with "could not find pathkey item t" Tom Lane