pgsql-bugs since 2023-06-20 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)
Advanced Search

Browse Archives

Prev | Next

June 20, 2023

Thread Author Time
Re: BUG #17949: Adding an index introduces serialisation anomalies. 📎 Thomas Munro 01:22
Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Michael Paquier 06:41
Re: BUG #17983: Assert IsTransactionState() failed when empty string statement prepared in aborted transaction 📎 Japin Li 08:17
Re: BUG #17976: Inconsistent results of SELECT using CASE WHEN clause Amit Kapila 09:25
BUG #17984: Service stopped and cannot restart PG Bug reporting form 14:39
BUG #17985: Inconsistent results of SELECT comparing two CASE WHEN clause PG Bug reporting form 16:03
Re: BUG #17983: Assert IsTransactionState() failed when empty string statement prepared in aborted transaction 📎 Tom Lane 16:32
Re: BUG #17984: Service stopped and cannot restart David G. Johnston 16:34
Re: BUG #17985: Inconsistent results of SELECT comparing two CASE WHEN clause 📎 Tom Lane 18:40
BUG #17986: Inconsistent results of SELECT affected by btree index PG Bug reporting form 20:54
Re: BUG #17985: Inconsistent results of SELECT comparing two CASE WHEN clause 📎 Tom Lane 20:59
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 22:02
Re: BUG #17949: Adding an index introduces serialisation anomalies. Thomas Munro 22:54
Re: BUG #17975: Nested Loop Index Scan returning wrong result 📎 David Rowley 23:01
Re: BUG #17949: Adding an index introduces serialisation anomalies. Thomas Munro 23:20
Re: BUG #17986: Inconsistent results of SELECT affected by btree index Tomas Vondra 23:40

June 21, 2023

Thread Author Time
Re: BUG #17983: Assert IsTransactionState() failed when empty string statement prepared in aborted transaction Japin Li 01:45
Re: BUG #17973: Reinit of pgstats entry for dropped DB can break autovacuum daemon Andres Freund 03:59
Re: BUG #17986: Inconsistent results of SELECT affected by btree index Tom Lane 04:11
Re: BUG #17978: Unexpected error: "wrong varnullingrels (b) (expected (b 5)) for Var 6/2" triggered by JOIN Richard Guo 07:20
Re: BUG #17986: Inconsistent results of SELECT affected by btree index Zu-Ming Jiang 07:22
Re: BUG #17949: Adding an index introduces serialisation anomalies. Dmitry Dolgov 08:58
Re: BUG #17949: Adding an index introduces serialisation anomalies. Dmitry Dolgov 09:04
BUG #17987: zypper refresh failed when installed the postgresql PG Bug reporting form 09:17
Re: BUG #17987: zypper refresh failed when installed the postgresql Laurenz Albe 11:17
Re: BUG #17986: Inconsistent results of SELECT affected by btree index Tom Lane 13:25
Re:Re: BUG #17987: zypper refresh failed when installed the postgresql 270246512 14:14
Re: Re: BUG #17987: zypper refresh failed when installed the postgresql Laurenz Albe 16:08
BUG #17988: psql generates segfault when connecting to remote database PG Bug reporting form 17:58
Re: BUG #17988: psql generates segfault when connecting to remote database Tom Lane 20:52
Small subset of man pages available after install from Redhat-compatible repo Linus Hicks 21:16

June 22, 2023

Thread Author Time
Re: Small subset of man pages available after install from Redhat-compatible repo Laurenz Albe 06:39
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Heikki Linnakangas 07:26
Re: BUG #17949: Adding an index introduces serialisation anomalies. Thomas Munro 10:02
BUG #17989: ERROR: could not open file "pg_logical/snapshots/6-1E182808.snap": Permission denied PG Bug reporting form 10:26
BUG #17990: PSQL Process hangs in parallel mode PG Bug reporting form 20:41
BUG #17991: FATAL: cannot request additional shared memory outside shmem_request_hook PG Bug reporting form 23:17

June 23, 2023

Thread Author Time
BUG #17992: Followed instructions to setup Postgresql but systemctl restart postgresql-15.service PG Bug reporting form 08:27
Re: BUG #17991: FATAL: cannot request additional shared memory outside shmem_request_hook Laurenz Albe 09:37
Re: BUG #17991: FATAL: cannot request additional shared memory outside shmem_request_hook Julien Rouhaud 11:09
Re: BUG #17949: Adding an index introduces serialisation anomalies. Dmitry Dolgov 14:05
Server closed the connection unexpectedly (memory leak) 📎 Zu-Ming Jiang 16:06
Fwd: Server closed the connection unexpectedly (memory leak) 📎 Zu-Ming Jiang 16:20

June 24, 2023

Thread Author Time
BUG #17993: FK issue on logical replication table PG Bug reporting form 06:01
BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() PG Bug reporting form 13:00
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG 📎 Joe Conway 13:09
Re: BUG #17949: Adding an index introduces serialisation anomalies. Dmitry Dolgov 13:59
Re: Server closed the connection unexpectedly (memory leak) Tom Lane 16:56
BUG #17995: Segmentation fault caused by UPDATE statement PG Bug reporting form 18:33
Re: BUG #17995: Segmentation fault caused by UPDATE statement Tom Lane 19:51
Re: BUG #17995: Segmentation fault caused by UPDATE statement Willian Colognesi 20:48

June 25, 2023

Thread Author Time
Re: BUG #17995: Segmentation fault caused by UPDATE statement Alexander Lakhin 03:00
range canonicalization function make corner case failed. jian he 03:12
BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index PG Bug reporting form 12:00
Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index Tom Lane 14:40
Re: BUG #17990: PSQL Process hangs in parallel mode Thomas Munro 22:12

June 26, 2023

Thread Author Time
Re: BUG #17949: Adding an index introduces serialisation anomalies. 📎 Thomas Munro 00:25
Re: BUG #17949: Adding an index introduces serialisation anomalies. Peter Geoghegan 02:52
BUG #17998: Postgres crashes when executing WorkTableScan. PG Bug reporting form 03:47
回复: BUG #17998: Postgres crashes when executing WorkTableScan. 梁 成林 03:53
Re: BUG #17995: Segmentation fault caused by UPDATE statement Michael Paquier 04:21
Re: BUG #17995: Segmentation fault caused by UPDATE statement Tom Lane 04:27
Re: BUG #17993: FK issue on logical replication table Amit Kapila 04:42
Re: BUG #17995: Segmentation fault caused by UPDATE statement Michael Paquier 04:56
Re: BUG #17995: Segmentation fault caused by UPDATE statement Alexander Lakhin 05:00
Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index Michael Paquier 06:49
BUG #17999: comment to BUG 17990 (PSQL Process hangs in parallel mode) PG Bug reporting form 07:06
BUG #18000: Access method used by matview can be dropped leaving broken matview PG Bug reporting form 08:00
Re: BUG #17949: Adding an index introduces serialisation anomalies. Heikki Linnakangas 08:04
Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index 📎 Michael Paquier 08:05
Re: BUG #18000: Access method used by matview can be dropped leaving broken matview Michael Paquier 08:35
Re: BUG #17998: Postgres crashes when executing WorkTableScan. Heikki Linnakangas 08:43
BUG #18001: Invalid subquery passed as true PG Bug reporting form 10:07
Re: BUG #18001: Invalid subquery passed as true Julien Rouhaud 11:34
Re: BUG #17949: Adding an index introduces serialisation anomalies. Thomas Munro 23:48

June 27, 2023

Thread Author Time
Re: BUG #18000: Access method used by matview can be dropped leaving broken matview 📎 Michael Paquier 04:50
Re: No -d option bowen zhao 05:52
Re: BUG #18000: Access method used by matview can be dropped leaving broken matview 📎 Michael Paquier 06:33
Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index Alexander Lakhin 11:00
BUG #18002: Duplicate entries of row possible even after having primary key PG Bug reporting form 11:03
Re: BUG #18000: Access method used by matview can be dropped leaving broken matview Nathan Bossart 17:03
Re: BUG #18000: Access method used by matview can be dropped leaving broken matview Andres Freund 18:23
BUG #18003: FATAL: cannot request additional shared memory outside shmem_request_hook PG Bug reporting form 20:27
Re: BUG #18002: Duplicate entries of row possible even after having primary key Andres Freund 20:36
Re: BUG #18003: FATAL: cannot request additional shared memory outside shmem_request_hook Joe Conway 21:06
Re: BUG #18003: FATAL: cannot request additional shared memory outside shmem_request_hook Andres Freund 21:24
Re: BUG #18003: FATAL: cannot request additional shared memory outside shmem_request_hook Tom Lane 21:44
Re: BUG #18000: Access method used by matview can be dropped leaving broken matview 📎 Michael Paquier 23:11
Re: BUG #18000: Access method used by matview can be dropped leaving broken matview Michael Paquier 23:19

June 28, 2023

Thread Author Time
Re: BUG #18003: FATAL: cannot request additional shared memory outside shmem_request_hook Andres Freund 00:03
Re: BUG #17949: Adding an index introduces serialisation anomalies. 📎 Thomas Munro 03:18
Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index Alexander Lakhin 06:00
Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index Michael Paquier 07:02
RE: BUG #18002: Duplicate entries of row possible even after having primary key Ajinkya Tankhiwale 08:38
Re: BUG #18002: Duplicate entries of row possible even after having primary key David Rowley 10:28
Re: pg_rewind WAL segments deletion pitfall 📎 torikoshia 13:28
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() 📎 Tom Lane 18:49
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andres Freund 19:44
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Tom Lane 19:52
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andres Freund 20:54
Re: BUG #18002: Duplicate entries of row possible even after having primary key Andres Freund 20:59
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 21:57
Re: BUG #18000: Access method used by matview can be dropped leaving broken matview 📎 Michael Paquier 22:57

June 29, 2023

Thread Author Time
Re: pg_rewind WAL segments deletion pitfall Kyotaro Horiguchi 01:25
Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index 📎 Michael Paquier 02:22
BUG #18005: PSQL Process hangs in parallel mode PG Bug reporting form 06:15
BUG #18006: recovery_target_action=shutdown triggers automatic recovery on next startup (beyond point in time) PG Bug reporting form 08:04
Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index Alexander Lakhin 09:00
Re: pg_rewind WAL segments deletion pitfall torikoshia 09:42
Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index Michael Paquier 10:39
Re: BUG #18005: PSQL Process hangs in parallel mode Laurenz Albe 11:46
RE: BUG #18002: Duplicate entries of row possible even after having primary key Ajinkya Tankhiwale 12:12
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 13:56
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Tom Lane 14:26
Re: pg_dump needs SELECT privileges on irrelevant extension table 📎 Jacob Champion 16:24
BUG #18007: age(timestamp, timestamp) is marked as immutable, but using age(date, date) says it's not PG Bug reporting form 17:08
Re: BUG #18007: age(timestamp, timestamp) is marked as immutable, but using age(date, date) says it's not David G. Johnston 17:45
Re: BUG #18007: age(timestamp, timestamp) is marked as immutable, but using age(date, date) says it's not Tom Lane 17:52
Re: BUG #18007: age(timestamp, timestamp) is marked as immutable, but using age(date, date) says it's not Braiam 18:20
Re: BUG #18007: age(timestamp, timestamp) is marked as immutable, but using age(date, date) says it's not Braiam 18:23
Re: BUG #18007: age(timestamp, timestamp) is marked as immutable, but using age(date, date) says it's not Tom Lane 18:24
Re: BUG #18007: age(timestamp, timestamp) is marked as immutable, but using age(date, date) says it's not Braiam 18:29
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 18:57
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Tom Lane 19:25
Re: BUG #18007: age(timestamp, timestamp) is marked as immutable, but using age(date, date) says it's not Christophe Pettus 19:25
Re: BUG #18007: age(timestamp, timestamp) is marked as immutable, but using age(date, date) says it's not Braiam 19:58
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 20:30
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Tom Lane 22:41

June 30, 2023

Thread Author Time
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 02:13
Re: BUG #18006: recovery_target_action=shutdown triggers automatic recovery on next startup (beyond point in time) Kyotaro Horiguchi 02:50
Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index Alexander Lakhin 04:00
Re: BUG #17997: Assert failed in validatePartitionedIndex() when attaching partition index to child of valid index Michael Paquier 05:59
BUG #18008: SSL certificate error for Stackbuilder 4.2.1 PG Bug reporting form 09:44
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 12:11
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 12:13
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Tom Lane 12:46
BUG #18005: PSQL Process hangs in parallel mode / complement information 📎 ess.bee59 13:19
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 13:23
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Tom Lane 13:43
BUG #18009: Postgres Recovery not happening PG Bug reporting form 13:46
Re: BUG #18008: SSL certificate error for Stackbuilder 4.2.1 Laurenz Albe 16:09
Toasted column values during replication. (Enhancement) Chandy G 17:10
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 18:43
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Tom Lane 19:08

July 1, 2023

Thread Author Time
Re: Server closed the connection unexpectedly (memory leak) Andres Freund 02:56
BUG #18010: Bug with installation/auto-configuration PG Bug reporting form 04:45
BUG #18011: Declarative partition privilege problem cause incorrect execution plans PG Bug reporting form 07:54
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() 📎 Andrew Dunstan 13:14
BUG #18005: PSQL Process hangs in parallel mode / complement information 📎 ess.bee59 14:37
Re: BUG #18011: Declarative partition privilege problem cause incorrect execution plans David Rowley 21:11

July 2, 2023

Thread Author Time
BUG #18012: Installer fails to run .bat files when they are registered to Notepad++ PG Bug reporting form 06:42
Re: BUG #18002: Duplicate entries of row possible even after having primary key David Rowley 21:53
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andres Freund 21:54
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Tom Lane 21:57
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andres Freund 22:13
Re: BUG #18009: Postgres Recovery not happening Thomas Munro 22:27

July 3, 2023

Thread Author Time
Re: BUG #18002: Duplicate entries of row possible even after having primary key Peter Geoghegan 01:06
Re: BUG #17994: Invalidating relcache corrupts tupDesc inside ExecEvalFieldStoreDeForm() Andrew Dunstan 02:15
Re: BUG #18000: Access method used by matview can be dropped leaving broken matview Michael Paquier 02:26
Re: BUG #17968: installation Sandeep Thakkar 06:46
BUG #18013: Failed installing PG Bug reporting form 08:41
Re: Toasted column values during replication. (Enhancement) Amit Kapila 08:50
group by can use alias from select list but not the having clause 📎 hape Hape 09:43
Backend handling replication slot stuck using 100% cpu, unkillable hubert depesz lubaczewski 11:36
Re: Backend handling replication slot stuck using 100% cpu, unkillable hubert depesz lubaczewski 12:58
Re: group by can use alias from select list but not the having clause David G. Johnston 13:41
回复: BUG #18011: Declarative partition privilege problem cause incorrect execution plans liu zhilong 13:51
Re: group by can use alias from select list but not the having clause Tom Lane 14:12
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG 📎 Tristan Partin 14:42
Re: group by can use alias from select list but not the having clause Pantelis Theodosiou 14:57
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 16:17
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 16:25
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 16:28
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Joe Conway 16:31
Re: BUG #17949: Adding an index introduces serialisation anomalies. Thomas Munro 22:02

July 4, 2023

Thread Author Time
Re: Backend handling replication slot stuck using 100% cpu, unkillable shveta malik 03:26
Re: BUG #18012: Installer fails to run .bat files when they are registered to Notepad++ Sandeep Thakkar 10:54
BUG #18014: Releasing catcache entries makes schema_to_xmlschema() fail when parallel workers are used PG Bug reporting form 11:00
Re: Backend handling replication slot stuck using 100% cpu, unkillable Tomas Vondra 11:30
Re: Backend handling replication slot stuck using 100% cpu, unkillable hubert depesz lubaczewski 11:52
Re: Backend handling replication slot stuck using 100% cpu, unkillable hubert depesz lubaczewski 11:53
Re: Backend handling replication slot stuck using 100% cpu, unkillable Tomas Vondra 13:04
Re: BUG #18009: Postgres Recovery not happening Vamshikrishna T 13:48
Re: Backend handling replication slot stuck using 100% cpu, unkillable hubert depesz lubaczewski 13:55
Re: BUG #17695: Failed Assert in logical replication snapbuild. Daniel Gustafsson 15:43
XML column causes record to be both NULL and NOT NULL Wilm Hoyer 18:46
Re: XML column causes record to be both NULL and NOT NULL Tom Lane 18:59

July 5, 2023

Thread Author Time
Re: BUG #17695: Failed Assert in logical replication snapbuild. Masahiko Sawada 01:23
Re: BUG #18009: Postgres Recovery not happening Thomas Munro 03:35
AW: XML column causes record to be both NULL and NOT NULL Wilm Hoyer 06:43
BUG #18015: missing dependency packages for postgis extension PG Bug reporting form 08:54
Fwd: BUG #18015: missing dependency packages for postgis extension Laurenz Albe 13:29
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 20:45
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG Tristan Partin 20:53
Re: BUG #17946: LC_MONETARY & DO LANGUAGE plperl - BUG 📎 Tristan Partin 20:55
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower 📎 David Rowley 23:55

July 6, 2023

Thread Author Time
The same 2PC data maybe recovered twice 蔡梦娟 (玊于) 02:02
Re: BUG #17540: Prepared statement: PG switches to a generic query plan which is consistently much slower Richard Guo 09:26
Re: BUG #17968: installation Sandeep Thakkar 13:44
BUG #18016: REINDEX TABLE failure PG Bug reporting form 20:29

Browse Archives

Prev | Next