pgsql-bugs - February 2024

If you find a bug, please use the bug reporting form.

Search the Archives

(enter a message-id to go directly to that message)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29

Feb. 1, 2024

Thread Author Time
BUG #18320: Duplicate primary key records in table PG Bug reporting form 01:27
Re: BUG #18320: Duplicate primary key records in table vishnu rao 02:32
Re: v17 Possible Union All Bug 📎 Andrei Lepikhov 04:06
BUG #18320: Duplicate primary key records in table David G. Johnston 08:03
Re: v17 Possible Union All Bug 📎 Andrei Lepikhov 09:53
BUG #18321: My first name and my name are reverse PG Bug reporting form 11:54
Re: BUG #18321: My first name and my name are reverse Bruce Momjian 12:40
Re: BUG #18321: My first name and my name are reverse Daniel Gustafsson 12:42
BUG #18322: pg_dump fails with "incorrect version found" (with no good reason) PG Bug reporting form 12:47
Potential data loss due to race condition during logical replication slot creation 📎 Callahan, Drew 22:28
Re: BUG #18322: pg_dump fails with "incorrect version found" (with no good reason) Tom Lane 22:34
Re: STRATEGY=WAL_LOG missing checkpoint interlocks and sync Noah Misch 23:28

Feb. 2, 2024

Thread Author Time
Re: BUG #18319: Logical Replication updates causing duplication of row if evaluation filter is set to the same field Peter Smith 00:35
Re: Potential data loss due to race condition during logical replication slot creation Masahiko Sawada 00:53
Undetected deadlock between primary and standby processes Rintaro.Ikeda 03:10
BUG #18323: Cannot install the best update candidate for package gdal36-libs-3.6.4-5PGDG.rhel9.x86_64 PG Bug reporting form 06:45
Aw: BUG #18312: libpq: PQsetdbLogin() not thread-safe 📎 Christian Maurer 10:10
Aw: BUG #18312: libpq: PQsetdbLogin() not thread-safe Christian Maurer 10:21
BUG #18324: Duplicate value when I insert values in PK column PG Bug reporting form 13:05
Re: BUG #18324: Duplicate value when I insert values in PK column David G. Johnston 13:45
Re: BUG #18324: Duplicate value when I insert values in PK column Laurenz Albe 15:16
Re: Aw: BUG #18312: libpq: PQsetdbLogin() not thread-safe Tom Lane 15:48
Re: "unexpected duplicate for tablespace" problem in logical replication Robert Haas 15:49
Re: v17 Possible Union All Bug Andrei Lepikhov 16:24
Re: BUG #18312: libpq: PQsetdbLogin() not thread-safe Christian Maurer 16:27
Re: BUG #18312: libpq: PQsetdbLogin() not thread-safe 📎 Tom Lane 18:19
BUG #18325: Possible bug with plpgsql function + ALTER TABLE DROP COLUMN PG Bug reporting form 18:39

Feb. 3, 2024

Thread Author Time
Re: Potential data loss due to race condition during logical replication slot creation 📎 Callahan, Drew 03:12
Re: Potential data loss due to race condition during logical replication slot creation 📎 vignesh C 13:48
BUG #18327: Column naming inconsistency for boolean literals in ELSE clauses of CASE expressions. PG Bug reporting form 20:29
BUG #18328: yum update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86 PG Bug reporting form 22:55

Feb. 4, 2024

Thread Author Time
Re: v17 Possible Union All Bug 📎 Andrei Lepikhov 04:57
Re: BUG #18327: Column naming inconsistency for boolean literals in ELSE clauses of CASE expressions. David G. Johnston 19:01
Re: BUG #18327: Column naming inconsistency for boolean literals in ELSE clauses of CASE expressions. Tom Lane 19:57
BUG #18330: The query planner chooses the wrong plan when using the parallel aggregation function PG Bug reporting form 20:35

Feb. 5, 2024

Thread Author Time
Re: BUG #18330: The query planner chooses the wrong plan when using the parallel aggregation function Tom Lane 00:16
Re: Potential data loss due to race condition during logical replication slot creation 📎 Masahiko Sawada 02:06
Re: Potential data loss due to race condition during logical replication slot creation Masahiko Sawada 02:12
BUG #18331: Why is the session lock (DEFAULT_LOCKMETHOD) not automatically released during process exit? PG Bug reporting form 07:28
BUG #18332: The conditional lock cannot be granted even if the process holds a stronger lock PG Bug reporting form 09:54
BUG #18333: Postgres is crashing if we have special character in the query PG Bug reporting form 10:30
BUG #18334: Segfault when running a query with parallel workers PG Bug reporting form 10:58
Re: BUG #18312: libpq: PQsetdbLogin() not thread-safe Christian Maurer 12:49
Re: BUG #18212: Functions txid_status() and pg_xact_status() return invalid status of the specified transaction 📎 Alexander Korotkov 13:51
Re: BUG #18212: Functions txid_status() and pg_xact_status() return invalid status of the specified transaction Karina Litskevich 14:35
Re: BUG #18212: Functions txid_status() and pg_xact_status() return invalid status of the specified transaction 📎 Alexander Korotkov 14:50
Re: BUG #18312: libpq: PQsetdbLogin() not thread-safe Tom Lane 15:24
Re: BUG #18331: Why is the session lock (DEFAULT_LOCKMETHOD) not automatically released during process exit? Tom Lane 16:04
Re: BUG #18328: yum update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86 Marcelo Marques 16:27
PostgreSQL & latest Mac OS Sonoma, a possible bug / configuration issue Arnd Baranowski 19:03
Re: BUG #18312: libpq: PQsetdbLogin() not thread-safe Tom Lane 20:05
Re: PostgreSQL & latest Mac OS Sonoma, a possible bug / configuration issue Tom Lane 20:44
Re: PostgreSQL & latest Mac OS Sonoma, a possible bug / configuration issue Arnd Baranowski 22:00
Re: PostgreSQL & latest Mac OS Sonoma, a possible bug / configuration issue Arnd Baranowski 22:10

Feb. 6, 2024

Thread Author Time
Re: BUG #18333: Postgres is crashing if we have special character in the query Michael Paquier 01:32
Re: BUG #18334: Segfault when running a query with parallel workers Tom Lane 01:51
Re: PostgreSQL & latest Mac OS Sonoma, a possible bug / configuration issue Tom Lane 02:18
Re: PostgreSQL & latest Mac OS Sonoma, a possible bug / configuration issue Arnd Baranowski 08:07
BUG #18335: JDBC Postgress Kerberos authentication does'nt work without JAAS PG Bug reporting form 09:20
Re: BUG #18335: JDBC Postgress Kerberos authentication does'nt work without JAAS Dave Cramer 10:45
Re: BUG #18334: Segfault when running a query with parallel workers Marcin Barczyński 11:30
Re: BUG #18212: Functions txid_status() and pg_xact_status() return invalid status of the specified transaction Karina Litskevich 12:58
Re: BUG #18328: yum update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86 Devrim Gündüz 16:45
Re: BUG #18328: yum update nothing provides libarmadillo.so.12()(64bit) needed by gdal36-libs-3.6.4-6PGDG.rhel9.x86 Marcelo Marques 19:07

Feb. 7, 2024

Thread Author Time
BUG #18336: Inconsistency in PostgreSQL 16 Documentation for SHOW Command PG Bug reporting form 02:25
Re: BUG #18336: Inconsistency in PostgreSQL 16 Documentation for SHOW Command 📎 Laurenz Albe 04:01
Re: BUG #18336: Inconsistency in PostgreSQL 16 Documentation for SHOW Command Peter Eisentraut 07:49
Re: v17 Possible Union All Bug 📎 Alexander Korotkov 09:28
pgjdbc is not working with PKCS8 certificates with password just madhu 09:47
Re: pgjdbc is not working with PKCS8 certificates with password just madhu 11:42
Re: BUG #18314: PARALLEL UNSAFE function does not prevent parallel index build 📎 Tender Wang 11:54
Re: BUG #18315: Segmentation fault on connection (repmgr, psql) Ivan Kalafatić 14:08
Re: pgjdbc is not working with PKCS8 certificates with password Joe Conway 14:52
Re: pgjdbc is not working with PKCS8 certificates with password just madhu 15:23
Re: BUG #18314: PARALLEL UNSAFE function does not prevent parallel index build jian he 15:43
Re: BUG #18336: Inconsistency in PostgreSQL 16 Documentation for SHOW Command 📎 Laurenz Albe 19:53

Feb. 8, 2024

Thread Author Time
Re: v17 Possible Union All Bug Andrei Lepikhov 05:52
Re: Potential data loss due to race condition during logical replication slot creation Masahiko Sawada 05:54
Re: BUG #18314: PARALLEL UNSAFE function does not prevent parallel index build jian he 06:17
Re: BUG #17828: postgres_fdw leaks file descriptors on error and aborts aborted transaction in lack of fds 📎 Etsuro Fujita 12:06
Re: BUG #17828: postgres_fdw leaks file descriptors on error and aborts aborted transaction in lack of fds Tom Lane 17:04
Re: BUG #17828: postgres_fdw leaks file descriptors on error and aborts aborted transaction in lack of fds Andres Freund 21:59
Re: BUG #17828: postgres_fdw leaks file descriptors on error and aborts aborted transaction in lack of fds Tom Lane 22:06
Re: BUG #17828: postgres_fdw leaks file descriptors on error and aborts aborted transaction in lack of fds Tom Lane 23:50

Feb. 9, 2024

Thread Author Time
Re: BUG #17828: postgres_fdw leaks file descriptors on error and aborts aborted transaction in lack of fds Andres Freund 00:07
Re: BUG #17828: postgres_fdw leaks file descriptors on error and aborts aborted transaction in lack of fds Thomas Munro 00:09
Re: BUG #17828: postgres_fdw leaks file descriptors on error and aborts aborted transaction in lack of fds Tom Lane 00:20
Re: BUG #17828: postgres_fdw leaks file descriptors on error and aborts aborted transaction in lack of fds Andres Freund 00:40
Re: BUG #17828: postgres_fdw leaks file descriptors on error and aborts aborted transaction in lack of fds Tom Lane 02:08
Re: BUG #17828: postgres_fdw leaks file descriptors on error and aborts aborted transaction in lack of fds Etsuro Fujita 10:46

Feb. 11, 2024

Thread Author Time
Re: BUG #18334: Segfault when running a query with parallel workers Thomas Munro 21:30

Feb. 12, 2024

Thread Author Time
BUG #18337: Unable to write temp variables path PG Bug reporting form 10:22
Re: BUG #18337: Unable to write temp variables path Manika Singhal 10:45
Re: [E] Re: BUG #18337: Unable to write temp variables path 📎 Reddy, Jaswanth 10:50
BUG #18338: Memory leak in function 'dumpRule' PG Bug reporting form 13:36
Re: BUG #18338: Memory leak in function 'dumpRule' Daniel Gustafsson 14:04
Re: BUG #18338: Memory leak in function 'dumpRule' Heikki Linnakangas 14:09
BUG #18339: Erroneous dependency references of Postgres 15.4 packages when installing 16.2 from GPDG repository PG Bug reporting form 18:44

Feb. 13, 2024

Thread Author Time
BUG #18340: BitString may break nodetoString() conversion for a raw parse tree PG Bug reporting form 09:00
Re: DSA_ALLOC_NO_OOM doesn't work 📎 Heikki Linnakangas 14:23
Re: BUG #18340: BitString may break nodetoString() conversion for a raw parse tree Tom Lane 15:34
BUG #18341: SIGBUS with > 4GB DSM and 'dynamic_shared_memory_type = mmap' PG Bug reporting form 17:32
Re: DSA_ALLOC_NO_OOM doesn't work Thomas Munro 21:17

Feb. 14, 2024

Thread Author Time
Re: DSA_ALLOC_NO_OOM doesn't work Robert Haas 07:23
BUG #18342: pg_rewind copy all files found in pg_wal source directory PG Bug reporting form 10:05
BUG #18343: Incorrect description in postgresql.conf for max_parallel_workers_per_gather PG Bug reporting form 22:11

Feb. 15, 2024

Thread Author Time
BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy PG Bug reporting form 09:00
BUG #18345: Specifying index parameters for a PRIMARY KEY column constraint is a syntax error PG Bug reporting form 11:58
Re: BUG #18345: Specifying index parameters for a PRIMARY KEY column constraint is a syntax error David G. Johnston 13:22
Re: BUG #18343: Incorrect description in postgresql.conf for max_parallel_workers_per_gather Tom Lane 15:55
Re: BUG #18343: Incorrect description in postgresql.conf for max_parallel_workers_per_gather David G. Johnston 16:10
Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy Tom Lane 16:28
Re: BUG #18343: Incorrect description in postgresql.conf for max_parallel_workers_per_gather Christopher Kline 16:29
Re: BUG #18343: Incorrect description in postgresql.conf for max_parallel_workers_per_gather Tom Lane 17:31
Re: BUG #18343: Incorrect description in postgresql.conf for max_parallel_workers_per_gather David G. Johnston 19:41
Re: BUG #18343: Incorrect description in postgresql.conf for max_parallel_workers_per_gather Christopher Kline 20:29
Re: BUG #18343: Incorrect description in postgresql.conf for max_parallel_workers_per_gather Tom Lane 21:30

Feb. 16, 2024

Thread Author Time
Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy David Rowley 02:56
BUG #18346: pg restore issue with generated cloumn in Postgres v13.14 PG Bug reporting form 06:15
UPDATE modifies more rows that it should hubert depesz lubaczewski 09:14
BUG #18347: problem with restore functional index PG Bug reporting form 10:15
Re: UPDATE modifies more rows that it should David Rowley 11:16
Re: BUG #18346: pg restore issue with generated cloumn in Postgres v13.14 David G. Johnston 11:20
Re: UPDATE modifies more rows that it should David Rowley 11:25
BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); PG Bug reporting form 12:06
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); Michael Bondarenko 12:21
Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy 📎 David Rowley 12:32
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); David Rowley 12:44
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); David Rowley 13:02
BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker PG Bug reporting form 13:18
Re: BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker Andrei Lepikhov 14:40
BUG #18350: Modifying predefined roles' unlimited connections for VA STIG cybersecurity checklist PG Bug reporting form 20:50
Re: BUG #18350: Modifying predefined roles' unlimited connections for VA STIG cybersecurity checklist David G. Johnston 21:32
Re: BUG #18350: Modifying predefined roles' unlimited connections for VA STIG cybersecurity checklist Tom Lane 21:35
BUG #18350: Modifying predefined roles' unlimited connections for VA STIG cybersecurity checklist Wetmore, Matthew (CTR) 21:39

Feb. 17, 2024

Thread Author Time
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); jian he 01:47
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); Michael Bondarenko 08:00
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); Francisco Olarte 15:12
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); 📎 Tom Lane 18:14
BUG #18351: VACUUM FULL fails with error: missing chunk number 0 for toast value XXX PG Bug reporting form 20:00
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); 📎 Tom Lane 20:30

Feb. 18, 2024

Thread Author Time
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); jian he 01:48
Postgresql16 dnf install postgresql16-devel.x86_64 fails - Resolve adfile@aol.com 01:51
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); Tom Lane 02:19
Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy 📎 David Rowley 12:53
Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy Tom Lane 16:24
Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy 📎 David Rowley 23:49

Feb. 19, 2024

Thread Author Time
Re: BUG #18350: Modifying predefined roles' unlimited connections for VA STIG cybersecurity checklist Andrew Dunstan 01:02
Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy Tender Wang 08:21
Re: Potential data loss due to race condition during logical replication slot creation 📎 Masahiko Sawada 09:12
Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy Amit Langote 09:45
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); 📎 Tom Lane 17:22

Feb. 20, 2024

Thread Author Time
Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy Alexander Lakhin 03:00
Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy 📎 David Rowley 03:50
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); jian he 03:56
BUG #18352: signature could not be verified for pgdg-common PG Bug reporting form 05:29
Re: BUG #18344: Pruning tables partitioned by bool range fails with invalid strategy David Rowley 05:39
BUG #18353: PG16.2 release note doc bug in "In contrib/bloom, fix overly tight assertion ..." PG Bug reporting form 07:37
Re: BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker Alexey Ermakov 14:05
Re: BUG #18353: PG16.2 release note doc bug in "In contrib/bloom, fix overly tight assertion ..." Tom Lane 16:34
error "can only drop stats once" brings down database Floris Van Nee 17:38
Re: error "can only drop stats once" brings down database Tom Lane 18:49
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); Tom Lane 19:42
Re: BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL); 📎 Tom Lane 20:56
Re: BUG #18352: signature could not be verified for pgdg-common Michael Johnson 22:27

Feb. 21, 2024

Thread Author Time
BUG #18354: Aborted transaction aborted during cleanup when temp_file_limit exceeded PG Bug reporting form 12:00
Re: BUG #18349: ERROR: invalid DSA memory alloc request size 1811939328, CONTEXT: parallel worker Tomas Vondra 12:52
BUG #18356: Casting values from jsonb_each_text does not respect WHERE filter with sub select PG Bug reporting form 19:13
Re: BUG #18356: Casting values from jsonb_each_text does not respect WHERE filter with sub select Ed Herrmann 19:19
Re: DSA_ALLOC_NO_OOM doesn't work 📎 Heikki Linnakangas 19:19
Re: BUG #18356: Casting values from jsonb_each_text does not respect WHERE filter with sub select Tom Lane 20:17
Re: BUG #18356: Casting values from jsonb_each_text does not respect WHERE filter with sub select Laurenz Albe 20:23
Re: BUG #18356: Casting values from jsonb_each_text does not respect WHERE filter with sub select Tom Lane 20:34
Re: BUG #18356: Casting values from jsonb_each_text does not respect WHERE filter with sub select Ed Herrmann 20:51
Re: BUG #18356: Casting values from jsonb_each_text does not respect WHERE filter with sub select Tom Lane 20:56
Re: DSA_ALLOC_NO_OOM doesn't work Thomas Munro 21:30
Re: DSA_ALLOC_NO_OOM doesn't work Thomas Munro 23:03

Feb. 22, 2024

Thread Author Time
Re: DSA_ALLOC_NO_OOM doesn't work Heikki Linnakangas 00:05
Re: BUG #18354: Aborted transaction aborted during cleanup when temp_file_limit exceeded 📎 Kyotaro Horiguchi 02:46
Re: BUG #18354: Aborted transaction aborted during cleanup when temp_file_limit exceeded Tender Wang 03:49
BUG #18357: PGJDBC: how to pass the user defined type as input parameter to store procedure PG Bug reporting form 03:56
Re: DSA_ALLOC_NO_OOM doesn't work Robert Haas 04:25
BUG #18358: I am not able to change the existing SQL connection to Postgres connection in existing application PG Bug reporting form 05:25
Re: BUG #18354: Aborted transaction aborted during cleanup when temp_file_limit exceeded Kyotaro Horiguchi 05:38
Re: BUG #18354: Aborted transaction aborted during cleanup when temp_file_limit exceeded Kyotaro Horiguchi 07:00
Re: BUG #18358: I am not able to change the existing SQL connection to Postgres connection in existing application Daniel Gustafsson 10:15
BUG #18359: autovacuum stopped vacuuming user tables, focusing on just pg_auth_members repeatedly PG Bug reporting form 14:43
JSONB text extraction of data containing tab character fails DEVOPS, Dos (NHS ENGLAND - X26) 15:54
RE: JSONB text extraction of data containing tab character fails Wetmore, Matthew (CTR) 16:40

Feb. 23, 2024

Thread Author Time
Re: BUG #18314: PARALLEL UNSAFE function does not prevent parallel index build jian he 12:21
BUG #18360: Invalid memory access occurs when using geqo PG Bug reporting form 13:00
Re: BUG #18360: Invalid memory access occurs when using geqo Tom Lane 17:45
Re: BUG #18360: Invalid memory access occurs when using geqo 📎 Tom Lane 19:33

Feb. 24, 2024

Thread Author Time
BUG #18361: systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL. PG Bug reporting form 12:51
BUG #18362: unaccent rules and Old Greek text PG Bug reporting form 21:33

Feb. 25, 2024

Thread Author Time
Re: BUG #18362: unaccent rules and Old Greek text Thomas Munro 03:21
systemd[1]: postgresql-16.service: Killing process 25992 (postgres) with signal SIGKILL. Gena Makhomed 08:50
"type with xxxx does not exist" when doing ExecMemoize() 📎 Tender Wang 13:32
BUG #18363: Assert !ReindexIsProcessingIndex falsified with expression index over select from table PG Bug reporting form 18:00
Re: BUG #18363: Assert !ReindexIsProcessingIndex falsified with expression index over select from table Tom Lane 20:37

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29