pgsql-bugs since 2017-10-16 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

Oct. 16, 2017

Thread Author Time
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Michael Paquier 00:08
Re: Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5 📎 Tom Lane 03:11
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup Andrew Gierth 03:50
Re: BUG #14853: Parameter type is required even when the query does not need to know the type Eduardo Pérez Ureta 05:40
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup Andrew Gierth 06:48
Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)? Michael Paquier 08:58
Re: BUG #14853: Parameter type is required even when the query does not need to know the type Pavel Stehule 10:20
BUG #14857: Typo in pg_dump italian translation lelegaifax 12:14
Re: BUG #14853: Parameter type is required even when the query does not need to know the type David G. Johnston 14:03
BUG #14858: Inaccurate estimations after bulk delete and bulk insert stanislaw.skonieczny 14:06
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup Tom Lane 14:24
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup Andrew Gierth 15:11
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup Tom Lane 15:15
Re: BUG #14853: Parameter type is required even when the query does not need to know the type Eduardo Pérez Ureta 15:24
Re: BUG #14853: Parameter type is required even when the query does not need to know the type David G. Johnston 15:39
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup Andrew Gierth 15:41
Re: BUG #14853: Parameter type is required even when the query does not need to know the type Pavel Stehule 15:49
Re: BUG #14858: Inaccurate estimations after bulk delete and bulk insert Alvaro Herrera 16:27
Re: BUG #14853: Parameter type is required even when the query does not need to know the type Tomas Vondra 16:32
Re: BUG #14853: Parameter type is required even when the query does not need to know the type Eduardo Pérez Ureta 17:39
Re: BUG #14853: Parameter type is required even when the query does not need to know the type Eduardo Pérez Ureta 17:39
Re: BUG #14853: Parameter type is required even when the query does not need to know the type Eduardo Pérez Ureta 17:43
Re: BUG #14853: Parameter type is required even when the query does not need to know the type Tomas Vondra 18:09
Re: BUG #14853: Parameter type is required even when the query does not need to know the type David G. Johnston 18:25
Re: BUG #14853: Parameter type is required even when the query does not need to know the type Tom Lane 18:33

Oct. 17, 2017

Thread Author Time
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup Heikki Linnakangas 07:44
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup Andrew Gierth 09:16
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup Andrew Gierth 09:50
BUG #14859: Config file parsing is allergic to spaces on last line of file boatcoder 14:18
Re: BUG #14859: Config file parsing is allergic to spaces on last line of file Tom Lane 14:44
Re: BUG #14859: Config file parsing is allergic to spaces on last line of file David G. Johnston 14:58
Re: BUG #14859: Config file parsing is allergic to spaces on last line of file Tom Lane 15:28
pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI Eric Joniec 16:51
Re: pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI Devrim Gündüz 18:39
Re: pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI Andres Freund 18:44
Re: pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI Magnus Hagander 18:49
Re: pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI Andres Freund 18:50
Re: pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI Daniel Farina 19:11

Oct. 18, 2017

Thread Author Time
Re: pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI Magnus Hagander 08:17
pg_read_all_stats and pg_stat_replication in postgres 10. Mahadevan R 12:16
BUG #14860: pg_read_all_stats and pg_stat_replication mdevan.r 12:40
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup Tom Lane 15:04
BUG #14861: Handle syntax_error andrey_shvidky 15:32
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup 📎 Tom Lane 15:42
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 15:46
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Dmitry Dolgov 15:47
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 17:54
ON COMMIT DROP unstable behaviour Ian R. Campbell 20:12
Re: ON COMMIT DROP unstable behaviour David G. Johnston 21:09

Oct. 19, 2017

Thread Author Time
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much 📎 Michael Paquier 02:07
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup Andrew Gierth 04:19
Re: pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI Daniel Farina 05:47
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 13:13
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much 📎 Michael Paquier 15:25
BUG #14862: create table with missing sequence bug gezeala 17:04
Re: BUG #14862: create table with missing sequence bug Tom Lane 17:46
Re: BUG #14862: create table with missing sequence bug mgbii bax 18:33
Re: BUG #14861: Handle syntax_error Pavel Stehule 19:01
BUG #14863: wrong reltuples statistics after vacuum without analyze psuderevsky 23:14
Re: BUG #14863: wrong reltuples statistics after vacuum without analyze Alvaro Herrera 23:58

Oct. 20, 2017

Thread Author Time
Re: pgbouncer-1.7.2-7.rhel6.x86_64.rpm fails to install on AMI Magnus Hagander 08:57
BUG #14864: PostgresSQL script is skipping to process random records bharti.bhandari 13:18
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 13:49

Oct. 21, 2017

Thread Author Time
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much 📎 Michael Paquier 03:40
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Tom Lane 15:43
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Michael Paquier 16:10
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Tom Lane 16:43
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Michael Paquier 23:33

Oct. 22, 2017

Thread Author Time
BUG #14865: plpythonu marciofarah 13:11
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 13:19
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 16:11
Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 16:44
Connections hang indefinitely while taking a LWLockTranche buffer_content lock. Chris Hanks 18:23
Re: Connections hang indefinitely while taking a LWLockTranche buffer_content lock. Tom Lane 18:39
Re: Connections hang indefinitely while taking a LWLockTranche buffer_content lock. Chris Hanks 19:23
Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Michael Paquier 20:35
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much 📎 Andrew Dunstan 20:50
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Tom Lane 21:11
Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Michael Paquier 22:03

Oct. 23, 2017

Thread Author Time
BUG #14866: The generated constraint in the typed table causes the server to crash gomer94 07:44
[pg_dump] not dumping some default privileges 📎 Reinier Haasjes 11:13
Re: [pg_dump] not dumping some default privileges Alvaro Herrera 12:54
Re: [pg_dump] not dumping some default privileges Feike Steenbergen 13:16
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much 📎 Michael Paquier 13:50
Re: [pg_dump] not dumping some default privileges Alvaro Herrera 14:03
Re: BUG #14866: The generated constraint in the typed table causes the server to crash Michael Paquier 14:09
Re: [pg_dump] not dumping some default privileges Reinier Haasjes 14:12
BUG #14867: Cascade drop type error gomer94 15:01
Re: BUG #14867: Cascade drop type error Tom Lane 16:09
Re: BUG #14867: Cascade drop type error Andres Freund 16:17
Re: BUG #14867: Cascade drop type error Tom Lane 16:33
Re: Connections hang indefinitely while taking a LWLockTranche buffer_content lock. Chris Hanks 16:38
Re: Connections hang indefinitely while taking a LWLockTranche buffer_content lock. Tom Lane 16:49
Re: Connections hang indefinitely while taking a LWLockTranche buffer_content lock. Peter Geoghegan 16:55
Re: Connections hang indefinitely while taking a LWLockTranche buffer_content lock. Chris Hanks 17:39
Re: BUG #14866: The generated constraint in the typed table causes the server to crash 📎 Michael Paquier 22:21

Oct. 24, 2017

Thread Author Time
BUG #14868: Postgres as Windows Service doesn't shutdown properly tschimail1 09:20
Possible regression in 'UPDATE ... SET (<column list>) = <row expression>' with just one single column/row value since v10 YasonTR 12:00
Re: BUG #14863: wrong reltuples statistics after vacuum without analyze 📎 Pavel Suderevsky 13:11
Re: Possible regression in 'UPDATE ... SET (<column list>) = <row expression>' with just one single column/row value since v10 Tom Lane 14:18
Re: Possible regression in 'UPDATE ... SET (<column list>) = <row expression>' with just one single column/row value since v10 YasonTR 14:55
Re: Possible regression in 'UPDATE ... SET (<column list>) = <row expression>' with just one single column/row value since v10 David G. Johnston 15:07
Re: Possible regression in 'UPDATE ... SET (<column list>) = <row expression>' with just one single column/row value since v10 Tom Lane 15:21
Re: Possible regression in 'UPDATE ... SET (<column list>) = <row expression>' with just one single column/row value since v10 YasonTR 15:47
BUG #14870: wrong query results when using WITH with UPDATE andreigorita 15:53
BUG #14871: RLS join query plan banzaitron 23:31

Oct. 25, 2017

Thread Author Time
Segfault 11 on PG10 with max_parallel_workers_per_gather>3 Stefan Tzeggai 12:16
Re: Segfault 11 on PG10 with max_parallel_workers_per_gather>3 Tom Lane 14:34
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Michael Paquier 15:32
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup 📎 Tom Lane 19:29
BUG #14872: libpq requires a home directory dcwatson 20:04
Re: Segfault 11 on PG10 with max_parallel_workers_per_gather>3 📎 Stefan Tzeggai 20:33
Re: Segfault 11 on PG10 with max_parallel_workers_per_gather>3 Tom Lane 20:41
Re: BUG #14872: libpq requires a home directory David G. Johnston 21:37
Re: BUG #14872: libpq requires a home directory Tom Lane 21:40
Re: BUG #14872: libpq requires a home directory Tom Lane 22:10
Re: BUG #14872: libpq requires a home directory Michael Paquier 22:35
Re: BUG #14872: libpq requires a home directory Tom Lane 22:40

Oct. 26, 2017

Thread Author Time
Re: [BUGS] BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Marko Tiikkaja 01:04
Re: BUG #14872: libpq requires a home directory Michael Paquier 05:20
BUG #14873: table_constraint description missing in ALTER TABLE synopsis postgresql 09:44
Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)? 📎 Kyotaro HORIGUCHI 10:05
BUG #14874: Dublicate values in primary key sideuxb-ky.consultant 15:16
Re: BUG #14874: Dublicate values in primary key Peter Geoghegan 16:53
BUG #14875: pg_createcluster fails to load --createclusterconf bouellette 17:45
Re: [BUGS] Bug in Physical Replication Slots (at least 9.5)? Michael Paquier 18:13
Segmentation fault with JSONB column from view passed into stored PL/PGSQL procedure that builds a new JSON return value Samuel Horwitz 18:26
BUG #14876: Segmentation fault with JSONB column used in store proc that gets used by view and later altered samuel.horwitz 18:40
Re: BUG #14876: Segmentation fault with JSONB column used in store proc that gets used by view and later altered Dmitry Dolgov 19:09
Re: BUG #14876: Segmentation fault with JSONB column used in store proc that gets used by view and later altered 📎 Michael Paquier 19:24
Re: Segmentation fault with JSONB column from view passed into stored PL/PGSQL procedure that builds a new JSON return value David G. Johnston 20:23
Re: BUG #14876: Segmentation fault with JSONB column used in store proc that gets used by view and later altered 📎 Tom Lane 20:42
Re: BUG #14876: Segmentation fault with JSONB column used in store proc that gets used by view and later altered 📎 Tom Lane 22:04
Re: Connections hang indefinitely while taking a LWLockTranche buffer_content lock. Peter Geoghegan 23:14
Re: Connections hang indefinitely while taking a LWLockTranche buffer_content lock. Chris Hanks 23:42

Oct. 27, 2017

Thread Author Time
Re: BUG #14873: table_constraint description missing in ALTER TABLE synopsis Amit Langote 00:49
Creating a table by loading a sql file. rhodesm4 04:55
Re: Creating a table by loading a sql file. Devrim Gündüz 08:18
Parameters bgwriter_lru_maxpages Comment error? joan_he@189.cn 09:46
Re: BUG #14874: Dublicate values in primary key CONCHY Elisabeth 11:01
BUG #14877: DISCARD ALL incorrectly resets user parameters dmitriy 13:21
Re: BUG #14877: DISCARD ALL incorrectly resets user parameters Fabrízio de Royes Mello 13:43
Re: BUG #14877: DISCARD ALL incorrectly resets user parameters David G. Johnston 14:05
Re: BUG #14877: DISCARD ALL incorrectly resets user parameters Fabrízio de Royes Mello 14:22
Re: BUG #14877: DISCARD ALL incorrectly resets user parameters David G. Johnston 14:26
ORDER BY $1 behaves inconsistently Jordan Lewis 16:18
Re: ORDER BY $1 behaves inconsistently Jordan Lewis 16:53
Re: ORDER BY $1 behaves inconsistently Tom Lane 18:33
pg_trgm word_similarity inconsistencies or bug Cristiano Coelho 18:48
Re: ORDER BY $1 behaves inconsistently Jordan Lewis 21:05
Re: BUG #14874: Dublicate values in primary key Tom Lane 23:01

Oct. 28, 2017

Thread Author Time
Re: BUG #14876: Segmentation fault with JSONB column used in store proc that gets used by view and later altered Michael Paquier 00:37
Re: BUG #14876: Segmentation fault with JSONB column used in store proc that gets used by view and later altered Tom Lane 01:09
BUG #14878: pg_trgm - word_similarity() inconsistent with description. jan.przemyslaw.wojcik 01:10
Re: BUG #14874: Dublicate values in primary key Peter Geoghegan 02:06
Re: BUG #14876: Segmentation fault with JSONB column used in store proc that gets used by view and later altered Michael Paquier 03:14
Re: BUG #14874: Dublicate values in primary key Tom Lane 03:56
Re: pg_trgm word_similarity inconsistencies or bug Arthur Zakirov 08:22

Oct. 30, 2017

Thread Author Time
Re: BUG #14874: Dublicate values in primary key Henri KY 11:14
BUG #14879: Bug connected with table structure modification and trigger function query plan invalidation konst583 12:53
Re: pg_trgm word_similarity inconsistencies or bug Alexander Korotkov 18:08
BUG #14880: pg_dump doesn't run or crashes immediately miha 18:34
Re: Tonight 8:45pm? Messaging 18:39
Re: Parameters bgwriter_lru_maxpages Comment error? Vik Fearing 22:46

Oct. 31, 2017

Thread Author Time
BUG #14882: pgadmin 4 jonas_s.o.s 00:12
Re: BUG #14882: pgadmin 4 John R Pierce 00:31
Re: BUG #14882: pgadmin 4 Gavin Flower 00:35
BUG #14883: Syntax SQL error (42601), but should be a different error no stefan.hanenberg 00:36
Re: BUG #14883: Syntax SQL error (42601), but should be a different error no David Rowley 01:35
Re: BUG #14883: Syntax SQL error (42601), but should be a different error no David G. Johnston 02:07
Re: BUG #14883: Syntax SQL error (42601), but should be a different error no Tom Lane 02:50
Re: Segfault 11 on PG10 with max_parallel_workers_per_gather>3 Stefan Tzeggai 12:09
Re: pg_trgm word_similarity inconsistencies or bug Jan Przemysław Wójcik 13:02
Re: pg_trgm word_similarity inconsistencies or bug Alexander Korotkov 15:25
Re: BUG #14874: Dublicate values in primary key Henri KY 15:52

Nov. 1, 2017

Thread Author Time
Re: BUG #14866: The generated constraint in the typed table causes the server to crash Peter Eisentraut 13:36
Re: BUG #14866: The generated constraint in the typed table causes the server to crash Michael Paquier 14:05

Nov. 2, 2017

Thread Author Time
BUG #14884: Encoding Error sathishr 07:57
Re: Creating a table by loading a sql file. Oleksandr Shulgin 09:57
BUG #14885: mistake in sorting win1251 chars k.daskalov.911 09:57
Re: BUG #14884: Encoding Error Tomas Vondra 13:45
Re: BUG #14885: mistake in sorting win1251 chars Tomas Vondra 13:48
Re: BUG #14885: mistake in sorting win1251 chars Francisco Olarte 15:38
Re: BUG #14885: mistake in sorting win1251 chars Kalin Daskalov 17:27
Re: BUG #14885: mistake in sorting win1251 chars Pavel Stehule 17:31

Nov. 3, 2017

Thread Author Time
Re: BUG #14885: mistake in sorting win1251 chars Francisco Olarte 07:22
Re: BUG #14883: Syntax SQL error (42601), but should be a different error no Stefan Hanenberg 11:09
Re: BUG #14885: mistake in sorting win1251 chars Kalin Daskalov 11:18
Re: BUG #14883: Syntax SQL error (42601), but should be a different error no David G. Johnston 14:12
Re: BUG #14885: mistake in sorting win1251 chars Francisco Olarte 16:44
permissions denial to superuser with foreign keys Jeff Janes 19:42
Re: permissions denial to superuser with foreign keys Tom Lane 19:47

Nov. 5, 2017

Thread Author Time
BUG #14887: initdb.exe seems to be infected by a virus vtap 18:33
Re: BUG #14887: initdb.exe seems to be infected by a virus John R Pierce 19:23

Nov. 6, 2017

Thread Author Time
BUG #14888: Need to recheck contraints dmigowski 05:50
Re: BUG #14888: Need to recheck contraints Piotr Stefaniak 06:48
Re: BUG #14888: Need to recheck contraints Daniel Migowski 06:50
BUG #14889: explain analyze is taking much more time than actual execution mahmoud.alorfaly 06:50
Re: BUG #14889: explain analyze is taking much more time than actual execution David Rowley 07:59
Re: BUG #14889: explain analyze is taking much more time than actual execution mahmoud alorfaly 08:04

Browse Archives

Prev | Next