pgsql-bugs since 2021-08-30 00:00

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

Search the Archives

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

Browse Archives

Prev | Next

Aug. 30, 2021

Thread Author Time
BUG #17167: UndefinedBehaviorSanitizer: invalid-shift-exponent while running int4shr/int4shl PG Bug reporting form 09:02
Re: BUG #17167: UndefinedBehaviorSanitizer: invalid-shift-exponent while running int4shr/int4shl Alexander Lakhin 12:00
Unexpected performance degradation when calling jsonb_path_query() function in PostgreSQL 13.x and 14 beta 📎 Aliaxei Voitsik 12:05
Postgres bug report Jeremy Spray 17:20
BUG #17168: Incorrect sorting PG Bug reporting form 17:50
Re: Postgres bug report David G. Johnston 18:05
Re: BUG #17168: Incorrect sorting David G. Johnston 18:09
Re: BUG #17168: Incorrect sorting Alfonso Vicente 18:16

Aug. 31, 2021

Thread Author Time
Re: BUG #17161: Assert failed on opening a relation that exists in two schemas via the LANGUAGE SQL function 📎 Tom Lane 02:39
BUG #17169: Does PG involve GPL license? PG Bug reporting form 03:32
Re: BUG #17161: Assert failed on opening a relation that exists in two schemas via the LANGUAGE SQL function Alexander Lakhin 04:00
BUG #17170: Invalid collation created with provider icu and initdb' locale C PG Bug reporting form 07:15
BUG #17171: packages for ppc64 PG Bug reporting form 09:25
Re: BUG #17169: Does PG involve GPL license? Tom Lane 13:56
Re: BUG #17161: Assert failed on opening a relation that exists in two schemas via the LANGUAGE SQL function Tom Lane 16:03
Re: BUG #17170: Invalid collation created with provider icu and initdb' locale C Tom Lane 16:34
Re: BUG #17170: Invalid collation created with provider icu and initdb' locale C 📎 Tom Lane 20:10
Re: BUG #17158: Distinct ROW fails with Postgres 14 Tom Lane 20:43

Sept. 1, 2021

Thread Author Time
BUG #17172: NaN compare error in hash agg PG Bug reporting form 02:25
BUG #17173: Primary Key ignored resulting in duplicate values PG Bug reporting form 09:21
BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 PG Bug reporting form 11:17
Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston 13:28
Re: BUG #17173: Primary Key ignored resulting in duplicate values David G. Johnston 13:33
RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 Ram Pratap Maurya 13:46
Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston 13:46
RE: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 Ram Pratap Maurya 13:54
Re: BUG #17174: ERROR: column "min_value" does not exist at character 19 2021-09 David G. Johnston 14:02
Re: BUG #17172: NaN compare error in hash agg Tom Lane 15:40
BUG #17175: The aarch64 repo is missing repomd.xml.asc metadata file, fails GPG verification PG Bug reporting form 15:59
The order of postgresql.conf parameters is potentially confusing. Very minor cosmetic bug or "niggle"! Pól Ua Laoínecháin 16:11
Re: The order of postgresql.conf parameters is potentially confusing. Very minor cosmetic bug or "niggle"! David G. Johnston 16:35
Re: The order of postgresql.conf parameters is potentially confusing. Very minor cosmetic bug or "niggle"! Tom Lane 16:39
Re: Unexpected behavior from using default config value Euler Taveira 17:19
Re: Unexpected behavior from using default config value Tom Lane 19:00
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails 📎 Tom Lane 20:42

Sept. 2, 2021

Thread Author Time
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Etsuro Fujita 02:56
Re: BUG #17126: Server crashes on dropping user while enumerating owned objects that are droppped concurrently Alexander Lakhin 04:00
Re: BUG #17158: Distinct ROW fails with Postgres 14 📎 Peter Eisentraut 08:15
BUG #17176: Error raised on valid query PG Bug reporting form 10:54
Re: BUG #17176: Error raised on valid query Tom Lane 18:52
Re: BUG #17172: NaN compare error in hash agg Tom Lane 21:28

Sept. 3, 2021

Thread Author Time
BUG #17177: Secondary fails to start after upgrade from 13.3 PG Bug reporting form 00:31
BUG #17178: probes.h: No such file or directory when running 'make install' PG Bug reporting form 04:56
Re: BUG #17178: probes.h: No such file or directory when running 'make install' Kevin Burke 05:01
BUG #17179: EOF detected PG Bug reporting form 05:47
Re: BUG #17177: Secondary fails to start after upgrade from 13.3 Kyotaro Horiguchi 11:34
Re: BUG #17178: probes.h: No such file or directory when running 'make install' Tom Lane 13:23
Re: BUG #17179: EOF detected Tom Lane 13:34
Re: BUG #17178: probes.h: No such file or directory when running 'make install' Kevin Burke 14:26
Re: BUG #17177: Secondary fails to start after upgrade from 13.3 Andriy Bartash 18:53
BUG #17181: pg_cancel_backend and pg_terminate_backend fail to work PG Bug reporting form 20:36

Sept. 4, 2021

Thread Author Time
BUG #17182: Race condition on concurrent DROP and CREATE of dependent object PG Bug reporting form 06:00

Sept. 5, 2021

Thread Author Time
Logs vanish after partial log destination change hubert depesz lubaczewski 11:28
Re: BUG #17182: Race condition on concurrent DROP and CREATE of dependent object Tom Lane 14:15
Re: Logs vanish after partial log destination change Tom Lane 14:24

Sept. 6, 2021

Thread Author Time
Re: Logs vanish after partial log destination change hubert depesz lubaczewski 07:57
Re: BUG #16792: silent corruption of GIN index resulting in SELECTs returning non-matching rows Pawel Kudzia 08:18
Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events Tom Lane 19:27

Sept. 7, 2021

Thread Author Time
Re: Unexpected behavior from using default config value Yongqian Li 11:34

Sept. 8, 2021

Thread Author Time
BUG #17183: missing websearch_to_tsquery PG Bug reporting form 02:08
Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data Noah Misch 06:45
BUG #17184: When using openssl, the memory of a static variable is not freed in libpq PG Bug reporting form 07:21
Re: BUG #17183: missing websearch_to_tsquery Julien Rouhaud 07:26
Re: BUG #17158: Distinct ROW fails with Postgres 14 Peter Eisentraut 09:27
BUG #17185: PostgreSQL performance GNU vs LLVM PG Bug reporting form 13:11
Re: BUG #17184: When using openssl, the memory of a static variable is not freed in libpq Tom Lane 13:35
Technical Support Murphy, Kimberly R CTR TRANSCOM TCJ6 (USA) 13:46
Re: Technical Support Daniel Gustafsson 18:27
Duplicate comment on a table ldh@laurent-hasson.com 21:45
Re: Duplicate comment on a table David G. Johnston 22:23

Sept. 9, 2021

Thread Author Time
Re: Technical Support Semab Tariq 04:08
Re: BUG #17184: When using openssl, the memory of a static variable is not freed in libpq Alexander Dzuba 05:32
Segmentation fault on postgresql 13.4, 12.8 with function call in a cursor Tomas Barton 12:50
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails 📎 Etsuro Fujita 15:45
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Tom Lane 16:00
Re: Segmentation fault on postgresql 13.4, 12.8 with function call in a cursor Sergei Kornilov 16:08
Re: Segmentation fault on postgresql 13.4, 12.8 with function call in a cursor Tom Lane 16:14
PG12 → PG13 database conversion anomaly: ERROR: function kepler_start_3(double precision, double precision) does not exist R. Schottland (Lowell) 23:47

Sept. 10, 2021

Thread Author Time
Re: BUG #17184: When using openssl, the memory of a static variable is not freed in libpq Michael Paquier 02:12
BUG #17186: In connect.c, the lock connections_mutex is not correctly released(Line 463) at the return(Line 522) PG Bug reporting form 04:29
Re: BUG #17186: In connect.c, the lock connections_mutex is not correctly released(Line 463) at the return(Line 522) Michael Paquier 07:07
BUG #17187: Incorrect field update operation? PG Bug reporting form 08:57
BUG #17188: Multiple rows are present with same values on a unique column PG Bug reporting form 10:05
Re: BUG #17188: Multiple rows are present with same values on a unique column Ashish Kumar 10:07
Re: BUG #17183: missing websearch_to_tsquery Julien Rouhaud 11:06
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Etsuro Fujita 11:42
Re: BUG #17188: Multiple rows are present with same values on a unique column Julien Rouhaud 11:47
Re: PG12 → PG13 database conversion anomaly: ERROR: function kepler_start_3(double precision, double precision) does not exist David G. Johnston 13:02
Re: BUG #17158: Distinct ROW fails with Postgres 14 📎 Tom Lane 19:27

Sept. 11, 2021

Thread Author Time
Re: BUG #17186: In connect.c, the lock connections_mutex is not correctly released(Line 463) at the return(Line 522) 📎 Michael Paquier 05:38
Re: BUG #17182: Race condition on concurrent DROP and CREATE of dependent object Alexander Lakhin 09:00
Re: pg_upgrade test for binary compatibility of core data types Tom Lane 18:19
Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events 📎 Artur Zakirov 19:55
Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events Tom Lane 22:16

Sept. 12, 2021

Thread Author Time
Re: pg_upgrade test for binary compatibility of core data types 📎 Justin Pryzby 00:51
Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events 📎 Tom Lane 17:29
Re: pg_upgrade test for binary compatibility of core data types Andrew Dunstan 18:41

Sept. 13, 2021

Thread Author Time
Re: BUG #17184: When using openssl, the memory of a static variable is not freed in libpq Kyotaro Horiguchi 02:59
Re: BUG #17186: In connect.c, the lock connections_mutex is not correctly released(Line 463) at the return(Line 522) Michael Paquier 04:37
BUG #17189: Index not created when primary key created PG Bug reporting form 05:27
BUG #17190: lock contention high in postgreSQL13.3 wrt GCC/llvm PG Bug reporting form 05:32
Re: BUG #17189: Index not created when primary key created Pavel Stehule 09:24
Re: BUG #17189: Index not created when primary key created hubert depesz lubaczewski 10:36
BUG #17191: Docker / buildx issue - An image created with buildx requires to set custom PGDATA location PG Bug reporting form 12:27
Re: BUG #17189: Index not created when primary key created David G. Johnston 12:56
Re: pg_upgrade test for binary compatibility of core data types 📎 Andrew Dunstan 13:20
Re: BUG #17185: PostgreSQL performance GNU vs LLVM arjun shetty 13:59
Re: BUG #17191: Docker / buildx issue - An image created with buildx requires to set custom PGDATA location Euler Taveira 14:06
Re: BUG #17185: PostgreSQL performance GNU vs LLVM Euler Taveira 14:13

Sept. 14, 2021

Thread Author Time
[BUG] Deadlock detected when update with multiple clients 📎 tanghy.fnst@fujitsu.com 03:03
Re: [BUG] Deadlock detected when update with multiple clients hubert depesz lubaczewski 07:00
BUG #17192: The csvlog is corrupted PG Bug reporting form 09:47
BUG #17193: Issue with pg_output login PG Bug reporting form 13:44
Re: BUG #17158: Distinct ROW fails with Postgres 14 📎 Peter Eisentraut 14:39
Re: BUG #17158: Distinct ROW fails with Postgres 14 Tom Lane 15:02
Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events 📎 Tom Lane 21:56

Sept. 15, 2021

Thread Author Time
bugs or my fault Yudianto Prasetyo 06:28
Re: bugs or my fault Yudianto Prasetyo 06:30
Re: bugs or my fault Peter Smith 10:16
Re: BUG #17158: Distinct ROW fails with Postgres 14 Peter Eisentraut 10:26
Re: bugs or my fault Yudianto Prasetyo 10:38
Re: BUG #15293: Stored Procedure Triggered by Logical Replication is Unable to use Notification Events Artur Zakirov 12:03
Re: bugs or my fault Sergei Kornilov 12:36
Re: bugs or my fault Yudianto Prasetyo 12:44
Re: bugs or my fault Sergei Kornilov 13:38
Re: bugs or my fault Yudianto Prasetyo 14:16
RE: BUG #17192: The csvlog is corrupted Jef Vervecken 14:41
Re: BUG #17193: Issue with pg_output login Euler Taveira 18:46
Re: BUG #17193: Issue with pg_output login Sushant Kamboj 18:53
Re: pg_upgrade test for binary compatibility of core data types Andrew Dunstan 19:28

Sept. 16, 2021

Thread Author Time
Re: BUG #17193: Issue with pg_output login Sushant Kamboj 12:36

Sept. 17, 2021

Thread Author Time
Query planning on partitioned table causes postgres 13.4 to consume all memory 📎 Duncan Sands 09:49
Re: BUG #17070: Sometimes copy from ingnores transaction Дмитрий Секретов 11:13
BUG #17194: Issue with pgoutput PG Bug reporting form 12:17

Sept. 18, 2021

Thread Author Time
Re: BUG #17070: Sometimes copy from ingnores transaction Noah Misch 03:18
Re: BUG #17061: Impossible to query the fields of the tuple created by SEARCH BREADTH FIRST BY .. SET .. Jaime Casanova 22:20

Sept. 19, 2021

Thread Author Time
BUG #17195: Can't bind $1::int param when I use COPY TO STDOUT statement - libpq, C++ PG Bug reporting form 09:17
Re: BUG #17061: Impossible to query the fields of the tuple created by SEARCH BREADTH FIRST BY .. SET .. Tom Lane 14:20
Re: BUG #17194: Issue with pgoutput Tom Lane 15:04
Re: BUG #17195: Can't bind $1::int param when I use COPY TO STDOUT statement - libpq, C++ Tom Lane 15:08
Re: Query planning on partitioned table causes postgres 13.4 to consume all memory Tom Lane 16:03

Sept. 20, 2021

Thread Author Time
Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data 📎 Noah Misch 04:41
BUG #17196: old_snapshot_threshold is not honored if there is a transaction PG Bug reporting form 06:14
Re: Query planning on partitioned table causes postgres 13.4 to consume all memory Duncan Sands 12:10
BUG #17197: Assert failed on inserting index tuples after VACUUM PG Bug reporting form 19:00
Re: BUG #17197: Assert failed on inserting index tuples after VACUUM Peter Geoghegan 20:35
Re: BUG #17197: Assert failed on inserting index tuples after VACUUM Peter Geoghegan 21:03

Sept. 21, 2021

Thread Author Time
BUG #17198: Planning time too high when execute query on standby cluster PG Bug reporting form 00:18
Re: BUG #17197: Assert failed on inserting index tuples after VACUUM Alexander Lakhin 05:00
Re: Inconsistent behavior of pg_dump/pg_restore on DEFAULT PRIVILEGES 📎 Boris P. Korzun 05:04
Re: BUG #17189: Index not created when primary key created Puneet Sharma 06:04
Re: BUG #17198: Planning time too high when execute query on standby cluster Magnus Hagander 06:55
Re: BUG #17189: Index not created when primary key created Jaime Casanova 08:23
Re: BUG #17189: Index not created when primary key created Puneet Sharma 10:49
BUG #17199: Calling stored procedure with stable function as argument results in wrong result PG Bug reporting form 12:52
Re: BUG #17199: Calling stored procedure with stable function as argument results in wrong result Tom Lane 15:01
Re: BUG #17199: Calling stored procedure with stable function as argument results in wrong result 📎 Tom Lane 15:49
Re: BUG #17198: Planning time too high when execute query on standby cluster Andriy Bartash 16:27
Re: BUG #17193: Issue with pg_output login Euler Taveira 20:46
Re: BUG #17193: Issue with pg_output login Gerdan Rezende dos Santos 21:09

Sept. 22, 2021

Thread Author Time
Re: Inconsistent behavior of pg_dump/pg_restore on DEFAULT PRIVILEGES Neil Chen 01:30
Re: BUG #17193: Issue with pg_output login Ashish Kumar 06:59
BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)? PG Bug reporting form 13:17
Internal error with types changes and prepared statements Daniele Varrazzo 18:13
Re: Internal error with types changes and prepared statements Tom Lane 18:27
Re: Internal error with types changes and prepared statements Daniele Varrazzo 18:32

Sept. 23, 2021

Thread Author Time
Re: BUG #17197: Assert failed on inserting index tuples after VACUUM Peter Geoghegan 02:22
Re: BUG #17183: missing websearch_to_tsquery Budi Setiawan 04:44
BUG #17201: Pg_largeobject table grows uncontrollably PG Bug reporting form 08:30
BUG #17202: GENERATED BY DEFAULT AS IDENTITY not inherited (but SERIAL is) PG Bug reporting form 21:14

Sept. 24, 2021

Thread Author Time
Re: BUG #17202: GENERATED BY DEFAULT AS IDENTITY not inherited (but SERIAL is) Japin Li 02:32
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Etsuro Fujita 08:36
Re: BUG #17202: GENERATED BY DEFAULT AS IDENTITY not inherited (but SERIAL is) Erik Huelsmann 10:04
Re: pg_upgrade test for binary compatibility of core data types Andrew Dunstan 14:58
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails 📎 Tom Lane 19:11

Sept. 25, 2021

Thread Author Time
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Etsuro Fujita 13:55
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Tom Lane 13:59
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Tom Lane 14:59
Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data 📎 Andrey Borodin 17:25
Re: CREATE INDEX CONCURRENTLY does not index prepared xact's data Noah Misch 20:10

Sept. 26, 2021

Thread Author Time
Re: BUG #16583: merge join on tables with different DB collation behind postgres_fdw fails Etsuro Fujita 08:56

Sept. 27, 2021

Thread Author Time
Snapshot leak warning with lo_export in subtransaction 📎 Heikki Linnakangas 10:55
Re: Snapshot leak warning with lo_export in subtransaction Alvaro Herrera 12:33

Sept. 28, 2021

Thread Author Time
Re: BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)? hpc researcher_mspk 06:15
pg_basebackup behavior on non-existent slot 📎 Dimitri Fontaine 09:50
Re: pg_basebackup behavior on non-existent slot Magnus Hagander 10:25
Re: [EXTERNAL] Re: pg_basebackup behavior on non-existent slot Dimitri Fontaine 11:12
v.13.3 Trigger Before Insert Max Tomich 12:57
Re: BUG #17200: PostgreSQL-Support Profile Guide Optimization(Clang/GCC)? Tom Lane 13:39

Sept. 29, 2021

Thread Author Time
BUG #17203: missing websearch_to_tsquery PG Bug reporting form 03:09
Re: [EXTERNAL] pg_basebackup behavior on non-existent slot Daniel Gustafsson 09:24
Re: BUG #17203: missing websearch_to_tsquery Tom Lane 13:36
BUG #17204: Import PostgreSQL view to ADO.NET Entity Framework Model PG Bug reporting form 13:42

Sept. 30, 2021

Thread Author Time
BUG #17205: pg_class.reltuples vakue wrong for brin indexes after vacuum (by many orders of magnitude) PG Bug reporting form 07:19
Bug report function to_date should reject HH24:MI:SS formatting options Sébastien Caunes 09:03
Re: Bug report function to_date should reject HH24:MI:SS formatting options Tom Lane 13:35
Re: Bug report function to_date should reject HH24:MI:SS formatting options Sébastien Caunes 14:10
BUG #17206: the function array_cat(anyarray, anyarray) does not exist PG Bug reporting form 20:54
Re: BUG #17206: the function array_cat(anyarray, anyarray) does not exist David G. Johnston 22:49
BUG #17207: Bad cost estimate of Merge Join despite correct row estimate PG Bug reporting form 23:29

Browse Archives

Prev | Next