pgsql-bugs since 2017-10-03 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. 3, 2017

Thread Author Time
Re: BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 Michael Paquier 03:00
bugs in date type 📎 wahib 15:40
Re: bugs in date type David G. Johnston 16:24
BUG #14841: Remove TIME WITH TIME ZONE type edpeur 19:35
Re: BUG #14841: Remove TIME WITH TIME ZONE type David G. Johnston 19:50
BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUT TIMEZONE should not be comparable edpeur 19:52
Re: BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUT TIMEZONE should not be comparable David G. Johnston 20:20
Re: BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUT TIMEZONE should not be comparable Tom Lane 20:38
Re: BUG #14841: Remove TIME WITH TIME ZONE type Eduardo Pérez Ureta 21:19
Re: BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUT TIMEZONE should not be comparable Eduardo Pérez Ureta 21:19
Re: BUG #14841: Remove TIME WITH TIME ZONE type David G. Johnston 21:42
Re: BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUT TIMEZONE should not be comparable David G. Johnston 21:54
Re: BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUT TIMEZONE should not be comparable John R Pierce 22:00
Re: [PATCH] BUG #13416: Postgres =?utf-8?Q?>=3D_?=9.3 doesn't use optimized shared memory on Solaris anymore 📎 Sean Chittenden 23:11
Re: [HACKERS] BUG #14825: enum type: unsafe use? Andrew Dunstan 23:53

Oct. 4, 2017

Thread Author Time
Re: [HACKERS] BUG #14825: enum type: unsafe use? Tom Lane 01:29
Re: [BUGS] BUG #14825: enum type: unsafe use? Andres Freund 01:38
Re: BUG #14842: TIMESTAMP WITH TIME ZONE and TIMESTAMP WITHOUT TIMEZONE should not be comparable Francisco Olarte 11:06
Re: [PATCH] BUG #13416: Postgres =?utf-8?Q?>=3D_?=9.3 doesn't use optimized shared memory on Solaris anymore Sean Chittenden 17:47
Re: Re: [PATCH] BUG #13416: Postgres >= 9.3 doesn't use optimized shared memory on Solaris anymore Andres Freund 17:56
pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Ben Chobot 20:59
Postgresql 9.6.5 not working in Windows Docker containers (both Nanoserver and WindowsServerCore base images) Paul Mendoza 23:42

Oct. 5, 2017

Thread Author Time
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Michael Paquier 05:45
Re: [HACKERS] BUG #14825: enum type: unsafe use? Robert Haas 13:45
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Tom Lane 15:38
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Andres Freund 21:10
Re: Re: [PATCH] BUG #13416: Postgres =?utf-8?Q?>=3D_?=9.3 doesn't use optimized shared memory on Solaris anymore 📎 Sean Chittenden 21:34
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Tom Lane 21:43
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Andres Freund 23:01
BUG #14843: CREATE TABLE churns through all memory, crashes db ropeladder 23:03
Re: BUG #14843: CREATE TABLE churns through all memory, crashes db Andres Freund 23:16
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Tom Lane 23:42

Oct. 6, 2017

Thread Author Time
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Andres Freund 00:59
Re: BUG #14843: CREATE TABLE churns through all memory, crashes db 📎 Michael Paquier 01:00
Re: BUG #14843: CREATE TABLE churns through all memory, crashes db ben m 01:09
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Tom Lane 01:16
Re: BUG #14843: CREATE TABLE churns through all memory, crashes db Michael Paquier 01:32
Re: BUG #14843: CREATE TABLE churns through all memory, crashes db Michael Paquier 03:57
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Andres Freund 05:21
Re: BUG #14794: Installation failure if user specify French password Noah Misch 05:50
postgresql-10.0/src/bin/psql/mainloop.c:465: suspicious condition ? David Binderman 07:21
BUG #14844: Failure/Duplicate key value with ALTER DATABASE set search_path buschmann 11:04
BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance josef.machytka 11:24
Re: BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance Feike Steenbergen 13:04
Re: BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance Fabrízio de Royes Mello 13:29
Bug in Postgresql 10.0: regexp functions return invalid cach ID: 42 Johannes Maurer 13:53
Re: Bug in Postgresql 10.0: regexp functions return invalid cach ID: 42 Tom Lane 14:27
Re: BUG #14844: Failure/Duplicate key value with ALTER DATABASE set search_path Tom Lane 14:48
Re: BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance Tom Lane 14:54
Re: postgresql-10.0/src/bin/psql/mainloop.c:465: suspicious condition ? Tom Lane 15:07
Re: postgresql-10.0/src/bin/psql/mainloop.c:465: suspicious condition ? David Binderman 15:10
postgresql-10.0/src/backend/access/transam/clog.c:234: sanity check after use ? David Binderman 15:15
postgresql-10.0/src/backend/optimizer/geqo/geqo_ox2.c:84:sanity check after use ? David Binderman 15:18
Re: postgresql-10.0/src/bin/psql/mainloop.c:465: suspicious condition ? Tom Lane 15:37
Re: BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance Josef Machytka 15:42
Re: postgresql-10.0/src/backend/access/transam/clog.c:234: sanity check after use ? Tom Lane 15:52
Re: postgresql-10.0/src/backend/optimizer/geqo/geqo_ox2.c:84:sanity check after use ? Tom Lane 16:40
Re: BUG #14844: Failure/Duplicate key value with ALTER DATABASE set search_path Hans Buschmann 16:50
Re: BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance Tom Lane 17:01
Re: BUG #14843: CREATE TABLE churns through all memory, crashes db Andres Freund 18:01
Re: BUG #14843: CREATE TABLE churns through all memory, crashes db Tom Lane 18:18
json(b)_array_elements use causes very large memory usage when also referencing entire json document Lucas Fairchild-Madar 18:26
Re: BUG #14843: CREATE TABLE churns through all memory, crashes db Andres Freund 18:27
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Tom Lane 18:30
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Lucas Fairchild-Madar 18:45
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Tom Lane 18:48
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Lucas Fairchild-Madar 19:11
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Tom Lane 19:37
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Lucas Fairchild-Madar 20:03
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Tom Lane 20:13
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql 📎 Tom Lane 21:29
How make exceptions in C# .NET with PostgreSQL? Cristian Gómez García 21:43
Re: BUG #14843: CREATE TABLE churns through all memory, crashes db Michael Paquier 22:10
Re: How make exceptions in C# .NET with PostgreSQL? Jaime Casanova 22:12
Re: How make exceptions in C# .NET with PostgreSQL? 📎 Cristian Gómez García 22:33
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Tom Lane 23:21

Oct. 7, 2017

Thread Author Time
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Andres Freund 00:21
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Tom Lane 00:28
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Tom Lane 00:36
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Andres Freund 00:36
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Tom Lane 00:44
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Andres Freund 00:49
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Tom Lane 00:51
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Andres Freund 01:22
Re: BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance Jeff Janes 01:46
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Andres Freund 02:26
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Tom Lane 02:35
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Andres Freund 02:42
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document 📎 Andres Freund 04:08
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Ben Chobot 04:24
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Andres Freund 04:29
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Andres Freund 04:31
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Ben Chobot 04:40
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Andres Freund 04:43
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Ben Chobot 04:47
Re: pg_logical_slot_peek_changes crashes postgres when called from inside pl/pgsql Andres Freund 04:51

Oct. 8, 2017

Thread Author Time
BUG #14846: Failed to load SQL modules into the database cluster. gis.dur 08:36
BUG #14847: "make check" fails 1 of 178 tests bero 10:52
Re: BUG #14847: "make check" fails 1 of 178 tests Tom Lane 15:06
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Andres Freund 20:07
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Tom Lane 20:27
Re: json(b)_array_elements use causes very large memory usage when also referencing entire json document Andres Freund 21:13
Re: BUG #14844: Failure/Duplicate key value with ALTER DATABASE set search_path Peter Geoghegan 22:47

Oct. 9, 2017

Thread Author Time
Re: BUG #14844: Failure/Duplicate key value with ALTER DATABASE set search_path Hans Buschmann 08:26
10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger Aleksander Alekseev 14:13
Re: BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 Marko Tiikkaja 14:52
Re: BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 Tom Lane 15:15

Oct. 10, 2017

Thread Author Time
Re: 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger Masahiko Sawada 02:29
Re: [BUGS] 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger 📎 Masahiko Sawada 07:53
BUG #14848: simple Query script not work rainersharp 08:44
Re: BUG #14845: postgres_fdw and mysql_fdw can cause crash of instance Josef Machytka 09:27
Re: [BUGS] 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger 📎 Aleksander Alekseev 10:26
Re: please quote POSTGRESQL Giovanni Pisante | Danysoft 11:22
Re: BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 Marko Tiikkaja 12:39
Re: 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger Petr Jelinek 13:25
Re: BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 Tom Lane 13:58
Re: BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 Alvaro Herrera 14:06
Re: BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 Marko Tiikkaja 14:09
Re: please quote POSTGRESQL John McKown 14:19
Re: BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 Tom Lane 14:19
./configure error: Cannot find a working 64-bit integer type Дилян Палаузов 14:31
Re: BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 Tom Lane 14:54
Re: ./configure error: Cannot find a working 64-bit integer type Tom Lane 15:01
Re: ./configure error: Cannot find a working 64-bit integer type Дилян Палаузов 15:19
Re: 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger Aleksander Alekseev 15:22
Re: ./configure error: Cannot find a working 64-bit integer type Alvaro Herrera 15:24
Re: ./configure error: Cannot find a working 64-bit integer type Tom Lane 16:02
Re: ./configure error: Cannot find a working 64-bit integer type 📎 Tom Lane 16:26
Re: ./configure error: Cannot find a working 64-bit integer type Andres Freund 17:05
Re: please quote POSTGRESQL John R Pierce 17:14
Re: ./configure error: Cannot find a working 64-bit integer type Tom Lane 17:18
Re: BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 📎 Tom Lane 18:07
Re: 10.0: Logical replication doesn't execute BEFORE UPDATE OF <columns> trigger Petr Jelinek 19:54
Re: BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 Tom Lane 21:25

Oct. 11, 2017

Thread Author Time
BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much marko 02:00
Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5 Lukas Eder 08:49
BUG #14850: Implement optinal additinal parameter for 'justify' date/time function kes-kes 10:35
Re: BUG #14850: Implement optinal additinal parameter for 'justify' date/time function Pavel Stehule 14:11
Re: Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5 Pavel Stehule 14:25
Re: Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5 Pantelis Theodosiou 14:39
Re: Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5 Tom Lane 15:03
Re: BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 📎 Tom Lane 17:00
Re: Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5 Tom Lane 19:51
Re: [HACKERS] Re: BUG #14821: idle_in_transaction_session_timeout sometimes gets ignored when statement timeout is pending Andres Freund 21:11
Re: BUG #14830: Missed NOTIFications, PostgreSQL 9.1.24 Marko Tiikkaja 21:16
Re: Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5 📎 David Rowley 21:17
Re: [HACKERS] Re: BUG #14821: idle_in_transaction_session_timeout sometimes gets ignored when statement timeout is pending Lukas Fittl 22:23

Oct. 12, 2017

Thread Author Time
Re: Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5 Tom Lane 02:27
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Michael Paquier 04:42
Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function 📎 KES 08:00
Re: BUG #14850: Implement optinal additinal parameter for 'justify' date/time function Arthur Zakirov 09:15
Re: BUG #14850: Implement optinal additinal parameter for 'justify' date/time function KES 10:01
Improper const-evaluation of HAVING with grouping sets and subquery pullup 📎 Heikki Linnakangas 11:59
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Andrew Dunstan 12:38
Re: Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5 Heikki Linnakangas 13:59
Re: Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function Brian Dunavant 14:37
Re: Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5 Tom Lane 14:55
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup Tom Lane 15:06
Re: Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5 📎 Tom Lane 16:34

Oct. 13, 2017

Thread Author Time
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much 📎 Michael Paquier 04:29
Re: Fwd: [BUGS] BUG #14850: Implement optinal additinal parameter for 'justify' date/time function 📎 KES 08:13
BUG #14851: Systemd kills long-running recovery gdr 09:10
BUG #14852: Refreshing materialized view might lead to a problem "could not access status of transaction" alexey.ermakov 11:53
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Dmitry Dolgov 12:46
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Michael Paquier 13:15
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Michael Paquier 13:48
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Dmitry Dolgov 13:56
BUG #14853: Parameter type is required even when the query does not need to know the type edpeur 14:03
Re: BUG #14851: Systemd kills long-running recovery Fabrízio de Royes Mello 15:23
Re: BUG #14853: Parameter type is required even when the query does not need to know the type David G. Johnston 15:38
Re: BUG #14851: Systemd kills long-running recovery John R Pierce 19:03
BUG #14854: daterange[] is an anyarray or anyrange? balazs 19:45
Re: BUG #14854: daterange[] is an anyarray or anyrange? David G. Johnston 20:24
Re: BUG #14854: daterange[] is an anyarray or anyrange? Szilfai Balázs 20:42
Re: BUG #14854: daterange[] is an anyarray or anyrange? David G. Johnston 20:52
Re: BUG #14854: daterange[] is an anyarray or anyrange? Tom Lane 22:28

Oct. 14, 2017

Thread Author Time
Re: BUG #14851: Systemd kills long-running recovery GDR! 04:56
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much 📎 Michael Paquier 10:46
Re: Combination of ordered-set aggregate function terminates JDBC connection on PostgreSQL 9.6.5 📎 Tom Lane 20:51

Oct. 15, 2017

Thread Author Time
BUG #14855: index-only scans not used in simple cases andrew 12:20
Re: Improper const-evaluation of HAVING with grouping sets and subquery pullup Andrew Gierth 12:42
Re: BUG #14855: index-only scans not used in simple cases Tom Lane 14:09
BUG #14856: pgAdmin not start dev7days 14:39
Re: BUG #14853: Parameter type is required even when the query does not need to know the type Eduardo Pérez Ureta 17:23
Re: BUG #14853: Parameter type is required even when the query does not need to know the type David G. Johnston 18:23
Re: BUG #14849: jsonb_build_object doesn't like VARIADIC calls very much Dmitry Dolgov 19:41

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

Browse Archives

Prev | Next