pgsql-bugs - December 2019

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

Dec. 1, 2019

Thread Author Time
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Thomas Munro 22:50
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Tom Lane 22:59
FailedAssertion("!OidIsValid(def->collOid)", File: "view.c", Line: 89) Manuel Rigger 23:31

Dec. 2, 2019

Thread Author Time
Re: FailedAssertion("!OidIsValid(def->collOid)", File: "view.c", Line: 89) 📎 Thomas Munro 01:20
Re: logical replication: could not create file "state.tmp": File exists Michael Paquier 04:35
Re: Strange query planner behavior EffiSYS / Martin Querleu 09:20
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Petr Fedorov 11:08
Re: logical replication: could not create file "state.tmp": File exists Grigory Smolkin 12:27
BUG #16144: Segmentation fault on dict_int extension PG Bug reporting form 12:41
Re: LDAPS trusted ca support Marco Cuccato 13:13
Re: LDAPS trusted ca support Marco Cuccato 15:37
Re: logical replication: could not create file "state.tmp": File exists Andres Freund 16:12
Re: BUG #16144: Segmentation fault on dict_int extension Tomas Vondra 16:19
Re: logical replication: could not create file "state.tmp": File exists Grigory Smolkin 16:54
Re: logical replication: could not create file "state.tmp": File exists Dmitry Vasiliev 17:35
Re: logical replication: could not create file "state.tmp": File exists 📎 Grigory Smolkin 17:49
Re: Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch Thomas Munro 22:52

Dec. 3, 2019

Thread Author Time
Re: BUG #15548: Unaccent does not remove combining diacritical characters Thomas Munro 09:01
Re: BUG #16139: Assertion fails on INSERT into a postgres_fdw' table with two AFTER INSERT triggers 📎 Etsuro Fujita 11:53
BUG #16145: Not able to terminate active session PG Bug reporting form 13:18
Re: BUG #16145: Not able to terminate active session Tomas Vondra 14:11
Re: BUG #16145: Not able to terminate active session MOHAN KUMAR DORAIRAJ 15:12
Re: BUG #16145: Not able to terminate active session Tomas Vondra 15:54
Re: BUG #16145: Not able to terminate active session MOHAN KUMAR DORAIRAJ 16:26
pg_dump losing index column collations for unique and primary keys 📎 Alexey Bashtanov 16:35
Re: BUG #16145: Not able to terminate active session Tomas Vondra 16:38
Re: pg_dump losing index column collations for unique and primary keys Tom Lane 16:57
RE: BUG #16145: Not able to terminate active session David Raymond 17:00
Re: BUG #16104: Invalid DSA Memory Alloc Request in Parallel Hash Alvaro Herrera 17:07
Re: BUG #16145: Not able to terminate active session Tom Lane 17:09
Re: BUG #16144: Segmentation fault on dict_int extension Tomas Vondra 17:52
Re: BUG #16144: Segmentation fault on dict_int extension Tomas Vondra 18:06
Re: BUG #16145: Not able to terminate active session Mahendra Singh 18:22
Re: pg_dump losing index column collations for unique and primary keys 📎 Tom Lane 18:24
Re: pg_dump losing index column collations for unique and primary keys Alexey Bashtanov 19:30
Re: pg_dump losing index column collations for unique and primary keys Tom Lane 19:52
Re: BUG #16079: Question Regarding the BUG #16064 Stephen Frost 19:58
Re: BUG #16079: Question Regarding the BUG #16064 Stephen Frost 20:10
Re: incorrect pg_dump output due to not handling dropped roles correctly Stephen Frost 20:27
Re: incorrect pg_dump output due to not handling dropped roles correctly Stephen Frost 20:31
Re: LDAPS trusted ca support Stephen Frost 20:35
Re: Numeric is not leakproof Stephen Frost 20:43
Re: BUG #16041: Error shows up both in pgAdmin and in Ruby (pg gem) - Segmentation fault 📎 Chris Bandy 21:33
Re: BUG #16041: Error shows up both in pgAdmin and in Ruby (pg gem) - Segmentation fault 📎 Chris Bandy 23:05
Re: BUG #16041: Error shows up both in pgAdmin and in Ruby (pg gem) - Segmentation fault Stephen Frost 23:31

Dec. 4, 2019

Thread Author Time
Re: BUG #16145: Not able to terminate active session MOHAN KUMAR DORAIRAJ 03:34
Create database from template very slow Mark Phillips 04:17
Re: Create database from template very slow David G. Johnston 04:51
Re: Create database from template very slow Thomas Munro 05:16
BUG #16146: ts_headline does not find phrase matches correctly PG Bug reporting form 08:39
Re: Numeric is not leakproof Konstantin Knizhnik 09:28
Re: LDAPS trusted ca support Marco Cuccato 10:18
BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes PG Bug reporting form 11:46
Re: BUG #16145: Not able to terminate active session Tom Lane 13:10
Re: BUG #16145: Not able to terminate active session MOHAN KUMAR DORAIRAJ 13:22
Re: BUG #16145: Not able to terminate active session Tom Lane 13:34
Re: pg_dump losing index column collations for unique and primary keys Alexey Bashtanov 13:51
Re: BUG #16145: Not able to terminate active session Tomas Vondra 13:55
Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes Tom Lane 14:03
BUG #16148: Query on Large table hangs in ETL flows and gives out of memory when run in pgAdmin4 PG Bug reporting form 14:19
Re: pg_dump losing index column collations for unique and primary keys Tom Lane 15:48
Re: BUG #16041: Error shows up both in pgAdmin and in Ruby (pg gem) - Segmentation fault Chris Bandy 19:18
Re: BUG #16041: Error shows up both in pgAdmin and in Ruby (pg gem) - Segmentation fault Stephen Frost 19:34
Re: BUG #16148: Query on Large table hangs in ETL flows and gives out of memory when run in pgAdmin4 Jeff Janes 22:05

Dec. 5, 2019

Thread Author Time
BUG #16149: Prepared COPY queries always report 0 parameters when described PG Bug reporting form 00:21
Re: BUG #16111: Unexpected query compilation error “negative bitmapset member not allowed” Justin Pryzby 00:38
Re: BUG #16140: View with INSERT, DO INSTEAD, and ON CONFLICT causes an error Peter Geoghegan 01:10
Re: BUG #16149: Prepared COPY queries always report 0 parameters when described David G. Johnston 01:15
Re: BUG #16140: View with INSERT, DO INSTEAD, and ON CONFLICT causes an error Tom Lane 01:30
logical decoding bug: segfault in ReorderBufferToastReplace() Jeremy Schneider 01:36
A row-level trigger on a partitioned table is not created on a sub-partition created later Petr Fedorov 07:24
BUG #16150: UPDATE set NULL value in non-null columns PG Bug reporting form 09:17
BUG #16151: startup timing problem PG Bug reporting form 10:39
RE: Postgres takes more than 6 minutes to come up during host/standby switch over RideNext 10:50
Re: BUG #16150: UPDATE set NULL value in non-null columns Mahendra Singh 11:35
BUG #16152: postgresql10-plpython-10.11-2PGDG.rhel7.x86_64 requires an unexistant package PG Bug reporting form 12:28
Re: logical decoding bug: segfault in ReorderBufferToastReplace() Tomas Vondra 13:38
Re: BUG #16148: Query on Large table hangs in ETL flows and gives out of memory when run in pgAdmin4 Scott Volkers 14:54
Re: BUG #16150: UPDATE set NULL value in non-null columns Tom Lane 15:18
BUG #16153: foreign key update should probably move dependent rows in the case of tuple rerouting PG Bug reporting form 16:02
Re: BUG #16148: Query on Large table hangs in ETL flows and gives out of memory when run in pgAdmin4 Jeff Janes 16:52
Re: Create database from template very slow Mark Phillips 19:52

Dec. 6, 2019

Thread Author Time
Re: BUG #16145: Not able to terminate active session MOHAN KUMAR DORAIRAJ 03:34
BUG #16154: pg_ctl restart with a logfile fails sometimes (on Windows) PG Bug reporting form 07:00
RE: Postgres takes more than 6 minutes to come up during host/standby switch over RideNext 07:34
Re: BUG #16154: pg_ctl restart with a logfile fails sometimes (on Windows) 📎 Alexander Lakhin 08:00
BUG #16155: error when starting pgAdmin (version 4) PG Bug reporting form 08:26
Re: BUG #16139: Assertion fails on INSERT into a postgres_fdw' table with two AFTER INSERT triggers 📎 Etsuro Fujita 08:27
Memory leak (possibly connected to postgis) leading to server crash Roman Cervenak 09:22
BUG #16156: bugs security PG Bug reporting form 10:33
Re: Memory leak (possibly connected to postgis) leading to server crash Tomas Vondra 11:01
Re: Memory leak (possibly connected to postgis) leading to server crash 📎 Roman Cervenak 11:46
Re: Memory leak (possibly connected to postgis) leading to server crash Tomas Vondra 12:41
Re: BUG #16154: pg_ctl restart with a logfile fails sometimes (on Windows) Tom Lane 15:14
Re: BUG #16154: pg_ctl restart with a logfile fails sometimes (on Windows) 📎 Alexander Lakhin 15:40

Dec. 7, 2019

Thread Author Time
Re: BUG #16154: pg_ctl restart with a logfile fails sometimes (on Windows) Amit Kapila 12:35
Re: BUG #16154: pg_ctl restart with a logfile fails sometimes (on Windows) Alexander Law 16:00
Re: BUG #16154: pg_ctl restart with a logfile fails sometimes (on Windows) Tom Lane 16:54
Re: BUG #16154: pg_ctl restart with a logfile fails sometimes (on Windows) Alexander Law 18:00
Re: BUG #16154: pg_ctl restart with a logfile fails sometimes (on Windows) Tom Lane 19:26
Re: BUG #16154: pg_ctl restart with a logfile fails sometimes (on Windows) Alexander Law 21:00

Dec. 8, 2019

Thread Author Time
Unexpected extra row from jsonb_path_query() with a recursive path Jan Przemysław Wójcik 11:43

Dec. 9, 2019

Thread Author Time
Warning in the RecordTransactionAbort routine during compilation with O3 flag 📎 Andrey Lepikhov 03:49
Re: Unexpected extra row from jsonb_path_query() with a recursive path Michael Paquier 07:28
Re: Warning in the RecordTransactionAbort routine during compilation with O3 flag Michael Paquier 08:03
Re: REINDEX CONCURRENTLY unexpectedly fails Michael Paquier 08:06
Re: Unexpected extra row from jsonb_path_query() with a recursive path Jan Przemysław Wójcik 08:37
Re: BUG #16147: postgresql 12.1 (from homebrew) - pg_restore -h localhost --jobs=2 crashes PikachuEXE 08:57
Re: Warning in the RecordTransactionAbort routine during compilation with O3 flag 📎 Andrey Lepikhov 09:03
BUG #16157: handling of pg_malloc(0) PG Bug reporting form 12:44
Re: BUG #16157: handling of pg_malloc(0) Tom Lane 15:19

Dec. 10, 2019

Thread Author Time
Re: Unexpected extra row from jsonb_path_query() with a recursive path Michael Paquier 02:38
Re: Warning in the RecordTransactionAbort routine during compilation with O3 flag 📎 Michael Paquier 03:13
Re: BUG #16122: segfault pg_detoast_datum (datum=0x0) at fmgr.c:1833 numrange query Michael Paquier 03:43
Re: BUG #16122: segfault pg_detoast_datum (datum=0x0) at fmgr.c:1833 numrange query 📎 Michael Paquier 05:38
Re: Warning in the RecordTransactionAbort routine during compilation with O3 flag Andrey Lepikhov 07:18
Re: BUG #16139: Assertion fails on INSERT into a postgres_fdw' table with two AFTER INSERT triggers Etsuro Fujita 09:33
Re: BUG #16157: handling of pg_malloc(0) cilizili 09:51
Bug in pg_dump Alejandro Meseguer 11:03
BUG #16158: Check constraints using SQL functions work incorrectly PG Bug reporting form 12:27
Re: BUG #16158: Check constraints using SQL functions work incorrectly David G. Johnston 15:00
Re: BUG #16158: Check constraints using SQL functions work incorrectly Tom Lane 15:14
Re: BUG #16158: Check constraints using SQL functions work incorrectly Tom Lane 15:39
Re: BUG #16104: Invalid DSA Memory Alloc Request in Parallel Hash Tomas Vondra 17:32
Re: BUG #16104: Invalid DSA Memory Alloc Request in Parallel Hash Alvaro Herrera 17:35
Re: BUG #16154: pg_ctl restart with a logfile fails sometimes (on Windows) Tom Lane 18:24
Re: BUG #16104: Invalid DSA Memory Alloc Request in Parallel Hash Tomas Vondra 18:36
Re: BUG #16104: Invalid DSA Memory Alloc Request in Parallel Hash Tom Lane 19:49
Re: BUG #16104: Invalid DSA Memory Alloc Request in Parallel Hash Tomas Vondra 20:41

Dec. 11, 2019

Thread Author Time
Re: Warning in the RecordTransactionAbort routine during compilation with O3 flag Michael Paquier 01:07
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Alvaro Herrera 01:55
Re: BUG #16154: pg_ctl restart with a logfile fails sometimes (on Windows) Alexander Lakhin 05:00
Re: logical replication: could not create file "state.tmp": File exists Michael Paquier 05:27
Re: Reorderbuffer crash during recovery 📎 vignesh C 05:43
Re: logical decoding bug: segfault in ReorderBufferToastReplace() Drouvot, Bertrand 08:17
Re: BUG #16152: postgresql10-plpython-10.11-2PGDG.rhel7.x86_64 requires an unexistant package Devrim Gündüz 09:07
Re: Memory leak (possibly connected to postgis) leading to server crash 📎 Roman Cervenak 11:09
Postgres 11.2 given error "Failed to initialize transaction_deferrable to 0" Amul 11:27
BUG #16159: recovery requests WALs for the next timelines before timeline switch LSN has been reached PG Bug reporting form 12:39
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Robert Haas 14:17
Re: Memory leak (possibly connected to postgis) leading to server crash Tomas Vondra 14:23
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Alvaro Herrera 15:06
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Alvaro Herrera 15:18
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Tom Lane 15:52
Re: logical decoding bug: segfault in ReorderBufferToastReplace() Robert Haas 15:54
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Robert Haas 15:57
BUG #16160: Minor memory leak in case of starting postgres server with SSL encryption PG Bug reporting form 16:22
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Tom Lane 16:34
Re: logical decoding bug: segfault in ReorderBufferToastReplace() Andres Freund 16:35
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Tom Lane 16:43
Re: Memory leak (possibly connected to postgis) leading to server crash Tom Lane 16:49
Re: logical decoding bug: segfault in ReorderBufferToastReplace() Tom Lane 17:11
Re: logical decoding bug: segfault in ReorderBufferToastReplace() Robert Haas 17:12
Re: logical decoding bug: segfault in ReorderBufferToastReplace() Andres Freund 17:21
Re: Memory leak (possibly connected to postgis) leading to server crash Roman Cervenak 17:23
Re: logical replication: could not create file "state.tmp": File exists Andres Freund 17:40
BUG #16161: pg_ctl stop fails sometimes (on Windows) PG Bug reporting form 20:00
Re: BUG #16161: pg_ctl stop fails sometimes (on Windows) 📎 Alexander Lakhin 20:30

Dec. 12, 2019

Thread Author Time
Re: BUG #16159: recovery requests WALs for the next timelines before timeline switch LSN has been reached Kyotaro Horiguchi 03:48
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Tom Lane 05:49
BUG #16162: create index using gist_trgm_ops leads to panic PG Bug reporting form 10:22
Re: BUG #16162: create index using gist_trgm_ops leads to panic Tomas Vondra 12:50
Re: BUG #16153: foreign key update should probably move dependent rows in the case of tuple rerouting Alvaro Herrera 12:52
Re: BUG #16162: create index using gist_trgm_ops leads to panic Tom Lane 13:44
BUG #16163: Seq scan through all the partitions on a partitioned table when joined small, dictionary table. PG Bug reporting form 15:20
Re: REINDEX CONCURRENTLY unexpectedly fails Andres Freund 19:55
Re: REINDEX CONCURRENTLY unexpectedly fails Alvaro Herrera 20:11
BUG #16164: Sending shared secret in all low case PG Bug reporting form 20:15
Re: REINDEX CONCURRENTLY unexpectedly fails Andres Freund 21:37
Re: postgres has no spinlock support on riscv rv64imafdc Andres Freund 21:59
ltrim function 📎 Serdar Başyiğit 23:15

Dec. 13, 2019

Thread Author Time
Re: BUG #16162: create index using gist_trgm_ops leads to panic Jeff Janes 00:05
Re: ltrim function Joe Conway 00:08
Re: BUG #16162: create index using gist_trgm_ops leads to panic Tomas Vondra 00:16
Re: REINDEX CONCURRENTLY unexpectedly fails Michael Paquier 02:47
Re: REINDEX CONCURRENTLY unexpectedly fails 📎 Michael Paquier 03:45
Re: BUG #16160: Minor memory leak in case of starting postgres server with SSL encryption 📎 Michael Paquier 06:39
Re: FailedAssertion("!OidIsValid(def->collOid)", File: "view.c", Line: 89) Manuel Rigger 09:56
Re: Memory leak (possibly connected to postgis) leading to server crash 📎 Roman Cervenak 10:51
Re: Memory leak (possibly connected to postgis) leading to server crash Tomas Vondra 13:20
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Tom Lane 14:42
Re: Random crashes - segmentation fault Kamil Jońca 15:05
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Alvaro Herrera 15:38
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Tom Lane 16:18
Re: BUG #16162: create index using gist_trgm_ops leads to panic Heikki Linnakangas 17:09
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes Tom Lane 18:55
Re: BUG #16059: Tab-completion of filenames in COPY commands removes required quotes 📎 Tom Lane 19:16
Re: BUG #16162: create index using gist_trgm_ops leads to panic Heikki Linnakangas 22:02

Dec. 14, 2019

Thread Author Time
Re: logical decoding bug: segfault in ReorderBufferToastReplace() Jeremy Schneider 00:13
Re: BUG #16104: Invalid DSA Memory Alloc Request in Parallel Hash 📎 Thomas Munro 00:22
Re: logical decoding bug: segfault in ReorderBufferToastReplace() Andres Freund 00:25
Re: BUG #16162: create index using gist_trgm_ops leads to panic Jeff Janes 03:03
Re: postgres has no spinlock support on riscv rv64imafdc Merlin Moncure 03:26
BUG #16165: Query Works fine but spam so many LOG: unrecognized win32 error code: 38 PG Bug reporting form 03:44
Re: BUG #16104: Invalid DSA Memory Alloc Request in Parallel Hash Thomas Munro 04:01
Re: postgres has no spinlock support on riscv rv64imafdc Tom Lane 04:05
Re: BUG #16165: Query Works fine but spam so many LOG: unrecognized win32 error code: 38 Juan José Santamaría Flecha 08:40
Re: BUG #16160: Minor memory leak in case of starting postgres server with SSL encryption Michael Paquier 09:24
Re: BUG #16104: Invalid DSA Memory Alloc Request in Parallel Hash Tomas Vondra 13:39
Re: BUG #16162: create index using gist_trgm_ops leads to panic Alexander Lakhin 19:00

Browse Archives

Prev | Next