pgsql-bugs before 2018-07-20 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

June 21, 2018

Thread Author Time
Re: Fwd: Problem with a "complex" upsert 📎 Tom Lane 17:05

June 22, 2018

Thread Author Time
Re: Fwd: Problem with a "complex" upsert 📎 Amit Langote 08:11
Re: Fwd: Problem with a "complex" upsert Mario De Frutos Dieguez 09:15
BUG #15251: query plan affected by grant select on partition PG Bug reporting form 13:00

June 25, 2018

Thread Author Time
BUG #15252: "do not dump comments" in pg_restore help PG Bug reporting form 09:50
Re: BUG #15252: "do not dump comments" in pg_restore help 📎 Sergei Kornilov 10:26
Re: Crashed libpq.dll in a multithreaded environment in case of SSL connection + callstack csusza 13:28
Converting to UTC multiple times converts back to local time zone Gary Bernhardt 23:47

June 26, 2018

Thread Author Time
Re: Converting to UTC multiple times converts back to local time zone David G. Johnston 00:20
Re: Converting to UTC multiple times converts back to local time zone Gary Bernhardt 00:25
Re: Converting to UTC multiple times converts back to local time zone David G. Johnston 00:32
Re: Converting to UTC multiple times converts back to local time zone Gary Bernhardt 00:40
Re: Converting to UTC multiple times converts back to local time zone Tom Lane 00:52
Re: Converting to UTC multiple times converts back to local time zone David G. Johnston 00:52
Re: Converting to UTC multiple times converts back to local time zone David G. Johnston 01:03
Re: BUG #15252: "do not dump comments" in pg_restore help Michael Paquier 06:02
Found incorrect output in pg_lsclusters Pash Ebash 11:07
Server Crash Anjul Tyagi 12:47

June 27, 2018

Thread Author Time
Re: Server Crash Anjul Tyagi 08:51
Re: Server Crash Fabio Pardi 09:13
Re: Server Crash Sergei Kornilov 09:31
Re: Server Crash 📎 Anjul Tyagi 10:40
Re: Server Crash 📎 Anjul Tyagi 10:58
Re: Server Crash Fabio Pardi 11:30
BUG #15253: DROP/select/update query waiting for pg_dump PG Bug reporting form 14:01
Re: BUG #15253: DROP/select/update query waiting for pg_dump Andres Freund 15:01
Re: BUG #15253: DROP/select/update query waiting for pg_dump Jeff Janes 15:02
could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function Luca Ferrari 18:35
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function Peter Geoghegan 19:53
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function Andres Freund 20:44
BUG #15254: The configure --with-zlib option ignores zlib custom location PG Bug reporting form 20:52
Re: BUG #15254: The configure --with-zlib option ignores zlib custom location Andres Freund 21:05

June 28, 2018

Thread Author Time
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function Luca Ferrari 06:15
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function Luca Ferrari 06:26
Re: Server Crash Alexey Bashtanov 13:10
BUG #15255: notification from trigger is not delivered in a timely fashion on subscriber PG Bug reporting form 13:21
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function Andres Freund 15:02
Re: BUG #15255: notification from trigger is not delivered in a timely fashion on subscriber Andres Freund 16:20

June 29, 2018

Thread Author Time
Stop creating sessions for static web requests Yann Le-Guern 08:37
Re: BUG #15146: missing yum package: pgadmin4-python-simplejson Devrim Gündüz 14:21
Inability to init db Postgresql-9.1.1 on Ubuntu Ekaterina Dimitrova 18:46
Re: Inability to init db Postgresql-9.1.1 on Ubuntu Alvaro Herrera 19:15
Re: Inability to init db Postgresql-9.1.1 on Ubuntu Ekaterina Dimitrova 19:47
BUG #15256: Comparing if a rowtype is null PG Bug reporting form 21:06
Re: BUG #15256: Comparing if a rowtype is null David G. Johnston 21:16

June 30, 2018

Thread Author Time
Suggestion Anderson Antunes 04:59
PgAdmin - AlertityjS - Query Tool Initialize Error Nelson Castiblanco 14:45
BUG #15257: no servers listed in pgadmin3 PG Bug reporting form 15:54

July 1, 2018

Thread Author Time
Re: BUG #15193: Postgres Coredumped in AIX Noah Misch 23:20

July 2, 2018

Thread Author Time
Re: Inability to init db Postgresql-9.1.1 on Ubuntu Michael Paquier 04:10
BUG #15258: 8 gb ram PG Bug reporting form 05:01
BUG #15259: intarray extension operator "&" produces invalid dimensions [1:0] for empty arrays PG Bug reporting form 12:00
NOTIFY does not work as expected Andrey 20:33

July 3, 2018

Thread Author Time
Re: NOTIFY does not work as expected Jeff Janes 00:37
Re: NOTIFY does not work as expected Andrey 04:54
Re: NOTIFY does not work as expected Tom Lane 05:28
BUG #15260: When saving json object to a json column bigInteger value is saved wrong PG Bug reporting form 09:13
Re: BUG #15260: When saving json object to a json column bigInteger value is saved wrong Magnus Hagander 09:17
RE: BUG #15260: When saving json object to a json column bigInteger value is saved wrong Uri Parush 09:21
Re: BUG #15260: When saving json object to a json column bigInteger value is saved wrong 📎 Flo Rance 09:37
Re: BUG #15255: notification from trigger is not delivered in a timely fashion on subscriber Dan Knight-Gaynor 12:24
Re: NOTIFY does not work as expected Jeff Janes 16:30
Re: NOTIFY does not work as expected Jeff Janes 16:53
Re: NOTIFY does not work as expected Tom Lane 18:27
Re: NOTIFY does not work as expected Andres Freund 19:09

July 4, 2018

Thread Author Time
Re: NOTIFY does not work as expected Jeff Janes 01:42
BUG #15261: Insert binary data in bytea rejected due to UTF-8 encoding errors PG Bug reporting form 11:02
RE: BUG #15261: Insert binary data in bytea rejected due to UTF-8 encoding errors gpd 11:13
Re: NOTIFY does not work as expected 📎 Jeff Janes 12:50
Year 2024: Extracting week from date gives wrong results for the last two days of the year Michael Monscheuer 13:55
Re: Year 2024: Extracting week from date gives wrong results for the last two days of the year Jeff Janes 14:13
Re: Year 2024: Extracting week from date gives wrong results for the last two days of the year Félix GERZAGUET 14:14
Re: Year 2024: Extracting week from date gives wrong results for the last two days of the year Gavin Flower 17:21
Re: NOTIFY does not work as expected Andres Freund 18:30
Re: NOTIFY does not work as expected Jeff Janes 22:11

July 5, 2018

Thread Author Time
long analyze, libc bug and libicu Grigory Smolkin 15:05

July 6, 2018

Thread Author Time
Typo in Japanese translation of psql. 📎 Taiki Kondo 08:33
BUG #15262: "unexpected end of tuplestore" error when using new GROUPS window function clause PG Bug reporting form 09:04
Re: Typo in Japanese translation of psql. Yugo Nagata 09:14
Enable SSL in PostgreSQL server Anand19196 10:46
Re: BUG #14999: pg_rewind corrupts control file global/pg_control Andrew Dunstan 15:45
BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices PG Bug reporting form 16:19
BUG #15264: pg_dump / psql failure. When loading, psql fails to create TEXT SEARCH dictionaries. PG Bug reporting form 17:04
BUG #15265: The program "initdb" is needed by pg_ctl but was not found in the same directory as "pg_ctl". PG Bug reporting form 18:10
Re: BUG #15265: The program "initdb" is needed by pg_ctl but was not found in the same directory as "pg_ctl". Tom Lane 20:02
Incorrect interpretation of time zone "Africa/Sao_Tome" on PG 9.6? Philippe Lavoie-Mongrain 22:23
Re: Incorrect interpretation of time zone "Africa/Sao_Tome" on PG 9.6? Alvaro Herrera 22:36
Re: BUG #14999: pg_rewind corrupts control file global/pg_control Michael Paquier 23:12

July 7, 2018

Thread Author Time
Re: BUG #15265: The program "initdb" is needed by pg_ctl but was not found in the same directory as "pg_ctl". Mohammed Shahid Nawaz 06:00
Re: long analyze, libc bug and libicu Peter Eisentraut 07:10
Re: BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices Peter Eisentraut 07:14
Re: long analyze, libc bug and libicu 📎 Grigory Smolkin 09:18
Re: long analyze, libc bug and libicu Stephen Frost 14:16
Re: long analyze, libc bug and libicu Tom Lane 14:35
Re: BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices Tom Lane 14:48
Re: BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices ceccareb@talusmusic.com 14:50
BUG #15266: libpq: PQgetvalue fails with Break at address "0x8000fb50" Signal : SIGSEGV:Segmentation fault) PG Bug reporting form 23:07

July 8, 2018

Thread Author Time
Re: BUG #15266: libpq: PQgetvalue fails with Break at address "0x8000fb50" Signal : SIGSEGV:Segmentation fault) Michael Paquier 00:26
BUG #15267: just for test PG Bug reporting form 01:15
BUG #15268: Documentation surrounding sysvipc configuration and isolation is out-of-date as of FreeBSD 11 PG Bug reporting form 09:50
Re: BUG #15268: Documentation surrounding sysvipc configuration and isolation is out-of-date as of FreeBSD 11 Thomas Munro 22:01

July 9, 2018

Thread Author Time
Re: Typo in Japanese translation of psql. Michael Paquier 01:59
RE: Typo in Japanese translation of psql. Taiki Kondo 07:09
Re: BUG #15265: The program "initdb" is needed by pg_ctl but was not found in the same directory as "pg_ctl". Mohammed Shahid Nawaz 08:54
Re: BUG #15265: The program "initdb" is needed by pg_ctl but was not found in the same directory as "pg_ctl". Aaron W. Swenson 09:54
Re: BUG #15265: The program "initdb" is needed by pg_ctl but was not found in the same directory as "pg_ctl". Mohammed Shahid Nawaz 09:59
cannot restore schema with is not distinct from on hstore since PG 9.6.8 Marc Cousin 13:52
LLVM jit and matview Dmitry Dolgov 14:04
Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 Tom Lane 15:34
Re: BUG #15268: Documentation surrounding sysvipc configuration and isolation is out-of-date as of FreeBSD 11 Daniel Ebdrup 16:19
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function Peter Geoghegan 16:59
BUG #15269: Can't reassign bg color to server group once it was done previously PG Bug reporting form 17:42
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function Andres Freund 18:32
BUG #15270: __builtin_isinf conflict when building using clang PG Bug reporting form 19:00
Re: could not read block 0 in file : read only 0 of 8192 bytes when doing nasty on immutable index function Peter Geoghegan 19:06
Re: BUG #15262: "unexpected end of tuplestore" error when using new GROUPS window function clause Tom Lane 22:29

July 10, 2018

Thread Author Time
Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 Andrew Dunstan 00:06
Re: LLVM jit and matview Michael Paquier 00:19
Extension relocation vs. schema qualification Noah Misch 01:43
Re: BUG #15262: "unexpected end of tuplestore" error when using new GROUPS window function clause Lukas Eder 07:29
BUG #15271: Documentation / Error reporting on GUC parameter change PG Bug reporting form 08:59
BUG #15272: creating an index function terminate with error PG Bug reporting form 13:49
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Ashutosh Bapat 13:50
Re: BUG #15272: creating an index function terminate with error Tom Lane 13:58
BUG #15273: Lexer bug with UESCAPE PG Bug reporting form 17:15
Re: BUG #15273: Lexer bug with UESCAPE Tom Lane 19:50
Problem with tupdesc in jsonb_to_recordset 📎 Dmitry Dolgov 20:39
Re: Fwd: Problem with a "complex" upsert Tom Lane 20:59
Re: BUG #15251: query plan affected by grant select on partition Tom Lane 22:47

July 11, 2018

Thread Author Time
Re: Problem with tupdesc in jsonb_to_recordset Michael Paquier 06:27
Re: Problem with tupdesc in jsonb_to_recordset 📎 Michael Paquier 07:39
RE: Typo in Japanese translation of psql. Taiki Kondo 07:58
BUG #15274: error LOG: server process (PID 13723) was terminated by signal 11: Segmentation fault PG Bug reporting form 08:33
Re: BUG #15274: error LOG: server process (PID 13723) was terminated by signal 11: Segmentation fault Heikki Linnakangas 08:40
Re: Problem with tupdesc in jsonb_to_recordset Dmitry Dolgov 09:33
Re: Problem with tupdesc in jsonb_to_recordset Andrew Gierth 10:38
Re: Problem with tupdesc in jsonb_to_recordset Michael Paquier 11:30
Re: BUG #15273: Lexer bug with UESCAPE Andrew Gierth 12:03
BUG #15275: Trigger don't take supperuser role into account to create role PG Bug reporting form 17:14
Re: BUG #15275: Trigger don't take supperuser role into account to create role Andres Freund 17:21
BUG #15276: pl/pgSQL function caches wrong plan PG Bug reporting form 17:45
Re: BUG #15273: Lexer bug with UESCAPE Tom Lane 21:05
Re: BUG #15273: Lexer bug with UESCAPE Tom Lane 21:15

July 12, 2018

Thread Author Time
BUG #15277: ts_headline strips things that look like HTML tags and it cannot be disabled PG Bug reporting form 07:59
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation 📎 Amit Langote 08:59
Re: BUG #15277: ts_headline strips things that look like HTML tags and it cannot be disabled Arthur Zakirov 09:22
Re: BUG #15277: ts_headline strips things that look like HTML tags and it cannot be disabled Dan Book 15:33
pg_restore: All GRANTs on table fail when any one role is missing Moshe Jacobson 19:48
Re: pg_restore: All GRANTs on table fail when any one role is missing Tom Lane 22:07

July 13, 2018

Thread Author Time
Re: BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices Peter Eisentraut 08:19
function lca('{}'::ltree[]) caused DB Instance crash 📎 李海龙 10:09
Re: function lca('{}'::ltree[]) caused DB Instance crash 📎 Pierre Ducroquet 10:48
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Ashutosh Bapat 13:50
Re: function lca('{}'::ltree[]) caused DB Instance crash Tom Lane 14:26
Fwd: SQL Łukasz Jarych 14:48
Re: Fwd: SQL Tom Lane 16:10
Re: Problem with tupdesc in jsonb_to_recordset Tom Lane 17:22
Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 Tom Lane 20:54
Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 David G. Johnston 21:17
Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 Tom Lane 21:23
Re: cannot restore schema with is not distinct from on hstore since PG 9.6.8 Andrew Dunstan 22:16
Re: function lca('{}'::ltree[]) caused DB Instance crash Tom Lane 22:50
Re: [ltree] Should `SELECT LCA('1.2', '1.2.3');` return '1.2' instead of '1'? Tom Lane 22:54

July 16, 2018

Thread Author Time
BUG #15278: When initialising Streaming Slave if some folders and files are symlinks they are not copied over PG Bug reporting form 08:34
BUG #15279: GSSAPI Authentication? PG Bug reporting form 11:51
Re: BUG #15278: When initialising Streaming Slave if some folders and files are symlinks they are not copied over Michael Paquier 12:49
Re: BUG #15279: GSSAPI Authentication? Michael Paquier 12:52
Re: BUG #15278: When initialising Streaming Slave if some folders and files are symlinks they are not copied over 📎 Areg Vrtanesyan 12:55
BUG #15280: Clang 6.0.1 compiler warning - strlcpy PG Bug reporting form 13:50
BUG #15281: Set role does not affect superuser privleges PG Bug reporting form 14:55
Re: BUG #15280: Clang 6.0.1 compiler warning - strlcpy Tom Lane 15:27
RE: BUG #15280: Clang 6.0.1 compiler warning - strlcpy Steven Winfield 16:58
Re: BUG #15281: Set role does not affect superuser privleges Tomas Vondra 21:48
Re: BUG #15281: Set role does not affect superuser privleges Tom Lane 22:12
Re: BUG #15281: Set role does not affect superuser privleges Tomas Vondra 23:26

July 17, 2018

Thread Author Time
BUG #15282: Materialized view with transitive TYPE dependency fails refresh using pg_restore and psql PG Bug reporting form 15:19
Re: pg_restore: All GRANTs on table fail when any one role is missing Moshe Jacobson 16:02
Re: BUG #15282: Materialized view with transitive TYPE dependency fails refresh using pg_restore and psql Tom Lane 17:11

July 18, 2018

Thread Author Time
Autovacuum analyze can't find C based function Thomas Butz 09:14
PostgreSQL :: Catalog Query Yogi S 10:22
Re: PostgreSQL :: Catalog Query Thomas Kellerer 12:52
BUG #15283: Query Result equal 0 for partitioned table PG Bug reporting form 12:59
Re: PostgreSQL :: Catalog Query Tom Lane 13:48
Re: Autovacuum analyze can't find C based function Tom Lane 13:55
Re: BUG #15282: Materialized view with transitive TYPE dependency fails refresh using pg_restore and psql Keith Hickey 14:37
Re: BUG #15282: Materialized view with transitive TYPE dependency fails refresh using pg_restore and psql Tom Lane 15:17
Re: BUG #15282: Materialized view with transitive TYPE dependency fails refresh using pg_restore and psql Keith Hickey 15:35
Re: BUG #15282: Materialized view with transitive TYPE dependency fails refresh using pg_restore and psql Tom Lane 16:07
Re: BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices 📎 firstname lastname 21:47
Re: BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices Alvaro Herrera 22:04
Re: BUG #15263: pg_dump / psql failure. When loading, psql does not see function-based constraints or indices David G. Johnston 22:10

July 19, 2018

Thread Author Time
Re: BUG #15283: Query Result equal 0 for partitioned table Amit Langote 04:44
BUG #15284: SSL connection is off PG Bug reporting form 04:45
Re: Autovacuum analyze can't find C based function Thomas Butz 08:29
Domain: Peer's Certificate has expired Quân Vũ Quốc 08:44
Re: BUG #15284: SSL connection is off Tom Lane 14:20
BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows PG Bug reporting form 16:03
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Peter Geoghegan 16:44
Fwd: BUG #15182: Canceling authentication due to timeout aka Denial of Service Attack Jeremy Schneider 23:17
Re: BUG #15285: Query used index over field with ICU collation in some cases wrongly return 0 rows Peter Geoghegan 23:26

Browse Archives

Prev | Next