pgsql-bugs since 2020-01-29 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

Jan. 29, 2020

Thread Author Time
Don't try fetching future segment of a TLI. 📎 Kyotaro Horiguchi 03:02
Re: postgres crash on concurrent update of inheritance partitioned table Oleksii Kliukin 09:20
Re: BUG #16109: Postgres planning time is high across version (Expose buffer usage during planning in EXPLAIN) 📎 Julien Rouhaud 11:15
Segmentation Fault (Logical Replication) M Rehman Kahloon 12:22
Re: BUG #16223: Performance regression between 11.6 and 12.1 in an SQL query with a recursive CTE based on function Christian Schwaderer 13:49
Re: BUG #16223: Performance regression between 11.6 and 12.1 in an SQL query with a recursive CTE based on function Tom Lane 15:18
Re: Segmentation Fault (Logical Replication) Tom Lane 15:25
Re: BUG #16223: Performance regression between 11.6 and 12.1 in an SQL query with a recursive CTE based on function Kieran McCusker 15:31
Re: incorrect pg_dump output due to not handling dropped roles correctly Stephen Frost 19:07
Re: incorrect pg_dump output due to not handling dropped roles correctly Tom Lane 19:46
Re: incorrect pg_dump output due to not handling dropped roles correctly Stephen Frost 20:42

Jan. 30, 2020

Thread Author Time
Re: Segmentation Fault (Logical Replication) Michael Paquier 02:30
Re: ERROR: subtransaction logged without previous top-level txn record Maurizio Sambati 10:13
BUG #16236: Invalid escape encoding 📎 Stéphane Campinas 10:26
BUG #16238: Function " to_char(timestamp, text) " doesn't work properly PG Bug reporting form 11:49
Bug in display of commit logs on git.postgresql.org hubert depesz lubaczewski 12:02
Re: BUG #16238: Function " to_char(timestamp, text) " doesn't work properly hubert depesz lubaczewski 12:48
Re: Bug in display of commit logs on git.postgresql.org Michael Paquier 13:06
Re: Moderate Error in German help of pg_ctl 📎 Daniel Gustafsson 14:12
Re: BUG #16236: Invalid escape encoding Tom Lane 15:29
RE: [EXTERNAL] Re: BUG #16131: pg_upgrade 9 -> 11.6 and a database is missing Walker, Jared (Contractor) 16:21
Re: BUG #16238: Function " to_char(timestamp, text) " doesn't work properly Tom Lane 16:27
Re: Moderate Error in German help of pg_ctl Peter Eisentraut 17:55
Re: ERROR: subtransaction logged without previous top-level txn record Dan Katz 20:09
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher 21:22
Re: BUG #16238: Function " to_char(timestamp, text) " doesn't work properly Nick Memos 22:57
auto_explain logs ERROR: 08P01 for every query using bind variable Ted Liu 23:04

Jan. 31, 2020

Thread Author Time
BUG #16239: It is not possible to upgrade the password from md5 to SCRAM PG Bug reporting form 11:44
Re: BUG #16184: Segmentation Fault during update Piotr Włodarczyk 12:59
Re: BUG #16239: It is not possible to upgrade the password from md5 to SCRAM Peter Eisentraut 13:21
Re: auto_explain logs ERROR: 08P01 for every query using bind variable Jeff Janes 14:52
Re: auto_explain logs ERROR: 08P01 for every query using bind variable Ted Liu 15:54
Re: auto_explain logs ERROR: 08P01 for every query using bind variable Tom Lane 17:11
Re: BUG #16184: Segmentation Fault during update Tom Lane 17:41
Re: BUG #16184: Segmentation Fault during update Piotr Włodarczyk 22:25
Re: BUG #16184: Segmentation Fault during update Tom Lane 22:30
Re: BUG #16184: Segmentation Fault during update Piotr Włodarczyk 22:32

Feb. 1, 2020

Thread Author Time
Re: Don't try fetching future segment of a TLI. David Steele 05:31
Re: BUG #16171: Potential malformed JSON in explain output 📎 Tom Lane 19:37
Unable to trigger createdb Jack Plasterer 21:33

Feb. 2, 2020

Thread Author Time
Re: BUG #16171: Potential malformed JSON in explain output Daniel Gustafsson 12:08
Re: BUG #16171: Potential malformed JSON in explain output Tom Lane 16:48

Feb. 3, 2020

Thread Author Time
Re: postgres crash on concurrent update of inheritance partitioned table Andres Freund 06:23
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila 06:45
Re: BUG #16223: Performance regression between 11.6 and 12.1 in an SQL query with a recursive CTE based on function Andres Freund 09:15
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher 09:20
BUG #16240: The now() function is populating different date time than expected PG Bug reporting form 10:38
Re: BUG #16171: Potential malformed JSON in explain output hubert depesz lubaczewski 11:40
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila 12:54
Re: BUG #16171: Potential malformed JSON in explain output Daniel Gustafsson 12:55
Re: Unable to trigger createdb Daniel Gustafsson 13:03
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher 13:46
Re: BUG #16171: Potential malformed JSON in explain output Tom Lane 14:15
Re: BUG #16240: The now() function is populating different date time than expected Tom Lane 14:24
Re: Unable to trigger createdb Jack Plasterer 15:25
BUG #16241: Degraded hash join performance PG Bug reporting form 15:33
Re: BUG #16171: Potential malformed JSON in explain output 📎 Tom Lane 15:56
Re: BUG #16241: Degraded hash join performance Andres Freund 16:23

Feb. 4, 2020

Thread Author Time
BUG #16242: convert_tuple_* not handling missing values correctly PG Bug reporting form 02:24
BUG #16243: non super user take pg_restore found some errors. PG Bug reporting form 06:18
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila 06:41
Re: BUG #16241: Degraded hash join performance 📎 Thomas Butz 09:02
Re: BUG #16241: Degraded hash join performance Andres Freund 13:44
Re: BUG #16241: Degraded hash join performance Thomas Butz 14:49
Re: BUG #16241: Degraded hash join performance Andres Freund 15:01
Re: BUG #16241: Degraded hash join performance Tom Lane 16:00
Re: BUG #16243: non super user take pg_restore found some errors. Tom Lane 16:27
Re: BUG #16241: Degraded hash join performance Andres Freund 16:29
FK violation in partitioned table after truncating a referenced partition 📎 Jehan-Guillaume de Rorthais 17:39
Re: BUG #16171: Potential malformed JSON in explain output Tom Lane 18:08

Feb. 5, 2020

Thread Author Time
Re: BUG #16242: convert_tuple_* not handling missing values correctly 📎 Vik Fearing 02:03
Re: BUG #16242: convert_tuple_* not handling missing values correctly Andres Freund 02:19
Re: BUG #16242: convert_tuple_* not handling missing values correctly Vik Fearing 02:21
Re: BUG #16242: convert_tuple_* not handling missing values correctly Andres Freund 02:26
Re: BUG #16242: convert_tuple_* not handling missing values correctly 📎 Vik Fearing 02:38
Re: BUG #16242: convert_tuple_* not handling missing values correctly Andrew Gierth 03:09
Re: incorrect pg_dump output due to not handling dropped roles correctly Stephen Frost 03:44
BUG #16244: Ref cursor from PostgreSQL and entity Framework PG Bug reporting form 08:45
AW: BUG #16103: Initdb does not respect country for language Wimmesberger, Simon 08:58
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher 09:04
Re: BUG #16241: Degraded hash join performance Thomas Butz 11:06
Re: BUG #15858: could not stat file - over 4GB Emil Iggland 11:46
Re: BUG #16234: LDAP Query Stephen Frost 12:07
Re: BUG #16244: Ref cursor from PostgreSQL and entity Framework David G. Johnston 14:35
Re: BUG #16242: convert_tuple_* not handling missing values correctly Andrew Gierth 19:22
Re: DROP OWNED CASCADE vs Temp tables Alvaro Herrera 21:13
Another FK violation when referencing a multi-level partitioned table 📎 Jehan-Guillaume de Rorthais 23:49

Feb. 6, 2020

Thread Author Time
Re: BUG #16242: convert_tuple_* not handling missing values correctly Michael Paquier 05:48
Re: Another FK violation when referencing a multi-level partitioned table Michael Paquier 08:08
BUG #16245: proj63 from rhel-7 repo depends on sqlite33, but is not available PG Bug reporting form 14:06
Regarding Postgresql compatible driver for SAP BOBJ 4.2 server installed on Linux box Panchal, Hiren (GE Corporate, consultant) 14:52
BUG #16246: Need compatible odbc driver to establish connectivity with SAP BOBJ 4.2 PG Bug reporting form 15:13
Re: Another FK violation when referencing a multi-level partitioned table Alvaro Herrera 17:21
Re: BUG #16245: proj63 from rhel-7 repo depends on sqlite33, but is not available Dan Hayes 17:46
Re: FK violation in partitioned table after truncating a referenced partition 📎 Alvaro Herrera 21:12
BUG #16247: Cast error on integer PG Bug reporting form 21:43
Re: BUG #16247: Cast error on integer David G. Johnston 21:53
Re: FK violation in partitioned table after truncating a referenced partition Alvaro Herrera 22:00
Re: FK violation in partitioned table after truncating a referenced partition Alvaro Herrera 22:04
Re: FK violation in partitioned table after truncating a referenced partition 📎 Alvaro Herrera 22:05
Re: BUG #16247: Cast error on integer Andres Freund 22:12
Re: FK violation in partitioned table after truncating a referenced partition Alvaro Herrera 22:30
Re: FK violation in partitioned table after truncating a referenced partition Alvaro Herrera 23:01

Feb. 7, 2020

Thread Author Time
Re: BUG #16246: Need compatible odbc driver to establish connectivity with SAP BOBJ 4.2 Pavel Stehule 06:40
Re: FK violation in partitioned table after truncating a referenced partition 📎 Jehan-Guillaume de Rorthais 10:32
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila 10:59
Re: FK violation in partitioned table after truncating a referenced partition 📎 Alvaro Herrera 15:04
Re: FK violation in partitioned table after truncating a referenced partition Jehan-Guillaume de Rorthais 16:19
Re: FK violation in partitioned table after truncating a referenced partition Alvaro Herrera 17:27
BUG #16248: ALTER SYSTEM quoting of values does not work as expected PG Bug reporting form 18:20
RE: BUG #16234: LDAP Query Albin, Lloyd P 18:20
Re: FK violation in partitioned table after truncating a referenced partition 📎 Jehan-Guillaume de Rorthais 18:22
BUG #16249: Partition pruning blocks on exclusively locked table partition PG Bug reporting form 19:10
Re: BUG #16248: ALTER SYSTEM quoting of values does not work as expected Tom Lane 19:12
Re: BUG #16249: Partition pruning blocks on exclusively locked table partition Tom Lane 19:17
Re: FK violation in partitioned table after truncating a referenced partition Alvaro Herrera 20:19
Re: FK violation in partitioned table after truncating a referenced partition Alvaro Herrera 20:23
Re: BUG #16249: Partition pruning blocks on exclusively locked table partition 0010203112132233 20:26
Re: Another FK violation when referencing a multi-level partitioned table Alvaro Herrera 21:30
BUG #16250: As the owner of a database, I can't CREATE EXTENSION postgis; PG Bug reporting form 21:36
Re: BUG #16250: As the owner of a database, I can't CREATE EXTENSION postgis; Tom Lane 22:00
Re: FK violation in partitioned table after truncating a referenced partition Jehan-Guillaume de Rorthais 22:03
Re: Another FK violation when referencing a multi-level partitioned table Jehan-Guillaume de Rorthais 22:26

Feb. 8, 2020

Thread Author Time
BUG #16251: ::text type casting of a constant breaks query performance PG Bug reporting form 06:43
Re: BUG #16251: ::text type casting of a constant breaks query performance Pavel Stehule 07:09
Re: BUG #16251: ::text type casting of a constant breaks query performance Pavel Stehule 07:28
Re: BUG #16245: proj63 from rhel-7 repo depends on sqlite33, but is not available Marco Lechner privat 09:00
Re: BUG #16251: ::text type casting of a constant breaks query performance Tom Lane 16:49
Re: BUG #16251: ::text type casting of a constant breaks query performance Pavel Stehule 17:03
BUG #16252: PL/pgSQL dynamic programming not well suited for working with different schemas PG Bug reporting form 18:16
Re: BUG #16245: proj63 from rhel-7 repo depends on sqlite33, but is not available Dan Hayes 18:25
Re: BUG #16252: PL/pgSQL dynamic programming not well suited for working with different schemas Pavel Stehule 18:37
Re: BUG #16251: ::text type casting of a constant breaks query performance Jeff Janes 18:43

Feb. 9, 2020

Thread Author Time
BUG #16253: Documentation bug https://www.postgresql.org/docs/12/auth-methods.html PG Bug reporting form 02:07
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila 07:27
Re: BUG #16253: Documentation bug https://www.postgresql.org/docs/12/auth-methods.html Sergei Kornilov 08:50
Re: ERROR: subtransaction logged without previous top-level txn record 📎 Arseny Sher 16:07
Re: Another FK violation when referencing a multi-level partitioned table Tom Lane 17:48

Feb. 10, 2020

Thread Author Time
Re: Another FK violation when referencing a multi-level partitioned table 📎 Jehan-Guillaume de Rorthais 10:34
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila 11:03
Re: ERROR: subtransaction logged without previous top-level txn record 📎 Arseny Sher 13:04

Feb. 11, 2020

Thread Author Time
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila 03:59
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher 04:32
Re: ERROR: subtransaction logged without previous top-level txn record 📎 Arseny Sher 05:06
Prezzo esposto agenziaimmobiliare 07:20
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila 11:45
Re: ERROR: subtransaction logged without previous top-level txn record 📎 Arseny Sher 12:06
BUG #16254: SQL raises error dsa_allocate could not find 4 free pages PG Bug reporting form 12:34
Re: BUG #16254: SQL raises error dsa_allocate could not find 4 free pages Thomas Munro 19:23

Feb. 12, 2020

Thread Author Time
Re: Prezzo esposto Thomas Munro 01:12
Re: ERROR: subtransaction logged without previous top-level txn record Dilip Kumar 03:16
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila 03:39
Re: ERROR: subtransaction logged without previous top-level txn record Dilip Kumar 03:53
Re: ERROR: subtransaction logged without previous top-level txn record 📎 Amit Kapila 08:12
BUG #16255: No respect for 'not materialized' on CTEs with group by PG Bug reporting form 12:28
Re: BUG #16255: No respect for 'not materialized' on CTEs with group by Tom Lane 15:11
pg_dump is not backwards compatible in PG12 Vera Gangeskar Johne 18:59
Re: pg_dump is not backwards compatible in PG12 Tom Lane 19:49

Feb. 13, 2020

Thread Author Time
Re: ERROR: subtransaction logged without previous top-level txn record Dilip Kumar 04:31
BUG #16256: Checking deferred FK constraints when updating PK is ordrs of magnitude slower than when updating FK PG Bug reporting form 06:39
Re: BUG #16256: Checking deferred FK constraints when updating PK is ordrs of magnitude slower than when updating FK David G. Johnston 07:03
Re: BUG #16256: Checking deferred FK constraints when updating PK is ordrs of magnitude slower than when updating FK Valentin Kovalenko 07:52
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila 08:45
BUG #16257: 12.2 rpm packages size increase vs 12.1 PG Bug reporting form 14:35

Feb. 14, 2020

Thread Author Time
Re: BUG #16182: Error in logs from "renaming temporary statistics" Graham Wideman 03:16
Re: BUG #16182: Error in logs from "renaming temporary statistics" Graham Wideman 04:42
BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand PG Bug reporting form 06:27
Re: ERROR: subtransaction logged without previous top-level txn record Arseny Sher 13:34
Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand Tom Lane 15:20
Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand RekGRpth 15:23
Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand Tom Lane 15:36
Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand RekGRpth 15:37
Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand David G. Johnston 17:14
Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand Tom Lane 17:30
BUG #16259: Cannot Use "pg_ctl start -l logfile" on Clean Install on Windows Server 2012/2016 PG Bug reporting form 17:35
Re: BUG #16259: Cannot Use "pg_ctl start -l logfile" on Clean Install on Windows Server 2012/2016 Tom Lane 17:45
Re: BUG #16259: Cannot Use "pg_ctl start -l logfile" on Clean Install on Windows Server 2012/2016 Jonathan S. Katz 18:04
Re: BUG #16259: Cannot Use "pg_ctl start -l logfile" on Clean Install on Windows Server 2012/2016 Heath Lord 19:40
Re: BUG #16259: Cannot Use "pg_ctl start -l logfile" on Clean Install on Windows Server 2012/2016 Tom Lane 19:57
Re: BUG #16259: Cannot Use "pg_ctl start -l logfile" on Clean Install on Windows Server 2012/2016 Heath Lord 21:22
Re: BUG #16259: Cannot Use "pg_ctl start -l logfile" on Clean Install on Windows Server 2012/2016 Tom Lane 21:46

Feb. 15, 2020

Thread Author Time
Re: BUG #16259: Cannot Use "pg_ctl start -l logfile" on Clean Install on Windows Server 2012/2016 📎 Alexander Lakhin 04:44
Re: BUG #16259: Cannot Use "pg_ctl start -l logfile" on Clean Install on Windows Server 2012/2016 Tom Lane 05:22
Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand RekGRpth 05:42
Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand David G. Johnston 15:26
Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand Jeff Janes 18:15

Feb. 16, 2020

Thread Author Time
Re: BUG #16259: Cannot Use "pg_ctl start -l logfile" on Clean Install on Windows Server 2012/2016 Heath Lord 00:23
BUG #16260: Repetitive accessing to partitioned table inside transaction causes server process crash PG Bug reporting form 09:15
Re: BUG #16259: Cannot Use "pg_ctl start -l logfile" on Clean Install on Windows Server 2012/2016 Tom Lane 17:21
pg_dump No comment for policy Marc Munro 21:41
Re: BUG #16260: Repetitive accessing to partitioned table inside transaction causes server process crash Tom Lane 22:11

Feb. 17, 2020

Thread Author Time
Adding libpgcommon and libpgcore to libpq pkg-config's Requires.private Pyry Kontio 10:37
Re: BUG #16257: 12.2 rpm packages size increase vs 12.1 Devrim Gündüz 11:07
BUG #16261: Not able to start Postgres PG Bug reporting form 11:23
Re: BUG #16261: Not able to start Postgres Daniel Gustafsson 12:10
Re: BUG #16261: Not able to start Postgres Daniel Gustafsson 12:58
RE: BUG #16257: 12.2 rpm packages size increase vs 12.1 GABORIEAU Olivier 13:02
BUG #16262: pg_advisory_xact_lock cannot be released PG Bug reporting form 13:28
Re: BUG #16262: pg_advisory_xact_lock cannot be released Sergei Kornilov 13:33
BUG #16263: pg_advisory_xact_lock cannot be released PG Bug reporting form 13:52

Browse Archives

Prev | Next