pgsql-bugs since 2020-02-13 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

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
Re: BUG #16261: Not able to start Postgres Daniel Gustafsson 13:57
Re: Adding libpgcommon and libpgcore to libpq pkg-config's Requires.private Tom Lane 14:04
Possible memory leak in PostgreSQL 12.2 on truncate, insert or delete when type interval is involved Hazuki Amamiya 16:04
Re: pg_dump No comment for policy Tom Lane 17:59
PSQL Help Andre Lucas 20:38
Re: Possible memory leak in PostgreSQL 12.2 on truncate, insert or delete when type interval is involved Tom Lane 22:22

Feb. 18, 2020

Thread Author Time
Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand RekGRpth 02:48
Re: PSQL Help David G. Johnston 03:06
Re: PSQL Help Tom Lane 03:39
Re: Possible memory leak in PostgreSQL 12.2 on truncate, insert or delete when type interval is involved Hazuki Amamiya 03:48
Re: PSQL Help Michael Paquier 04:37
Not able to run query/scripts on our Postgre instance which is on cloud foundry Laxminarayan, Sudhanva 06:32
Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes sailor 07:23
[Bus error] huge_pages default value (try) not fall back Fan Liu 07:52
Re: [Bus error] huge_pages default value (try) not fall back Dmitry Dolgov 09:32
RE: [Bus error] huge_pages default value (try) not fall back Fan Liu 12:31
DB running out of memory issues after upgrade Nagaraj Raj 17:46
Re: DB running out of memory issues after upgrade Tomas Vondra 17:58
Re: DB running out of memory issues after upgrade Tom Lane 18:07
Re: DB running out of memory issues after upgrade Nagaraj Raj 18:10
Re: DB running out of memory issues after upgrade Stephen Frost 18:33
Re: DB running out of memory issues after upgrade Merlin Moncure 18:38
Re: DB running out of memory issues after upgrade Justin Pryzby 18:40
Re: DB running out of memory issues after upgrade Merlin Moncure 18:49
gen_random_uuid() is immutable in Pg 13devel hubert depesz lubaczewski 18:54
Re: gen_random_uuid() is immutable in Pg 13devel Alvaro Herrera 19:01
BUG #16264: Server closed the connection unexpectedly PG Bug reporting form 19:07
Re: DB running out of memory issues after upgrade Nagaraj Raj 19:10
Re: gen_random_uuid() is immutable in Pg 13devel Peter Geoghegan 19:36
Re: gen_random_uuid() is immutable in Pg 13devel Alvaro Herrera 20:01
Re: gen_random_uuid() is immutable in Pg 13devel Peter Geoghegan 20:34
Re: BUG #16108: Colorization to the output of command-line has unproperly behaviors at Windows platform Michail Nikolaev 22:39
Re: gen_random_uuid() is immutable in Pg 13devel Tom Lane 22:58
Re: BUG #16108: Colorization to the output of command-line has unproperly behaviors at Windows platform Michail Nikolaev 23:01

Feb. 19, 2020

Thread Author Time
windows 10 postgres install bug Doke, Tim (TR Tech, Content & Ops) 00:41
BUG #16265: psql shows (unfolded) relation name in quotes PG Bug reporting form 01:17
[Bug Report] Week Day 📎 Atila Rangel 02:59
Re: ERROR: subtransaction logged without previous top-level txn record Amit Kapila 03:56
Partitioning Column needs to be Key Vaishakha Madhava 06:30
BUG #16266: Server crash on SELECT event_trigger-returning function PG Bug reporting form 08:00
Full text search bug ('russian' regconfig) egocenter 08:35
Re: [Bug Report] Week Day Heikki Linnakangas 09:07
Re: [Bug Report] Week Day Frank Heikens 09:07
Re: [Bus error] huge_pages default value (try) not fall back Dmitry Dolgov 09:35
Regarding postgres driver odbc issue 📎 Panchal, Hiren (GE Corporate, consultant) 09:44
Re: Partitioning Column needs to be Key legrand legrand 10:11
Re: [Bug Report] Week Day hubert depesz lubaczewski 10:47
Re: DROP OWNED CASCADE vs Temp tables ahsan hadi 13:59
Re: BUG #16265: psql shows (unfolded) relation name in quotes Tom Lane 15:44
Re: BUG #16266: Server crash on SELECT event_trigger-returning function Tom Lane 16:05
Re: BUG #16108: Colorization to the output of command-line has unproperly behaviors at Windows platform 📎 Juan José Santamaría Flecha 16:16
Re: BUG #16264: Server closed the connection unexpectedly Tom Lane 16:26
BUG #16267: Have problems to connect with localhost in all versions can you help me to solve this PG Bug reporting form 18:39
postgres installation issue Ростик Шимчак 19:05
Re: gen_random_uuid() is immutable in Pg 13devel Peter Eisentraut 19:19
Re: postgres installation issue Allan Davis 19:57
Re: Regarding postgres driver odbc issue Tomas Vondra 23:17
Re: BUG #16264: Server closed the connection unexpectedly Robin Duquette 23:47

Feb. 20, 2020

Thread Author Time
Re: BUG #16264: Server closed the connection unexpectedly Tom Lane 00:09
Re: Full text search bug ('russian' regconfig) Artur Zakirov 01:04
BUG #16268: SPI_getvalue requires IsTransactionState but TextDatumGetCString of SPI_getbinval - not! PG Bug reporting form 05:06
Re: BUG #16268: SPI_getvalue requires IsTransactionState but TextDatumGetCString of SPI_getbinval - not! Michael Paquier 05:31
Re: Full text search bug ('russian' regconfig) egocenter 08:21
Re: gen_random_uuid() is immutable in Pg 13devel hubert depesz lubaczewski 11:12
BUG #16269: psql: error while loading shared libraries PG Bug reporting form 12:22
Re: BUG #16269: psql: error while loading shared libraries Tom Lane 14:52
Re: Another FK violation when referencing a multi-level partitioned table Alvaro Herrera 19:43
Re: Another FK violation when referencing a multi-level partitioned table Jehan-Guillaume de Rorthais 20:39
CREATE TABLE IF NOT EXISTS fails with privilege exception when table exists duvall 22:20

Feb. 21, 2020

Thread Author Time
Re: CREATE TABLE IF NOT EXISTS fails with privilege exception when table exists Tom Lane 00:18
RE: [Bus error] huge_pages default value (try) not fall back 📎 Fan Liu 02:19
BUG #16270: Repository URL is wrong PG Bug reporting form 09:25
Re: postgres installation issue Sandeep Thakkar 13:28
BUG #16271: rebuild PostgreSQL using --with-libxml PG Bug reporting form 18:34
Re: [Bus error] huge_pages default value (try) not fall back Dmitry Dolgov 18:58
BUG #16272: Index expression can refer to wrong attributes if index is created via CREATE TABLE LIKE PG Bug reporting form 19:37
Re: CREATE TABLE IF NOT EXISTS fails with privilege exception when table exists duvall 19:45
Re: BUG #16272: Index expression can refer to wrong attributes if index is created via CREATE TABLE LIKE 📎 Tom Lane 23:33

Feb. 22, 2020

Thread Author Time
Re: BUG #16108: Colorization to the output of command-line has unproperly behaviors at Windows platform Michail Nikolaev 20:08

Feb. 23, 2020

Thread Author Time
BUG #16273: InitDB Memory leak PG Bug reporting form 06:05
Re: BUG #16273: InitDB Memory leak Tom Lane 06:43
Re: DB running out of memory issues after upgrade Peter J. Holzer 10:19

Feb. 24, 2020

Thread Author Time
RE: [Bus error] huge_pages default value (try) not fall back Fan Liu 01:32
Table Physical Size Surge Ashish Kumar Singh 05:42
Re: Table Physical Size Surge Daniel Gustafsson 07:22
Re: [Bus error] huge_pages default value (try) not fall back Dmitry Dolgov 10:38
BUG #16274: Repeated Libraries in Mac PG Bug reporting form 12:12
Re: BUG #16274: Repeated Libraries in Mac Daniel Gustafsson 14:35
Re: BUG #16274: Repeated Libraries in Mac Tom Lane 15:04
Re: DB running out of memory issues after upgrade Merlin Moncure 16:34
Re: BUG #16108: Colorization to the output of command-line has unproperly behaviors at Windows platform 📎 Juan José Santamaría Flecha 17:56

Feb. 25, 2020

Thread Author Time
RE: [Bus error] huge_pages default value (try) not fall back Fan Liu 01:57
Re: BUG #16258: exec_simple_query does not call ProcessCompletedNotifies after CommitTransactionCommand RekGRpth 02:51
BUG #16275: we are facing error as psycopg2.errors.ProgramLimitExceeded: row is too big: size 24520, maximum PG Bug reporting form 06:49
Re: BUG #16274: Repeated Libraries in Mac Daniel Gustafsson 09:13
Re: BUG #16274: Repeated Libraries in Mac Daniel Gustafsson 09:28
pretty_bool in pg_get_constraintdef has no effect since pg >= 9 eli.mach 12:56
Re: pretty_bool in pg_get_constraintdef has no effect since pg >= 9 Daniel Gustafsson 13:30
Re: pretty_bool in pg_get_constraintdef has no effect since pg >= 9 eli.mach 13:59
planner weirdness: a join uses nestloop with checking condition when there are two subplan-or-hashed subqueries 📎 Alexey Bashtanov 14:32
Re: BUG #16275: we are facing error as psycopg2.errors.ProgramLimitExceeded: row is too big: size 24520, maximum Tomas Vondra 15:05
BUG #16276: Server crash on an invalid attempt to attach a partition to an index PG Bug reporting form 16:00
BUG #16277: xmlelement allows invalid XML characters when XML version is set to 1.0 PG Bug reporting form 18:58
Re: BUG #16277: xmlelement allows invalid XML characters when XML version is set to 1.0 Tom Lane 19:59
Re: planner weirdness: a join uses nestloop with checking condition when there are two subplan-or-hashed subqueries Tom Lane 20:34
Re: BUG #16277: xmlelement allows invalid XML characters when XML version is set to 1.0 Andreas Lennartsson 21:14
Re: BUG #16277: xmlelement allows invalid XML characters when XML version is set to 1.0 Tom Lane 22:00

Feb. 26, 2020

Thread Author Time
BUG #16278: SOCKET ISSUE PG Bug reporting form 07:03
Re: BUG #16278: SOCKET ISSUE Daniel Gustafsson 07:19
Re: BUG #16278: SOCKET ISSUE Daniel Gustafsson 07:40
Re: BUG #16278: SOCKET ISSUE Daniel Gustafsson 07:50
Re: BUG #16276: Server crash on an invalid attempt to attach a partition to an index Michael Paquier 08:06
Re: BUG #16274: Repeated Libraries in Mac Krishnanunni Radhakrishnan 08:16
Re: BUG #16274: Repeated Libraries in Mac Daniel Gustafsson 09:06
Re: BUG #16108: Colorization to the output of command-line has unproperly behaviors at Windows platform Michail Nikolaev 10:48
Re: BUG #16108: Colorization to the output of command-line has unproperly behaviors at Windows platform Juan José Santamaría Flecha 10:58
BUG #16279: Permissions doc incorrect for pg_buffercache PG Bug reporting form 16:46
Re: BUG #16279: Permissions doc incorrect for pg_buffercache Sergei Kornilov 17:11
Re: BUG #16277: xmlelement allows invalid XML characters when XML version is set to 1.0 Andreas Lennartsson 18:44

Feb. 27, 2020

Thread Author Time
Re: BUG #16276: Server crash on an invalid attempt to attach a partition to an index Michael Paquier 02:31
Re: BUG #16276: Server crash on an invalid attempt to attach a partition to an index Amit Langote 08:14
BUG #16280: dead tuples (probably) effect plan and query performance PG Bug reporting form 11:28
Re: BUG #16276: Server crash on an invalid attempt to attach a partition to an index Michael Paquier 12:49
Re: BUG #16280: dead tuples (probably) effect plan and query performance Alexey Ermakov 14:07
Re: BUG #16280: dead tuples (probably) effect plan and query performance Tom Lane 15:41
Postgres does not use index with IN 📎 Дмитрий Вилькер 18:27
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Alvaro Herrera 19:24
Re: BUG #16279: Permissions doc incorrect for pg_buffercache Philip Semanchuk 21:13
Re: BUG #16279: Permissions doc incorrect for pg_buffercache Tom Lane 21:31
Re: BUG #16279: Permissions doc incorrect for pg_buffercache Philip Semanchuk 21:39

Feb. 28, 2020

Thread Author Time
BUG #16281: LN() function inaccurate at 1000th fractional digit PG Bug reporting form 05:42
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Mahendra Singh Thalor 05:59
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Michael Paquier 07:17
Re: BUG #16281: LN() function inaccurate at 1000th fractional digit Dean Rasheed 07:18
BUG #16282: Avoid sql-injections at identifiers PG Bug reporting form 08:00
Re: BUG #15858: could not stat file - over 4GB 📎 Juan José Santamaría Flecha 09:15
Re: BUG #16280: dead tuples (probably) effect plan and query performance Serbin, Ilya 09:25
Re: BUG #16274: Repeated Libraries in Mac Sandeep Thakkar 13:13
BUG #16283: crash on create index segmentation fault PG Bug reporting form 14:23
Re: BUG #16281: LN() function inaccurate at 1000th fractional digit Tom Lane 15:39
Re: BUG #16283: crash on create index segmentation fault Tomas Vondra 16:26
Re: BUG #16279: Permissions doc incorrect for pg_buffercache Tom Lane 16:47
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Tom Lane 17:20
Re: BUG #16283: crash on create index segmentation fault Przemysław Szustak 17:43
Re: BUG #16283: crash on create index segmentation fault Tomas Vondra 18:11
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema 📎 Tom Lane 18:45
Re: BUG #16283: crash on create index segmentation fault Przemysław Szustak 19:58
Re: BUG #16274: Repeated Libraries in Mac Daniel Gustafsson 20:33
Re: BUG #16283: crash on create index segmentation fault Tomas Vondra 21:00
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Michael Paquier 23:21
Re: BUG #15858: could not stat file - over 4GB Tom Lane 23:44

Feb. 29, 2020

Thread Author Time
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Tom Lane 00:23
Re: BUG #15858: could not stat file - over 4GB 📎 Juan José Santamaría Flecha 08:40
Re: Assert failure due to "drop schema pg_temp_3 cascade" for temporary tables and \d+ is not showing any info after drooping temp table schema Michael Paquier 09:46
Re: BUG #15858: could not stat file - over 4GB 📎 Juan José Santamaría Flecha 11:36
Re: BUG #16281: LN() function inaccurate at 1000th fractional digit 📎 Dean Rasheed 17:16
Re: BUG #16281: LN() function inaccurate at 1000th fractional digit Tom Lane 19:12

March 1, 2020

Thread Author Time
Re: BUG #16281: LN() function inaccurate at 1000th fractional digit Justin AnyhowStep 02:59

Browse Archives

Prev | Next